Can draw the diagrams in Word, PowerPoint, Visio, Lucid Chart or Excel. Please convert all file into PDF for submission (i.e., using print to PDF function). Thank you!
MTD
Champaign Urbana Mass Transit District (MTD) provides public transportation to the cities of Champaign, Urbana, Savoy, and the University of Illinois. Being in the service industry, MTD relies heavily on feedback and complaints through their customers to give the best transportation service possible. Recently, MTD planned to create an electronic complaint system that allows customers to file complaints about its services. Design a relational database model for this system.
Some of the business rules are as follows: An MTD route offers multiple rides (for example, Route 100 yellow offers multiple rides from 6:00 am to the midnight on weekdays). Each route has many stops, and one stop may be shared by many different routes. Each ride has a unique number and is operated by one driver. A driver is assigned to many rides, and a ride is driven by different drivers based on the shift schedule. The system allows a customer to file a complaint for a particular ride.
Start with Entity-Relationship Model. List all entities, attributes, and relationships among entities.
Build upon the ERD and create the relational model.