Question: Produce an E-R diagram from the below conceptual and logical models

Assumptions are:

The university has many departments which are identified basically by the dept_id. Department has a location (campus).

Each department has Instructors. Each instructor is assigned to teach a subject. Instructor administer and evaluate the answer. Assume that an instructor can take classes in different department but must belong to a department.

A particular department may offer courses. One or more subjects may be same for different courses as well as departments. Same subject (name) in two courses or department is separately identified by the corresponding subject_id.

Subject_id for a course of a department is unique i.e. CSC for computer science.

A student must register to take an e xam. A registered student is considered as e xam candidate.

The e xam controller section is the administrator of this whole e xamination system.

ENTITIESIDENTIFIED FOR E-R DIAGRAM

Student

Department

Instructor

Subject

E xam

E xam Candidate

Result

Routine

IDENTIFY RELATIONSHIPS

This is the 1-to-many binary relationship set between department and student entity sets

Belongs to is the 1-to-many binary relationship set between DEPARTMENT and INSTRUCTOR sets. For or a particular department there are many instructors however an instructor belongs to only 1 department. The participation of the instructor entity sets in this relationship sets is partial.

Teaches is the many-to-many binary relationship sets between instructor and subjects. Enrolls is the one-to-one binary relationship sets between Student and E xam Candidate. Component attributes are: date, month, and year.

There exist many-to-many binary relationship sets between the E xam Candidate and the E xamination.

Scheduled is the relationship that holds between the e xamination and the e xam routine.

This is a many-to-many binary relationship set between the department and the e xamination.

This is the relationship sets between E xam Candidate and the Results.

Every e xam has results. This is many to one relationship.

THE KEY ATTRIBUTES

Student: rollno

Dept: dept.no

Instructor: instructor_id

Subject: subject_id

E xam: e xam_id

E xam Candidate: e xam_id

Result: roll no

Routine: e xam_id

OTHER ATTRIBUTES

1.Student: Name, Roll No, Reg. No, Contact No 2.Dept: Dept_id, Name, Location 3.Instructor:Instructor_id, Name, Contact No, Status 4.Subject: Name, Subject_id ,Course, Dept 5.E xam: E xam_id, Roll No, Sub_id, E xam roll no. 6.E xam Candidate: Semester, Year, E xam_id, Sub_id 7.Result:Roll no, E xam_id, Sub_id, Grade, Date_of_publish 8.Routine: Date, Time, Room No, E xam_id