Question: I want a ER Design the answer given is without the drawing!! Problem [ 7 5 points ] University Database System Design:Design an ER diagram
I want a ER Design the answer given is without the drawing!!
Problem pointsUniversity Database System Design:Design an ER diagram for a university database system that manages student enrollment, course offerings, course sections, instructors, and grades. The system should meet the following requirements: Students: Each student has a unique student ID name, date of birth, and contact information. A student can enroll in multiple courses Courses: Each course has a unique course ID course name, and course description. Each course can have multiple sections Course Sections: Each course section has a unique section ID associated courseID, semester eg Fall and a section schedule days and times Each section is taught by one instructor and can have multiple students enrolled Instructors: Each instructor has a unique instructor ID name, department, and contact information. An instructor can teach multiple sections of different courses Enrollment: A student can enroll in multiple course sections, and a course section can have multiple students. For each enrollment, the system should track: Enrollment Dateo Final Grade: The final grade a student receives for the course section Departments: Each instructor belongs to a department, which has a unique department ID and department name. A department can have multiple instructors Grades: The system should maintain a record of each student's final grade in a section. Grades should be tracked for historical records, even after the student completes the course or the course is no longer offered.Create an ER diagram representing the entities, relationships, and attributes based on the above specifications. Include primary keys, participation constraints partial or full and indicate key constraints such as to lton or ntom where applicable. Use only one notation for the ER diagram and do not mix notations.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
