1. Engineering
  2. Computer Science
  3. mtd provides public transportation being in the service industry mtd...

Question: mtd provides public transportation being in the service industry mtd...

Question details

MTD provides public transportation. 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 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.

  1. Start with the Entity-Relationship Model. List all entities, attributes, and relationships among entities.

  2. Draw the relational model.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution