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
Get step-by-step solutions from verified subject matter experts
