Question: Question 1 : Develop Entity - Relationship Diagrams ( ERDs ) for the following databases using Chen data modelling notation using the following information: Database

Question 1: Develop Entity-Relationship 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: Student_ID, Name, Major, Year
Course: Course_ID, Title, Credits
Instructor: Instructor_ID, Name, Department_ID
Department: Department_ID, Name
Enrollment: Enrollment ID, Student_ID, Course_ID, Grade
Question 1 : Develop Entity - Relationship

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!