Form which is considered as adequate for normal relational database design - 3NF

Q.  Which of the following forms is considered as adequate for normal relational database design?
- Published on 16 Jun 15

a. 1NF
b. 5NF
c. 4 NF
d. 3NF

ANSWER: 3NF
 
There is not always a decomposition into BCNF that is lossless and dependency preserving. So 3NF is considered adequate for normal RDBMS design.

Post your comment / Share knowledge


Enter the code shown above:

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