Our project submission for Database Management Systems course (Course No: CS254) at National Institute of Technology, Warangal.
AStar DBMS Project - Book flights, hotels and buses! Plan your own trip or connect with travel agents!
The database consists of 11 main entities: User, Hotel, Flight, Bus, Package, Airport, Airline, Travel Agencies, Travel Agents, Bookings and payments.
There are multiple relationship sets which connect the entities to form backend functionalities for Users to book hotels, Buses, Flights to create
their own travel itinerary or book packages through registered travel agents. Packages are inclusive of Hotels, Flights and Buses which are provided to the customer.
Entity Relationship Diagram:-
Relational Model schema:-
Team members:
Chetan Kar: https://github.com/chetankar65
Shubham Pahilwani: https://github.com/shub2726