Database Design Project for Tourist Inn Reservation System

Database Design Project for Tourist Inn Reservation System

This Database Design Project for Tourist Inn Reservation System is to reduce extensive paperwork in currently used system which is manual.  It is a user-friendly. Same with Complete Hotel Management System, the owner and manager of the tourist inn can access this system to monitor all guest entering at the inn through the reports file. They can reserve a rooms, can book also and can add another day to stay in.

Database Design Project for ZJM Tourist Inn Reservation System

The System For Tourist Inn Reservation Database Design Project provides a place for some travellers or guest in that location and running a business well.

It will great help for the Zjm Tourist Inn Reservation System Database Design Project to have an easy task for hotel to have an easy transaction for the guest and less time to saving the information. This Project is responsible for keeping accurate records about reserving rooms that encode in this system.  The guest can secure of their information.

The Zjm Tourist Inn was started on August 2018 located at Rivera Street, Barangay 3, Kabankalan City (infront of Golden Key Trading).  This Inn can manage well the guests. Have a good design rooms, well organize.

Features:

  • Room Reservation
  • Search rooms
  • Check in and Check out
  • Issue bills

Data Dictionaries

These tables below provide the entire database tables details such as Field Name, Descriptions, data types, character lengths.

Table 1: tbl_guest

Field Name Description Type Length
Guest_id Guest ID Int 11
First_name Firstname Varchar 50
Last_name Lastname Varchar 50
Address Address Varchar 50
Phone_number Phone Number Varchar 50
Email_address Email Address Varchar 50

Table 2: tbl_reservation

Field Name Description Type Length
Reservation_id Reservation ID Int 11
Guest_id Guest ID Int 11
Room_type_id Room Type ID Int 11
Check_in Check In Varchar 50
Check_out Check Out Varchar 50
Reservation_status Reservation Status Int 11

Table 3: tbl_booking

Field Name Description Type Length
Booking_id Booking ID Int 11
Room_Type_id Room Type ID Int 11
Guest_id Guest ID Int 11
Check_in_datetime Check In of Date and Time Varchar 50
Check_out_datetime Check Out of Date and Time Varchar 50

Table 4: tbl_ room_type

Field Name Description Type Length
Room_type_id Room Type ID Int 11
Room_type Room Type Varchar 50

Table 5: tbl_room

Field Name Description Type Length
Room_id Room ID Int 11
Room_number Room Number Int 11
Room_type_Id Room Type ID Varchar 50
Room_price Room Price Int 11
Room_status Room Status Int 11

Table 6: tbl_payment

Field Name Description Type Length
Payment_id Payment ID Int 11
Guest_id Guest ID Int 11
Reservation_id Reservation ID Int 11
Add_On Add On the extra features Varchar 50
Room_price Room Price Int 50
Number_of_nights Number of nights Int 11
Total Total Charges Int 11
Payment_status Payment status Int 11

Entity Relationship Diagram

Entity Relationship Diagram shows the entity relationships in each entity and their supposed functions in each relationship.

Database Design Project For ZJM Reservation Management System
Database Design Project For ZJM Reservation Management System

Conclusion

This System for Tourist Inn Reservation Database Design Project is to produce a solution to overcome the problems that arise nowadays because of using current manual system. Provide fast access for the customers and for the Inn.

For More Database Design Examples

Inquiries

If you have any questions or suggestions about Database Design Project for Tourist Inn Reservation System, please let me know by dropping your comment below.

Leave a Comment