Answered step by step
Verified Expert Solution
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
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
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