= ER Дијаграм

[[Image(er2.png)]]

== Ентитети

'''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: payment_id - Artificial ID for the payment.
Attributes:
date: Payment date.
reservation_nr: Number of reservation paid.
total_price: Derived attribute.