This database will organize a hotels office records. The database will store Guest personal information, guest's Credit
Question:
This database will organize a hotels office records. The database will store Guest personal information, guest's Credit Card information, Room information, and guest Transaction information.
Guest information includes: First_Name, Last_Name, Middle_Initial, Address, Phone, and Guest_ID.
Room information includes: Available, Occupied, Room_Number, and Rate.
Transaction information includes: Guest_ID, ID, Number, Check_In, Check_Out, and Rate.
Credit Card information includes: Card_Number, Expiration_Date, Security_Code, Name_on_Card, and Guest_ID.
Deliveries and points are as follows:
1 List the entities and attributes.
2 -Must draw ERD for the following proposal.
3 -Draw the Logical RDBMS table design for above.
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young