×
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.
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)
SHN6023 : Mental Health, Resilience and Recovery Across the Life-course – Case Study Assignment
Read MoreBUS6009 : International Business Management – Written Case Report
Read MoreBUS6018 : PROJECT MANAGEMENT – PROJECT PLAN
Read MoreHCM4003 : Communication and Interprofessional Collaboration – Podcast
Read MoreQHO335 : Business Project – Critical evaluation of an organisation’s response during the cost-of-living crisis in the UK
Read MorePRM7006 : Management of Traditional Projects – PID Assignment
Read MoreBMA5108-20H : International Business – Strategic Evaluation
Read MoreCA5055 : Airline Revenue and Pricing Management – REPORT
Read MoreCA5056 Aviation Psychology and Human Factors Assignment brief
Read MoreHow can i assist with youGBEN5006 : Intrapreneurial Development – Portfolio
Read More