Hotel Registration design an efficient database model and a website that allow clients, hotels, and brokers to seamlessly interact with each other. New hotel and room tuples are insert into the waiting hotel and waiting room temporarily until an admin approves this new hotel account when approved. The hotel tuple is move from waitingHotel to hotel and the rooms are move from -waitingRoom to room.
Takes input from hotel users. Takes input and inserts a new tuple into the ‘client’ table with the data entered. When login they take email and password. Checks which radio button is click and thus queries its respective table to search for the logins entered. Redirects the user to their respective landing page: client, hospital, or admin. Site name and check reservations: will query the reservation table on clientId.
Location, rating, and stars are search on from the hotel table. Type and price are search on from room table. Check-in and check out from the reservation table. The resulting table has the hotels’, rooms’, and the available dates for them. It will then be use to list the available options in a list. A list is then shown with the possible options and a book now button that creates a new reservation into tempReservation to either be canceled by a hotel or approve ( by the hotel or automatically after the 30s ) and moved to reservation table.
Diagrams Needed for this Project are:
- Data Flow
- ER Diagram
- Schema Diagram
- Use Case Diagram
