Overview
This lecture presents the Entity-Relationship Diagram (ERD) for a hotel database, highlighting the core entities, their attributes, and relationships.
Main Entities in the Hotel ERD
- The ERD includes primary entities such as Guest, Room, Reservation, and Payment.
- Each entity contains relevant attributes; for example, Guest includes GuestID, Name, Address, etc.
- Room entity typically includes RoomID, RoomType, and Status.
- Reservation connects Guests to Rooms and includes ReservationID, CheckInDate, and CheckOutDate.
- Payment entity is linked to Reservation and contains PaymentID, Amount, and PaymentDate.
Relationships Between Entities
- A Guest can make multiple Reservations; each Reservation is for a specific Room.
- Each Reservation may result in one or more Payments.
- A Room can be reserved multiple times over different dates.
Key Terms & Definitions
- Entity — An object or concept in the system, such as Guest or Room, represented as a table in the ERD.
- Attribute — A property describing an entity, like Name for Guest or Amount for Payment.
- Relationship — A connection between entities, like a Guest makes a Reservation.
- Primary Key — A unique identifier for an entity, such as GuestID or RoomID.
- Foreign Key — An attribute that links one entity to another, ensuring referential integrity.
Action Items / Next Steps
- Review each entity and its attributes in the ERD diagram.
- Practice identifying relationships and keys between entities.
- Prepare for questions on hotel database design using ERDs.