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

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.