EXAMPLE 1:
Paint Shop is taken from the text book (Pages 113 to 117)The Entity Relationship Diagram is drawn for you to see. Right click then open in new window (right click)
EXAMPLE 2:
School Entities:
This is taken from my head.
Scenario: Students in a school take several different lessons every day. Lessons are taught by different teachers. The school database stores details of student lists (classes), lessons and the teachers that take each lesson.
NOTE: Here are the 3 entities and their attributes:
STUDENT (Student_ID, firstName, surname, Address)
LESSON (lesson_ID, teacher_ID, student_ID, startTime, endTime)
TEACHER (teacher_ID, department, jobTitle, officeLocation)
Questions:
- Which attributes above are the primary keys?
- Which attributes above are the foreign keys?
- A student has many teachers, and teacher has many students. What type of relationship is this?
- Using the three entities above, draw an Entity Relationship Diagram.
If you need further help please contact me using:


