GREETINGS FLESH DROID
ERD Help Stupid Humans Understand Systems
Entity diagrams are great for understanding systems.
Here is the complete system as it exists. Students cannot take zero courses.
Instructors may teach at least one course.
A Course may have more than one Instructor.
Isn't this fun?
Seen above is the overall system. We can observe the Entities in relation to one another. Each Entity has a number of
Attatched Attributes. These attributes will never leave their cold heartless forms, they are a part of the entity's identity.
The beauty of a soulless machine.
Behold.
The entities and their relationships without their attributes. We can observe their relationships. There is less clutter here.
A Student receives at least one report from their course. The course grades one or more reports. One or more instructors may
teach any number of courses.
We focus, for the sake of your slow primitive brain, on the topmost section
of the ERD. The instructor(s) teach at least one course. A course may be taught by one or more instructors. Each course has a year, a term, a title, a number.
An instructor has a first name and a last name.