ER Дијаграм

Ентитети

Ентитет: Корисник (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.