Thursday, November 23, 2023

If every non-key attribute is functionally dependent on the primary key, then the relation is in .......


 Answer: Second normal Form

A relation is in second normal form (2NF) if and only if it is in 1NF and every non-key attribute is fully dependent on the primary key.

A relation R is in first normal form (1NF) if and only if all underlying domains contain atomic values only.

A relation R is in third normal form (3NF) if and only if it is in 2NF and every non-key attribute is non-transitively dependent on the primary key.

0 comments:

Post a Comment

Data Structures with C++



NET/SET/CS PG



Operating Systems



Computer Networks



JAVA



Design and Analysis of Algorithms



Programming in C++

Top