A university registrar’s office maintains data about the following entities: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;

d) instructors, including identification number, name, department, and title.

Further, the enrolment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modelled.

Construct an E-R diagram for the registrar’s office. Document all assumptions

that you make about the mapping constraints.

Use key fields to connect tables and avoid data redundancy. Use logical operators in framing simple and complex database queries

Task to do :

Notation to be identified for Drawing the ER-Diagram

Choose the Entity Sets for the relevant ER- Diagram

Identify the Attributes and Keys for the Entities

Create the Relationships (x2) between Entities

Create the rlational algebra for the queries in the scheme of the database.

Create Queries using SQL (CREATE,INSERT, SELECT)