Describe the characteristics of a table that violates first normal form (1NF) and then describe how such a table is converted to 1NF.

      

Describe the characteristics of a table that violates first normal form (1NF) and then describe how such a table is converted to 1NF.

  

Answers


kelvin
The rule for first normal form (1NF) is a table in which the intersection of every column and record contains only one value. In other words a table that contains more than one atomic value in the intersection of one or more column for one or more records is not in 1NF. The non 1NF table can be converted to 1NF by restructuring original table by removing the column with the multi-values along with a copy of the primary key to create a new table. See Figure 8.4 for an example of this approach. The advantage of this approach is that the resultant tables may be in normal forms later that 1NF.
kevowmuchiri answered the question on July 9, 2018 at 19:00


Next: Describe the types of update anomalies that may occur on a table that has redundant data.
Previous: What is the minimal normal form that a relation must satisfy? Provide a definition for this normal form.

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


Exams With Marking Schemes

Related Questions