Question: Route can be served by multiple Buses. A route is described by a route_id, start location, end location, distance, estimated duration of the journey and

 Route can be served by multiple Buses. A route is described

Route can be served by multiple Buses. A route is described by a route_id, start location, end location, distance, estimated duration of the journey and fare. A customer can book a reservation for a particular bus on a particular date. A customer is described by customer_id, first name, last name, email, and phone number. A reservation can have multiple passengers. A passenger can have multiple reservations too. Each passenger must be uniquely identified by an identifier and have first name, last name, phone number and emergency contact number. Each Reservation generates one or more Tickets, depending on the number of seats reserved. Each ticket has a ticket number and seat number. A ticket must belong to exactly one reservation. Design an ER Model and show the ER diagram based on the above-mentioned scenario. Identify the weak entity set in your diagram using appropriate notations. The scenario description is not complete. You may include additional assumptions. Mention your assumptions explicitly (if any). Transform your ER model in Question 3 into a set of relational schemas. Show the resulting schema diagram. Add justifications where necessary

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!