Data-dictionary1.docx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Data-dictionary1.docx as PDF for free.
More details
- Words: 139
- Pages: 2
Data dictionary Table 1 tblGuestRecord Field Name
Description
Data Type
LastName
Last Name of the Guest
VARCHAR
FirstName
First Name of the Guest
VARCHAR
MiddleName
Middle Name of the Guest
VARCHAR
Age
Age of the Guest
INT
ContactNo.
Contact No. of the Guest
VARCHAR
Sex
Male or Female
VARCHAR
Field Name
Description
Data Type
CheckInNo.
Check-In No. of the
VARCHAR
Table 2 tblReservationInfo
Transaction CheckSchedule
Reservation Schedule for the
DATE AND TIME
Accommodation RoomAvailability
Room Availability for Guest
VARCHAR
Accommodation RoomType
Deluxe, Gym, Econo,
VARCHAR
Premium, VIP, Family and Penthouse RoomNo.
Served Room No. of the
VARCHAR
Guest AccommodationBill
Bill of the Room Accommodation
MONEY
Table 3 tblCheck-Out Field Name
Description
Data Type
CheckoutSchedule
Check-out Schedule of the
VARCHAR
Guest BillExtension
Bill for room extension
MONEY
RoomClearance
Yes or No
VARCHAR
RoomNo.
Served Room No. of the
VARCHAR
Guest
Description
Data Type
LastName
Last Name of the Guest
VARCHAR
FirstName
First Name of the Guest
VARCHAR
MiddleName
Middle Name of the Guest
VARCHAR
Age
Age of the Guest
INT
ContactNo.
Contact No. of the Guest
VARCHAR
Sex
Male or Female
VARCHAR
Field Name
Description
Data Type
CheckInNo.
Check-In No. of the
VARCHAR
Table 2 tblReservationInfo
Transaction CheckSchedule
Reservation Schedule for the
DATE AND TIME
Accommodation RoomAvailability
Room Availability for Guest
VARCHAR
Accommodation RoomType
Deluxe, Gym, Econo,
VARCHAR
Premium, VIP, Family and Penthouse RoomNo.
Served Room No. of the
VARCHAR
Guest AccommodationBill
Bill of the Room Accommodation
MONEY
Table 3 tblCheck-Out Field Name
Description
Data Type
CheckoutSchedule
Check-out Schedule of the
VARCHAR
Guest BillExtension
Bill for room extension
MONEY
RoomClearance
Yes or No
VARCHAR
RoomNo.
Served Room No. of the
VARCHAR
Guest
More Documents from "Ethan James Escaño"
Lab Standards Rev 08
October 2019 24
Machine Learning For Wireless Networks With Artificial.pdf
December 2019 23
Initial Motion Assignment
October 2019 24
Kuwentong Bayan.docx
May 2020 9
Lab Onegalileo
October 2019 27