Information Systems

2

Create an ERD

The main entities are Students, Courses, Teachers, and Department for the database. Because we understand the relationship between a course and a student is like this: one student can study several courses at the same time, as well as one course, can be learned by several students, there is a need to construct a new table called Student_Course, with the course_id and student_id as foreign keys. There is a need to track which students are studying what courses.

A teacher and a course have a similar connection in that a teacher can teach many courses at once, whereas just one instructor delivers a course. Therefore, once again, we will construct a new table called Teacher_Course, with a foreign key of Teacher_id and course id. Furthermore, the teacher-department connection is one-to-many, meaning that one teacher belongs to one department, but just a department might contain several instructors.

Relationships

Entity Attribute Diagram

ERD Diagram