Convert above table into 1NF. Each table cell should contain a single value.

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.
Scroll to top