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

 

 

  1. Convert above table into 1NF:
    1. Each table cell should contain a single value.
    2. Each record needs to be unique.
  1. Convert 1NF to 2NF
    1. Rule1 – be in 1NF
    2. Rule 2- Single Column Primary Key
  2. 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/