Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Online Railway Reservation System is aimed to provide the customers facility to book tickets for a train online in convenient way to travel from a

image text in transcribed

Online Railway Reservation System is aimed to provide the customers facility to book tickets for a train online in convenient way to travel from a particular source to the destination. The tickets that have been booked by the customers need to be stored in the database and the other information of customers, trains, available seats, trips, stations ... etc. you are asked to build a database for an Online Railway Reservation System, that is used to assist in booking tickets of trains There are different stations and each station has a unique name, set of phones, and location (city, street). Each has different trips, the trip has two types one way or round trip. The trip has different source, destination, date and time of departure and arrival. The station has at least one trip per a day. There are different numbers of trains, each one has a unique name and number of seats at least 20 seats. The seat has status, class (first, economy) and price depend on the seat class. To name a seat uniquely, we need to give both the train name to which this seat belongs to and the seat number. To book a trip, the customer needs to enter his personal information ex: SSN, customer's name (first, last name), date of birth, phone ... etc. A customer can book up to a maximum of 6 tickets for the same trip. All ticket information will be kept in the database. You are required to study and analyze the booking service of Online Railway Reservation System. Q: Draw an ER diagram for the above problem using your analytical skills. Your ER diagram must include entities, attributes, relationships, cardinality and multiplicity. -Not all information about entities (attributes) were mentioned, it is your responsibility to analyze the problem and find most suitable solution. -For any information you assume, write down your assumptions as clear points under your diagram

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

Learning PostgreSQL

Authors: Salahaldin Juba, Achim Vannahme, Andrey Volkov

1st Edition

178398919X, 9781783989195

More Books

Students also viewed these Databases questions

Question

9. Power and politics can be destructive forces in organizations.

Answered: 1 week ago