Question: Using the information found in your text on how to draw an ER diagram, draw a basic Entity-Relationship diagram that represents the following situation. A

Using the information found in your text on how to draw an ER diagram, draw a basic Entity-Relationship diagram that represents the following situation. A university database contains information about professors (uniquely identified bysocial security number), college courses (uniquely identified by course id), and students (uniquely identified by student id). Connect the entities (professor, course, student) with relationships, and indicate the minimum and maximum cardinality for each relationship. Use the following statements to help you:

A professor may teach multiple courses

A course may only be taught by one professor

A professor who doesn't teach any classes may exist in the database

A class must be taught by a professor to exist in the database

A student may enroll in multiple classes

A class can be enrolled in by multiple students

A student who doesn't enroll in any classes may exist in the database

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!