Data base management system

Assignment:

A database of company stores employees and their contact information. Without any normalization, all information is stored in one table as shown below.

1. Convert above table into 1NF:

1. Each table cell should contain a single value.
2. Each record needs to be unique.

• Convert 1NF to 2NF
  1. Rule1 – be in 1NF
  2. Rule 2- Single Column Primary Key
• Convert 2NF to 3NF
  1. Rule 1- Be in 2NF
  2. Rule 2- Has no transitive functional dependencies

HINT: see examples here:

https://www.geeksforgeeks.org/normal-forms-in-dbms/