database management system

A tuiverkity registrat's office maintains data about the following entities: (a) conrees, including mumber, title, credits, puttine and prerequisite. (b) course offering (section) inchuding cours evumber, year, semester, group number, instructors, time and classoons. (c) students, including student_id, name and department, Further than the registration of students in courses and grades awarded to students in each course must be appropriately modeled. i. Construct an E-R Diagram for the registrar's office ii. Construct appropriate tables (schema) for the E-R diagram in (a)