Question: Begin with the initial entities for STUDENT , INSTRUCTOR , and COURSE provided above, transform them into RELATIONS , and normalize your model to 3rd

Begin with the initial entities for STUDENT, INSTRUCTOR, and COURSE provided above, transform them into RELATIONS, and normalize your model to 3rd Normal Form. This is your deliverable #1. Realize that the three entities (or the three converted relations) are not in 3rd Normal Form. This is obvious by the many-to-many relationship that would need to exist between INSTRUCTOR and COURSE, COURSE and STUDENT, INSTRUCTOR and STUDENT.

You are to do the steps necessary to obtain 3rd Normal Form. You do not have to show how you got there, but you are to provide a document that shows the final relations you come with (and their relationships) once you have achieved 3rd Normal Form. Hint: Your answer will be within the Word document you submit as your Project 1 Assignment response along with the other deliverables for this assignment. Be sure to format this showing the logical schema (Rectangle boxes for relations in alphabetical order and lines between the relations to indicate the relationships). This format is NOT an ERD. Make sure it includes proper formatting and capitalization, as well as the appropriate relationships.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!