Question

Draw the scenario using Chen notation

In a university, department offer courses. Department has instructors who teach courses. For a course, the instructor may or may not have a teaching assistant.

Each department has a department name, a department code, 1-4 phone numbers, and an address. ◦ Each course has a course number (e.g., INFO605), a section number (e.g., 900), a title, a course type (e.g., online), and units.

Each instructor has an instructor ID, first name, last name, gender, SSN, position, and units taught. An instructor may or may not be supervised by another instructor.

Each instructor can state his/her teaching preferences including number of courses to teach for each course type.

Each teaching assistant has a teaching assistant ID, SSN, a student ID, and salary.

For each course, both the instructor and the teaching assistant will have an evaluation score individually.

Answer 1

University has the primary key Reg. No.

Department has the primary key DCode and one multivalued attribute phoneNumber.

Courses has the primary key CourseNo.

Instructor has the primary key Id and it has a self referential relation supervise which has a partial relationship with itself.

Assistant has the primary key Id.