Database Management

A University registrar's office maintains data about academic course offerings. The data has the following characteristics: a) Students may enroll in courses offered in a particular semester. They may enroll in many courses, and of course, courses offered may have many students enrolled in them. b) Offered courses have a semester, year and section number, A particular course, identified by it's course number, has a unique section number for the year and semester that it is taught. Course offerings must include a course number to be fully specified. c) Professors teach several offered courses in a particular semester and year. But no team-taught courses are allowed. d) Courses have prerequisites. Label the following ER diagram using the keywords below. Two of the keywords are used twice each. UNDERLINE ALL KEYS. is_offered, dept, time, program, course_offering, sid, name, Semester, title, pid, teaches, syllabus, credits, Crs_num, requires, Course, year, sect_num, student, enrolls, room, professor