ER Дијаграм

Ентитети

Entity: Customer

Description: Represents a customer who can make reservations. Primary Key: customerId(autogenerated). Attributes:

Entity: Restaurant

Description: Represents a restaurant, which contains menus and tables. Primary Key: RestaurantID(autogenerated). Attributes:

Entity: Menu

Description: Represents the menu associated with a restaurant. Primary Key: MenuID(autogenerated). Attributes:

Entity: Table

Description: Represents a table in a restaurant that can be reserved. Primary Key: TableID(autogenerated). Attributes:

Entity: Reservation

Description: Represents a reservation made by a customer. Primary Key: ReservationID(autogenerated). Attributes:

Entity: Payment Description: A weak entity describing the process of paying the reservation. Partial Key: paymentId - Artificial ID for the payment. Attributes: date: Payment date. reservation_nr: Number of reservation paid. total_price: Derived attribute.