University ERD Diagram

Question

Create a University ERD Diagram : 


<h1>Project Description:</h1>

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.

Details
Purchase An Answer Below

Have a similar question?