University ERD Diagram
Create a University ERD Diagram :
In this project, you will design and implement a database system for a university course registration system. This system should accurately reflect the complexities of real-world course registration, including handling courses, departments, enrollments, and the relationships between students, professors, and their respective courses. The project will include the following components:
<h2>1. Entity-Relationship Diagram (ERD):</h2>You must create an ERD that models the entities, attributes, and relationships (including all cardinalities) for the university course registration system based on the following expanded requirements:
Requirements:
A university consists of multiple colleges.
Each college offers various departments.
Each department offers multiple courses.
Courses have course codes, titles, descriptions, credit hours, and maximum capacity.
Students have a student ID, name, date of birth, email, major, and contact information.
Professors have a professor ID, name, email, department affiliation, and office location.
Each course can have prerequisites.
Students can enroll in multiple courses.
For each student enrolled in a course, we keep track of the enrollment date or status (active, completed, withdrawn).
Professors can teach multiple courses.
Keep track of student enrollment history.
Maintain a record of grades for each student in each course. The students may have more than one grade for each course.
You can add any assumptions to the requirements to make a completed ERD.