Question

Draw an ER Diagram for the following entities:
Student
Course
Teacher
Class
Classroom
Equipment

It must have cardinality constaints and at least two! Attributes including the primary key

Answer 1

ER Diagram:

Entities:

• Student

Attributes:

• student_ID (Primary Key)
• name
• address
• DOB

• Course

Attributes:

• course_ID (Primary Key)
• credit
• syllabus
• title

•Teacher

Attributes:

• teacher_ID (Primary Key)
• name
• Department

•Class

Attributes:

• class_ID (Primary Key)
• teacher_ID (foreign key)
• Period_time

• Classroom

Attributes:

• Classroom_ID (Primary Key)
• Room_type
• capacity

• Equipment

Attributes:

• Equipment_ID (Primary Key)
• E_name

Cardinality:

• One to many (Teacher to Student, Classroom to Equipment)

• Many to One (Student to Course)