Due to dynamic market and industrial changes, collaborative environment and economic changes, modern hotels are facing a challenge of organizing diverse types and amounts of big data to support their decision making processes. Apply your knowledge of database development process to design a logical database for an urban hotel based in Nairobi City. Please draw for me a diagram in answer of this

Here is a logical database design for an urban hotel in Nairobi City, represented as a text-based diagram. This design focuses on key entities, their attributes (including primary and foreign keys), and the relationships between them, structured to manage diverse data for decision-making.

---

Logical Database Design for an Urban Hotel in Nairobi City

This design outlines the main entities (tables), their attributes, and how they relate to each other. Primary Keys (PK) are unique identifiers for each record in a table, and Foreign Keys (FK) link records between tables, establishing relationships.

Entities and their Attributes:

• GUEST
  • GuestID (PK)
  • FirstName
  • LastName
  • Email