Instructor Solutions Manual for Fundamentals of Database Systems 7th Edition by Ramez Elmasri Soluti
TableColumn(s)
STUDENTMajor
COURSECourseNumber and Department
SECTIONCourseNumber
PREREQUISITECourseNumber and PrerequisiteNumber
b. You should split the following columns into two columns:
TableColumnSplit Columns
COURSECourseNumberCourseDept and CourseNum
SECTIONCourseNumberCourseDept and CourseNum
PREREQUISITECourseNumberCourseDept and CourseNum
PREREQUISITEPrerequisiteNumberPreReqDept and PreReqNum
Note that in the COURSE table, the column CourseDept will not be needed after the above change, since it is redundant with the Department column.