Course {CourseId, Title, CreditHour}
Section {SecID,Semester, Year}
Department {DeptID,DeptName,HOD}
Instructor {InstructorID,Name,Designation}
Basic schema of College Management System is given above. You are required to update and refine the
given Relational Schema according to the instructions provided later by the management. Change the given
schema and add/modify tables as per following requirement:
i. Each student can opt one or many courses
ii. In each course many students are enrolled
iii. It is pertinent to mention the Department of every student.
iv. Each course has 0, 1 or more prerequisite course(s).
v. Every student is issued grade report
vi. An Instructor can teach many courses. If instructor is busy in some administrative work, he
may take at least one course.
vii. It is worthwhile to mention the section of every student.