60 likes | 177 Views
Entity Relationship Diagrams (ERDs). 1. ∞. Entity Relationship Diagrams. S. C. T. Entity Relationship Diagrams. Students go on courses Tutors teach courses. S. C. T. Entity Relationship Diagrams. One student can be on one or more courses A course has one or more students
E N D
1 ∞ Entity Relationship Diagrams
S C T Entity Relationship Diagrams Students go on courses Tutors teach courses
S C T Entity Relationship Diagrams One student can be on one or more courses A course has one or more students Tutors teach one or more courses
Entity Relationship Diagrams Problem: We can’t have a many-to-many so we need to create a link entity
Entity Relationship Diagrams S C One student is enrolled on one or more courses A course can have one or more students enrolled on it T E