Design Analysis

Question 1

From the information provided about the Marvel college database and the supposed changes to be made, the following would have to be implemented to ensure that the database functions according to the requirements. There will be the creation of a new table in the database. The table will mainly contain three columns and no other columns should be added and will be separate from other tables in the database. The three columns to be contained in this newly formed table will be ScheduleCode, FacultyNum, and SemesterCode. However, before creating the table, the FacultyNum is to be removed from an existing column in the Section table. The reason for this is to prevent data redundancies that save memory in the database.