Problem 1 Create an ER diagram for the following description:
A university registrar's office maintains data about the following entities:
(a) Courses, including number, title, credits, syllabus, and prerequisites;
(b) Course offerings, including course number, year, semester, section number, instructor(s),
timings, and classroom;
(c) Students, including student-id, name, and program; and
(d) Instructors, including identification number, name, department, and title.
Further, the enrollment of students in courses and grades awarded to students in each course
they are enrolled for must be appropriately modeled. Construct an E-R diagram for the
registrar's office.
Problem 2
Consider the ER diagram shown below for part of a Bank database. Each bank can have multiple
branches, and each branch can have multiple accounts and loans.
Map the ER into relational model and Specify all primary keys and foreign keys.