Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started