164 views
0 votes
0 votes

If all the coloums present in a given table represent simple attributes and all candidate  keys are composed of just one coloumn ,in which worst normal form is this table why? 

1 Answer

0 votes
0 votes
2NF

A relation is in 2NF if it is in 1NF and every non-prime attribute of the relation is dependent on the whole of every candidate key.

As all candidate keys consist of only one column, there will be no case where any attribute is partially dependent on candidate key and it is in 1 NF as all attributes are simple, thus in the worst case it can be in 2 NF.

No related questions found