In a hotel reservation system, the Reservations Information System must track hotel rooms, payers, and reservations.

Management has decided to track the following details of each entity. CC stands for Credit Card.

Room: Room Number, Floor Number, Number of Queen-Size Beds, Number of King-Size Beds, Balcony Type (None, City-view, or Ocean-view), Weekday Rate, Weekend Rate

Payer: First Name, Last Name, Email Address, Phone Number, Address, City, State, Postal Code

Guest: First Name, Last Name, Email Address, Phone Number, Address, City, State, Postal Code

Reservation: Start Date, End Date, Discount Code, Special Requests, CC Number, CC Security Code, CC Expiration Date, Amount Paid by CC, Amount Paid in Cash

To operationalize this into a database design, the Reservation will need to link to the specific Hotel Room and Payer involved.

Using the following diagram, answer the questions below.

To operationalize this into a database design, the Reservation will need to link to the specific Hotel Room. and Payer involved. 1 Payer Using the following diagram, answer the questions.below. Room Reservation Guest Part.A: What are the identifiers and primary keys? If an entity has no identifier, enter."N/A". (10.pts) 1 Room Payerd Guest Reservations Identifierd Primary Key