Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following scenario modeling courses, students, professors, departments, and the like at a single university in a single semester. 1. Each department has a

Consider the following scenario modeling courses, students, professors, departments, and the like at a single university in a single semester. 1. Each department has a unique name. Each department has at most one chairperson who is its head (there are times when a department may not have a chairperson). Each chairperson can be the head of at most one department. 2. Each student has a name, a unique PID, and an address. 3. A professor has a name, a unique PID, and belongs to a department. We also want to record the age and office of the professor. 4. Each course has a name, a number, an offering department, a classroom, and an enrollment. Each department offers only one course with each number. 5. Each student enrolls in a certain number of courses in the semester. At most one professor teaches each course. Each student receives a grade in each course he/she is enrolled in. In turn, each student evaluates the professor teaching the course 6. A course can have multiple pre-requisites. A course can be pre-requisites for multiple courses. A course cannot be a pre-requisite for itself! Questions: 1. Draw the E-R diagram for this database requirement a) The E-R diagram should correctly identify all the entities, relationships and their attributes. b) It should use correct symbols/notations.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David Kroenke, David J. Auer

3rd Edition

0131986252, 978-0131986251

More Books

Students also viewed these Databases questions