Database 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.
EMPLOYEE_ID | NAME | PHONE | EMP_STATE |
10 | John Smith | 7272826385,
9064738238 |
TX |
20 | Harry Potter | 8574783832 | NJ |
30 | Sam Houston | 7390372389,
8589830302 |
CA |
Convert above table into 1NF:
Each table cell should contain a single value.
Each record needs to be unique.
Convert 1NF to 2NF
Rule1 – be in 1NF
Rule 2- Single Column Primary Key
Convert 2NF to 3NF
Rule 1- Be in 2NF
Rule 2- Has no transitive functional dependencies
HINT: see examples here:
https://www.geeksforgeeks.org/normal-forms-in-dbms/
Convert above table into 1NF. Each table cell should contain a single value.