Draw an ERD for the Winfield Public Transit Authoritysystem.
What will be an ideal response?
Answers will vary. The sample diagram is just an example, based on limited facts. A real-world system would require 100 times more information, which would be obtained in the fact-finding and analysis phases. The main thing is for students to grasp the idea of the associative entity, which is necessary in an M:N relationship. Therefore, if one or more buses can be assigned to one or more routes (at different times and days of the week) then a ROUTE ASSIGMENT entity is needed to record data about that event or transaction.
You might also like to view...
The first row of each column has the name of the:
A) Field. B) Data type. C) Table. D) Database.
Graphics method Invalidate __________.
a) checks to see if a form is valid b) invalidates a form c) clears a form d) refreshes and updates a form