March 12. Database Normalization. Student ID: Student N

Database Normalization
March 12
201
9
Student ID:
Student Name:
Module Tutor:
Module:

Customer Table in First Normal Form (1 NF)
Customer Table
CustomerID Name City
1 ACME Corp Denver
2 Two Trees Ojai
3 Acacia Edinburgh
Contact Table
CustomerID ContactName
1 Maria Donald
2 Helen Bale
3 Martin Brown
3 Karen Dick
3 Jack Watkins
Following steps are used to make the customer table into first normal form-
- Generate a new table customer.
- Generate a new table contact because there is more than one contact for a customer.
- Make a relationship in between the customer and contact table.
Both tables are following the rules of first normal form because there is no repeated group in
both tables. Each table has primary key and all other fields are depending upon the primary key
only.
The CustomerID is the primary key in the Customer table and working as a foreign key in the
Contact table. A customer may have more than one contact therefore; the cardinality is 0..1 to
0..* from Customer table to Contact table.