support@w4writers.com +44 7743 307695
May 02, 2023

Answer:

Schema Refinement And Normal Forms

Changes That Occurred

Since there was a many to many relationships between student and courses, another table: course_student has been introduced to break the many to many relationships into two one to many relationships.  

Table Normalization To 3NF

The following is a list of Tables Normalized to 3NF. Primary Keys are Underlined While Foreign Keys Are Italicized:

Student (StudentId, FirstName, LastName, Phone)

Department (DepartmentName, Location)

Instructor (InstructorId, FirstName, LastName, Phone, DepartmentName)

Course (CourseId, Duration, CourseName, DepartmentName, InstructorId)

Course_Student (CourseId, StudentId)

 

Recent Post

Order this Assignment now

Total: GBP120

fables template