Over the past 4 weeks, you have created ERDs based on information provided. This

Question

Over the past 4 weeks, you have created ERDs based on information provided. This week, you will complete the ERD being sure to normalize it to

3NF (third normal form). Normalization is the systematic application of rules designed to eliminate redundancy from the database. Data in previous weeks was, to some extent, normalized for you. This week, it is not. An abbreviated list of the data requirements follows.

College Scheduling Data Requirements

Student ID

Student First Name Student Last Name Course Code

Course Name

Course Description Course Credit Hours Course Time

Course Days Instructor ID Instructor First Name Instructor Last Name Room Number

Room Capacity

Explanation / Answer

3nf normalized tables will be as follows:

Table 1:

Student ID Student First Name Student Last Name

Table 2:

Course Code, Course Name, Course Description, Course Credit Hours, Course Time, Course Days

Table 3:

Instructor ID, Instructor First Name, Instructor Last Name

Table 4:

Course Code, Instructor ID, Room Number, Room Capacity

Table 5:

Studen ID , Course Code

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.