Part II. Normalization (10 points)

Using the conceptual model (ERD) presented below, create a relational schema for the database of a manufacturing company. For each of the relations, indicate the normal form for that relation. If the relation is not in third normal form, decompose it into 3NF.

Name P ID DOB Person DeptID Major Student Facult DeptName GPA Salary Teach Enrol Grade SectionII Class Semester IsTaughtIn Year Seats No.of Students Classroom RoomID