What does the 5NF form of normalization say?

Options
- Tables cannot have multi-valued dependencies on a Primary Key.
- The database should be in 3NF and all tables can have only one primary key
- There should be no cyclic dependencies in a composite key
- all attributes within the entity should depend solely on the entity's unique identifier.

CORRECT ANSWER : There should be no cyclic dependencies in a composite key

Discussion Board
Database Adiministrator

Very very love test of online exam

Tesfaye Gezachew 04-23-2019 09:35 AM

Explanation.

Answer : There should be no cyclic dependencies in a composite key.

Fifth normal form, also known as join-projection normal form (JPNF), states that no non-trivial join dependencies exist. 5NF states that any fact should be able to be reconstructed without any anomalous results in any case, regardless of the number of tables being joined. A 5NF table should have only candidate keys and it’s primary key should consist of only a single column.
An entity must be in Fourth Normal Form.

Jayesh Sonar 03-2-2015 10:58 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲