177 reputation
28
bio website
location
age
visits member for 2 years, 9 months
seen Jul 8 at 12:30

Jul
2
awarded  Curious
Nov
21
awarded  Notable Question
May
22
awarded  Citizen Patrol
May
22
awarded  Constituent
May
21
awarded  Caucus
Feb
20
awarded  Popular Question
Jan
28
accepted Importance of ER Diagrams
Jan
25
awarded  Critic
Dec
23
accepted Confusion in BCNF
Dec
19
asked Importance of ER Diagrams
Dec
17
accepted Is normalization process needed?
Dec
4
asked Is normalization process needed?
Nov
22
comment Confusion in BCNF
@JNK: I am not getting it.
Nov
22
comment Confusion in BCNF
I read the wiki article on BCNF but the example given there are not clear and i am also having questions in their examples. The examples i am facing frequently is (AB->C) and (C->B). Then it is transitive dependency which will be removed in 3NF. so what to do in BCNF ? I am not getting any continuous example where all the normalization forms are derived from the one case study. That's the reason i posted question here.
Nov
22
comment Confusion in BCNF
Thanks for reply. I read about it and i came to conclusion that a relation is in BCNF iff "every determinant is the candidate key". Now i am not getting your third point which is overlapping candidate keys. What is it ?
Nov
22
asked Confusion in BCNF
Oct
19
comment Query regarding normalization of the relations
I talking about all kind of normalization. If we get the database already in 5NF from erd then why do we need to think of normalization ?
Oct
19
asked Query regarding normalization of the relations
Oct
19
comment Right Full Outer Join Query
@onedaywhen: Thanks for reply. can you please give me an example when NULL values can be harmful ? Well i don't know much about in what way it can cause dangers so that if u can give a good example then i can understand it very well.
Oct
19
awarded  Scholar