Answers - For Question 6 -> Answer is 3 NF Candidate Keys are -> (AB), (C), (AD) For Question 7 -> Answer is BCNF Candidate Keys are -> (A) For Question 8 -> Answer is 2 NF Candidate Keys are -> (CA), (CB) For Question 9 -> Answer is BCNF Candidate Keys are -> (AB),(BC),(AC)
@@allaboutcseAll the attributes are key attributes, so in dependency one key attribute depends other It's similar to second problem, so the answer will be BCNF Is it correct or not?
@@vidhyalakshmi9956 So in question no 6 Keys are AB, C and AD, making each attribute key attribute. First 3 dependencies are normal since determinant is key itself. 4th dependency D->B is key attribute determining key attribute which is know as violation of BCNF/ overlapping keys. That is why relation R is in 3NF but not in BCNF. Please go ahead and checkout the BCNF related videos from playlist.
3:02 you said key and non key attribute determining a non key attribute is not transitive dependency but in your 3NF video you said it is transitive dependency. Can you or someone please explain?
youtube.com/@sanyarungta7335 Glad that you asked this question. at 3:02 itself I am saying two different things by mentioning the 3Nf video abt Transitive dependency. Let me explain it again here, Case 1: a key attribute(mind it, its not key but just the key attribute) + non key attribute --> (determining) non key attribute is Transitive dependency. Case 2: Key(it is complete key not part of a key)+ non key attribute --> (determining) non key attribute is NOT Transitive dependency. In case 2 determinant becomes a super key ( full Key + any non key attribute). I explained this too in the video. Check & write back if you still have doubt.👍
very very nice session. perfect explanation. very helpful. pls let me know if my answers are right Q6 3NF Q7 BCNF Q8 1NF Q9 BCNF. thnx and regards mam.
We need to include E in AC to form the key, since E is not part of any FD. Otherwise also AC is capable of determining ABCD only not complete R(ABCDE). I hope it is clear.
For Question 8 - > I think the answer should be 2 NF , as Candidate Keys are - (AC) , (BC) so key attributes - {A,B,C} Non Key Attributes are- {D,E} Now we come to Functional Dependency [A-> B ] (Violation Of BCNF) [B->A] (Violation of BCNF) [AC->D] ( as AC is CK ,so it is in BCNF) [D->E] (Transitive Dependency ) , hence not in 3NF So highest Normal Form is 2NF
@@nandiniarpit what are those? Ask.. and these are practice questions...its better first you understand from normal forms videos and then attempt solving questions. 👍