Normalize the following into the first 3 normal forms: CUSTOMER(CustomerID, SalesPersonID, OrderNumber (3), OrderItem (3), SalesPersonName, SalesOffice, SalesDepartment, SalesDepartmentName, BuildingI

CIS/IMSE 556 Database Systems

Normalize the following into the first 3 normal forms:

STUDENT(StudentID, StudentName, StudentEmail (3), StudentPhone(3), SchoolID, SchoolName, Course, DateCompleted, Grade)

(3) means 3 instances of that item

First Normal Form:

Second Normal Form:

Third Normal Form:

CUSTOMER(CustomerID, SalesPersonID, OrderNumber (3), OrderItem (3), SalesPersonName, SalesOffice, SalesDepartment, SalesDepartmentName, BuildingID, BuildingName, CustomerName, CustomerAddress, CustomerCity, CustomerZip)

First Normal Form:

Second Normal Form:

Third Normal Form: