Get premium membership and access questions with answers, video lessons as well as revision papers.

Describe when a database table is said to be in the following forms i)1NF ii)2NF iii)3NF

      

Describe when a database table is said to be in the following forms
i)1NF
ii)2NF
iii)3NF

  

Answers


Davis
i)When there are no repeating values in table
ii)When there are no repeating values and all the non-key figures are fully dependent on the primary key
iii)When there are no repeating values and the columns non-dependent to the primary key have been removed.
Githiari answered the question on November 17, 2017 at 05:54


Next: Discuss five properties of relational tables in a computer database
Previous: Give 3 ways in which a system maintainer should follow to ensure integrity in the data stored in a database system

View More Computer Studies Questions and Answers | Return to Questions Index


Learn High School English on YouTube

Related Questions