Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A bus company managing local traffic in a city has a database of bus routes, bus stops, the buses that operate on the routes, and

"A bus company managing local traffic in a city has a database of bus routes, bus stops, the buses that operate on the routes, and drivers who drive the buses.
Each bus route is identified by an integer number, such as 20,32, and 50. For each route, information is also stored about a route name consisting of up to three location names, for example, 'Student Village, Moikoinen Oriniemi,' and the length of the route in kilometers.
For each route, the database also stores information about which bus stops are located on the route. For each bus stop, a unique ID number and an address consisting of a street name and street number are stored (e.g., 'Tavast Street 3'). Naturally, a particular bus stop can belong to multiple routes.
For each bus, information is stored about its registration number, year model, and passenger capacity. A route can be serviced by multiple buses, but a specific bus serves only one route (if the bus is in operation).
The database should store information about which buses operate on the different routes, as well as which drivers drive the buses. A driver drives at most one bus at a time, and a bus has a driver when it is in operation. For drivers, a unique ID number and names consisting of first and last names are stored. Draw up an E-R diagram of the operation (e.g., with Draw.io). What entity sets can you identify in the described business, and what type are they? What relationship sets exist, and what is their cardinality? Convert the E-R model to schemas

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Demystifying Databases A Hands On Guide For Database Management

Authors: Shiva Sukula

1st Edition

8170005345, 978-8170005346

More Books

Students also viewed these Databases questions

Question

What are the main objectives of Inventory ?

Answered: 1 week ago

Question

Explain the various inventory management techniques in detail.

Answered: 1 week ago