Description A local hotel possesses seven floors, and every floor contains eleven rooms. There are three types of rooms:

[answerhappygod]

Description A Local Hotel Possesses Seven Floors And Every Floor Contains Eleven Rooms There Are Three Types Of Rooms 1 (40.77 KiB) Viewed 31 times

Description A local hotel possesses seven floors, and every floor contains eleven rooms. There are three types of rooms: single, double, or family rooms, and each room is assigned a unique number. These rooms are also categorized as non-smoking or smoking rooms. Of course, these rooms have different prices. A guest willing to book a hotel room must provide the following: first and last name, phone, email, home country, and passport number. A booking is identified by an ID and it includes the check-in and the check-out dates. The hotel possesses three underground floors for parking purposes. A guest can only have one parking spot if he/she wants one. A parking space is identified by its floor and its number. Questions a) Identify the entities and provide justification. b) Identify the attributes and provide justification. c) Identify the relationships and provide justification. d) Draw the Entity-Relationship (ER) data model for this case.