Question: ( a ) Consider the relation R = ( A , B , C , D ) with the following functional dependencies. ( FD 1

(a) Consider the relation R=(A,B,C,D) with the following functional
dependencies.
(FD1) A B
(FD2)CD
(i) Determine the candidate key(s) of R.
(2 marks)
(ii) Determine the highest normal form R is in. Explain your answer. (For
example, if you think that R is in 3NF, then you should explain why it
is in 3NF and why it is not in BCNF.)
(3 marks)
 (a) Consider the relation R=(A,B,C,D) with the following functional dependencies. (FD1)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!