Question: Question 1 : Develop Entity - Relationship Diagrams ( ERDs ) for the following databases using Chen data modelling notation using the following information: Database
Question : Develop EntityRelationship Diagrams ERDs for the following databases using Chen
data modelling notation using the following information:
Database for the University Management System
Entities: Students, Courses, Instructors, Departments, Enrollments
Relationships:
A student can enroll in multiple courses.
Each course is taught by an instructor.
Each instructor belongs to a department.
A department can offer multiple courses.
Attributes:
Student: StudentID Name, Major, Year
Course: CourseID Title, Credits
Instructor: InstructorID Name, DepartmentID
Department: DepartmentID Name
Enrollment: Enrollment ID StudentID CourseID Grade
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
