i need ER digram for this qustion without primiry key
DB for Railway Reservation
Purpose: The
passengers to enquire about the trains available on the basis of source and destination,
booking and cancellation of tickets, enquire about the status of the booked ticket, etc.
The database is for maintaining the records of different trains, train status, and
passengers. The record of train includes its number, name, source, destination, and days
on which it is available, whereas record of train status includes dates for which tickets
can be booked, total number of seats available, and number of seats already booked.
Passengers can book their tickets for the train in which seats are available. For this,
passenger has to provide the desired train number and the date for which ticket is to be
booked. Before booking a ticket for a passenger, the validity of train number and
booking date is checked. Once the train number and booking date are validated, it is
checked whether the seat is available. If yes, the ticket is booked with confirm status
and corresponding ticket ID is generated which is stored along with other details of the
passenger. After all the available tickets are booked, certain numbers of tickets arebooked with waiting status. If waiting lot is also finished, then tickets are not booked
and a message of non availability of seats is displayed. The ticket once booked can be ‐
cancelled at any time. For this, the passenger has to provide the ticket ID (the unique
key). The ticket ID is searched and the corresponding record is deleted. With this, the
first ticket with waiting status also gets confirmed.
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images
- How do you go about gathering data for a database?Different database statistics metrics apply to tables, indexes, and resources.arrow_forwardE-R diagrams or DBDL may show database structure. Why do you prefer this method?arrow_forwardsecurity precautions for private data Which properties of a database are regarded as being its most important ones, such as its privacy and dependability? What duties fall within the purview of the DBA manager in order to guarantee the accuracy of these tasks?arrow_forward
- The following tables form part of a database held in a relational DBMS (Primary Key, Foreign Key): CLIENT (ClientID, ClientName, AnnualRevenue) VESSEL (VesselNumber, VesselName, MaxWeight) Driver (DriverID, DriverName) COUNTRY (CountryName, Population) TRANSACTION(TransNumber, ClientID, DriverID, VesselNumber, DepartureCountryName, DestinationCountryName, Year, TransactionWeight) Formulate relational algebra (NOT SQL) expressions for each of the following: Names of Drivers who delivered transactions in 2019 or 2020. Total weight of transactions per year for each country of departure. Drivers who drove vessels to Spain and to Turkey.arrow_forwardDATABASE SYSTEMS AllTaste Restaurant is a restaurant that is famous for its taste, so it has a lot of customers. All the flavors are here, serving typical archipelago food that has spread in several cities with various mainstay menus. However, even though it already has many branches and a large number of order transactions every day, AllTaste Restaurant does not yet have an application and database to manage transactions and data. Order recording and sales reports are still done manually. AllTaste Restaurant owners know that information technology can support their business, so they plan to build applications to serve food orders both offline and online. In the database design stage, it is known as bottom-up, top-down, and inside-out approaches. Explain the three approaches! In your opinion, what approach is used for database system development at AllTaste Restaurant? Explain why you chose this approach! What techniques do you use to collect information (fact-finding technique)?…arrow_forward
- Computer Networking: A Top-Down Approach (7th Edi...Computer EngineeringISBN:9780133594140Author:James Kurose, Keith RossPublisher:PEARSONComputer Organization and Design MIPS Edition, Fi...Computer EngineeringISBN:9780124077263Author:David A. Patterson, John L. HennessyPublisher:Elsevier ScienceNetwork+ Guide to Networks (MindTap Course List)Computer EngineeringISBN:9781337569330Author:Jill West, Tamara Dean, Jean AndrewsPublisher:Cengage Learning
- Concepts of Database ManagementComputer EngineeringISBN:9781337093422Author:Joy L. Starks, Philip J. Pratt, Mary Z. LastPublisher:Cengage LearningPrelude to ProgrammingComputer EngineeringISBN:9780133750423Author:VENIT, StewartPublisher:Pearson EducationSc Business Data Communications and Networking, T...Computer EngineeringISBN:9781119368830Author:FITZGERALDPublisher:WILEY