Question: A relation has four fields: A , B , C , and D , where AB is the only key. What normal form ( 3

A relation has four fields: A, B, C, and D, where AB is the only key. What normal form (3NF, BCNF or neither) is the relation in if
a) A, B, C, D are each functionally dependent on AB?(i.e., AB->A, AB->B, AB->C, AB->D)
b) A, B, C, D are each functionally dependent on AB, while D is functionally dependent on C?
c) A, B, C, D are each functionally dependent on AB, while D is functionally dependent on B?
d) A, B, C, D are each functionally dependent on AB, while B is functionally dependent on C?

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 Programming Questions!