= ER Дијаграм

[[Image(er3Img.png)]]

== Ентитети

'''Ентитет: Корисник (Customer)'''

Опис: Претставува корисник кој може да прави резервации.

Примарен клуч: customerId (автоматски генериран).

Атрибути:
* Датум на регистрација (registrationDate)
* Име (firstName)
* Презиме (lastName)
* Е-пошта (email)
* Лозинка (password)
* Улога (role)
* Адреса (address)
* Телефон (phone)
* Ниво на членство (membershipLevel)

'''Entity: Restaurant'''

* Description: Represents a restaurant, which contains menus and tables.
* Primary Key: RestaurantID(autogenerated).
* Attributes: rating, socialMediaLinks, website, operatingHours, phone, cusineType, address, name.

* '''Entity: Menu'''

Description: Represents the menu associated with a restaurant.
Primary Key: MenuID(autogenerated).
Attributes: itemName, category, price, description, dietaryInformation.

* '''Entity: Table'''

Description: Represents a table in a restaurant that can be reserved.
Primary Key: TableID(autogenerated).
Attributes: capacity, location, isSmokingArea, description.

* '''Entity: Reservation'''

Description: Represents a reservation made by a customer.
Primary Key: ReservationID(autogenerated).
Attributes: paymentStatus, partySize, reservationDateTime, specialRequests, checkInTime, checkOutTime.

* '''Entity: Payment'''
Description: A weak entity describing the process of paying the reservation.
Partial Key: paymentId - Artificial ID for the payment.
Attributes:
date, reservation_nr, total_price.

== Релации

* Relationship: has

Description: A 1:N relationship between Restaurant and Menu.
Details: Each restaurant has its menu. A restaurant can have multiple menus. A menu belongs to one restaurant.

Relationship: contains

Description: A 1:N relationship between Restaurant and Table.
Details: Each restaurant has multiple different tables. A restaurant contains multiple tables. A table belongs to one restaurant.

Relationship: makes

Description: A 1:N relationship between Customer and Reservation.
Details: A customer can make multiple reservations. A reservation is made by one customer.

Relationship: none specified for Table to Reservation

Details: There seems to be no direct relationship linking tables to reservations, though it might be implicit.