UNF to 1NF

• Nominate an attribute or group of attributes to act as the key for the non-normalized table.
• Identify the repeating groups in the non-normalized table which repeats for the key attributes.
• Remove the repeating group by entering appropriate data into the empty columns of rows containing the repeating  data("flattening" the table)

• Step1:Eliminate the Repeating Group

  • Present data in tabular format, where each cell has single value and there are no repeating groups

• Step2:Identify the Primary Key

  • Primary key must uniquely identify attribute value

• Step3:Identify All dependencies 

  • Dependencies can be depicted with help of a diagram

Example(UNF)

Example(1NF)

Conversion to 1NF