3. (10 points) The relations below are part of a database that a school uses to manage its course listing, students enro

[answerhappygod]

3 10 Points The Relations Below Are Part Of A Database That A School Uses To Manage Its Course Listing Students Enro 1 (58.33 KiB) Viewed 40 times

3. (10 points) The relations below are part of a database that a school uses to manage its course listing, students enrollment and teaching assignment. • The school has a few departments and each department is assigned a unique department number. • Each instructor receives a unique 9-digit instructor identifier and a student a unique 9- digit student identifier from the school. • Each department assigns a 3-digit unique course number to a course the department offers independently and do not consider whether the number is being used by other departments. • A course can have multiple sections and each section can only be taught by one instructor. The school assigns a 5-digit unique section identifier to a section in a semester. That is to say, no two sections share the same section identifier in a semester. • Relation Course records course information, relation CourseSection records section identifier allocation and teaching assignment, relation Instructor records instructor information, relation Student records student information, and CourseRoster records students' roster in a section. Course CourseNo CourseName, CreditHours, DeptID) Course Section (SectionID, DeptID, CourseNo, SectionNo, Instructorid, Semester, Year) Instructor(InstructorID, Name, Office Room, OfficePhone, Email) Student StudentID. Name, Major, Phone, Email) Course Roster(SectionID, Semester, Year, StudentID, FinalGrade) Indicate in the table below the key, the foreign key (if any), and the tables and the attributes referenced by the foreign key. Table Кеу Foreign Key Table Referenced Attributes Referenced Course CourseSection Instructor Student Course Roster