Question: PLEASE USE THE SCREENSHOT ABOVE AS REFERENCE ON HOW THE LAYOUT SHOULD FOLLOW QUESTION: A university wants to develop a database system to manage student

PLEASE USE THE SCREENSHOT ABOVE AS REFERENCE ON HOW THE LAYOUT SHOULD FOLLOW
QUESTION: A university wants to develop a database system to manage student enrollment and course registration. They need an ERD to represent the key entities and their relationships.
Entities:
- Student: Each student has a unique student ID, a name, a date of birth, and an email address.
- Course: Each course has a unique course code, a title, a description, and the number of credits.
- Enrollment: Each enrollment represents a student's registration in a specific course for a particular semester. It includes information about the grade received for that course.
- Professor: Each professor has a unique professor ID, a name, and an email address. Professors teach one or more courses.
Create an ERD that represents the relationships between these four entities.
Include Entity name, attributes, identify Primary and Foreign key and crow foot relationships.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
