1. Draw an ERD for the Winfield Public Transit Authority system.
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.