Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Design an ER diagram for the Online Travel Booking System. The system consists of a travel agent who acts as an intermediate between customers and

image text in transcribed

Design an ER diagram for the Online Travel Booking System. The system consists of a travel agent who acts as an intermediate between customers and the bus transport service providers. Any user, before accessing the service from the travel agency, they must be registered with it. Once registered, the user can search for a bus as per his requirements such as date of travel, source and destination location. Based upon the user query, the travel agent requests all the bus transport providers and responds the user with the details such as date, source, destination, bus transport provider name, bus timings and bus fare. The user books the ticket by selecting any one of the details from the displayed list which satisfy his requirements. As the user books the ticket by providing necessary details, it must be entered at transport provider's database and also the travel agent database. Specify key attributes of each entity type. Make appropriate assumptions to make the specification complete. The report should contain the following lines B 1.1 Introduction and problem definition B 1.2 Identification of entities and attributes B 1.3 Identification of relationship and relationship types B 1.4 Draw ER diagram B 1.5 Conclusion

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

Database Design Using Entity Relationship Diagrams

Authors: Sikha Saha Bagui, Richard Walsh Earp

3rd Edition

103201718X, 978-1032017181

More Books

Students also viewed these Databases questions

Question

10:16 AM Sun Jan 29 Answered: 1 week ago

Answered: 1 week ago

Question

3. How would you address the problems that make up the situation?

Answered: 1 week ago

Question

2. What recommendations will you make to the city council?

Answered: 1 week ago