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.
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: