This ER diagram depicts a student management system involving Students, Courses, Instructors, Enrollments, and Assignments. Students are linked to courses through Enrollments, while Courses can have multiple Assignments. Instructors are associated with Assignments, indicating they provide or oversee these tasks within courses. The relationships between these entities illustrate how students enroll in courses, how assignments are associated with courses, and how instructors provide assignments within those courses.
Edit this diagram in Gleek
Student management system diagram code in Gleek
Student
Integer StudentID PK
String FirstName
String LastName
String Email
String PhoneNumber
Course
Integer CourseID PK
String CourseName
String CourseDescription
Enrollment
Integer EnrollmentID PK
Integer StudentID FK
Integer CourseID FK
Date EnrollmentDate
Instructor
Integer InstructorID PK
String FirstName
String LastName
String Email
Assignment
Integer AssignmentID PK
Integer CourseID FK
String AssignmentName
Date DueDate
Enrollment {1}-isFor-{1} Course
Enrollment {1}-isDoneBy-{1} Student
Course {1}-has-{1..n} Assignment
Instructor {1}-gives-{1..n} Assignment
About ER diagrams
We often make an entity-relationship (ER) diagram, ERD, or entity-relationship model, in the early stages of designing a database. An ERD is perfect for quickly sketching out the elements needed in the system. The ERD explains how the elements interact. ER diagrams can be shared with colleagues. Their simplicity makes them ideal even for non-technical stakeholders.
Similar ER diagram examples
Online store entity-relationship diagram
Simple ER diagram example with Chen notation
Inventory management system ER diagram
Library management system ER diagram
Employee management system entity-relationship diagram
Banking system entity-relationship diagram
Travel management system Er diagram
College management system ER diagram
Inventory management system ER diagram
Library management system ER diagram