Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions