Answer to Question #268948 in Databases | SQL | Oracle | MS Access for Dragoon

Question #268948

Consider the following relation with set of functional dependencies


R(ABCDEF)


AB->CD, CD->EF, BC->DEF, D->B, CE->F


a) Identify the candidate keys in the above relation (with proper steps followed).


b) Identify which normal form this relation is in and reason for the answer.

1
Expert's answer
2021-11-20T12:36:14-0500

From the given functional dependencies

R(ABCDEF) AB->CD, CD->EF, BC->DEF, D->B, CE->F

Now,

"AB\\rightarrow CD"

and "CD\\rightarrow EF"

so, "AB\\rightarrow ABCDEF"

hence, from the above, we can conclude that the primary key will be "AB"

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS