1. Draw an ERD for the Winfield Public Transit Authority system. 2. Indicate cardinality. 3. Identify all...
Question:
2. Indicate cardinality.
3. Identify all fields you plan to include in the tables.
4. Create 3NF table designs.
Winfield is a small city with a population of 22,000. Until now, Winfield was served by a bus route from a nearby city. The Winfield City Council has held a bond sale to fund the purchase of several buses to serve three routes in Winfield and neighboring areas. As the city’s IT director, you have been asked to set up an information system for the new Transportation Authority. Assume that multiple buses will run on each route.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Systems Analysis and Design
ISBN: 978-1285171340
10th edition
Authors: Shelly Cashman, Harry J. Rosenblatt
Question Posted: