Examples Of The Third Normal Form Tables For The Winfield Transportation System Diagram
Week 7 Chapter 9 Assignment
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
2
A table is considered to be in 3NF form if it is first in 2NF form and no nonkey field is dependent on another nonkey field.
Reference:
Home. (n.d.). Retrieved May 05, 2017, from http://www.bridging-the-gap.com/erd-entity-relationship-diagram/
How to Draw ER Diagram. (2017, May 05). Retrieved May 06, 2017, from https://www.lucidchart.com/pages/how-to-draw-ERD
ROSENBLATT, H. J. (2013). SYSTEMS ANALYSIS AND DESIGN (9th ed.). Chapter 9, pg. 401-422, S.l.: CENGAGE LEARNING.
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
2
A table is considered to be in 3NF form if it is first in 2NF form and no nonkey field is dependent on another nonkey field.
Reference:
Home. (n.d.). Retrieved May 05, 2017, from http://www.bridging-the-gap.com/erd-entity-relationship-diagram/
How to Draw ER Diagram. (2017, May 05). Retrieved May 06, 2017, from https://www.lucidchart.com/pages/how-to-draw-ERD
ROSENBLATT, H. J. (2013). SYSTEMS ANALYSIS AND DESIGN (9th ed.). Chapter 9, pg. 401-422, S.l.: CENGAGE LEARNING.