in Databases
367 views
2 votes
2 votes

Since the schema is already in 3NF we can keep the relations to 1, cant we? If you think the answer is different please explain how

in Databases
by
367 views

6 Comments

Is the given relation even in 2NF?
0
0
it is in 3NF, it satisfies all the conditions
0
0
edited by

@h4kr

Isn’t $AB \rightarrow D$ partial dependency due to presence of $B \rightarrow D$?

0
0
A,B & D are PA, so B → D isn’t PD
1
1

@h4kr Yes right the given relation is already in 3NF

0
0
the answer given for the above question is 2 btw. They have divided the table into ABC and BD. Why is that so?
0
0

Please log in or register to answer this question.