David McNamee
1.
2. Some Example 3NF (Third Normal Form) tables for the Winfield Transportation System diagram are:
Bus:
Bus Number Bus Make Bus Model Passenger Capacity Departure Time
101 Champion CTS-RE 50 900 am, 1200 pm, 300 pm
102 Mercedes Citaro G 47 930 am, 1230 pm, 330 pm
103 Toyota Coaster 30 1000 am, 1 pm,
4 pm
Route:
Route Number # Times Per Day Average Customer Numbers per Day Switchout Point for Route Capacity
4 3 68 4th and Vine
7 6 284 22nd Street Townhall
2 4 96 Central Station
Stop:
Number of Stops First Stop Last Stop Stop Locations
8 Alameda Station Turnvault Rd. Ref: Route Sheet 4
12 Longstreet Vanguard Rd. Ref: Route Sheet 7
9 Rockingham On Ramp SquareTop St. Ref: Route Sheet