Changes between Version 12 and Version 13 of konceptualenDizajn


Ignore:
Timestamp:
12/16/24 16:01:47 (4 weeks ago)
Author:
213209
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • konceptualenDizajn

    v12 v13  
    55== Ентитети
    66
    7 * '''Entity: Customer'''
     7'''Ентитет: Корисник (Customer)'''
    88
    9 Description: Represents a customer who can make reservations.
    10 Primary Key: customerId(autogenerated).
    11 Attributes:
     9Опис: Претставува корисник кој може да прави резервации.
     10Примарен клуч: customerId (автоматски генериран).
     11Атрибути:
     12* Датум на регистрација (registrationDate)
     13* Име (firstName)
     14* Презиме (lastName)
     15* Е-пошта (email)
     16* Лозинка (password)
     17* Улога (role)
     18* Адреса (address)
     19* Телефон (phone)
     20* Ниво на членство (membershipLevel)
    1221
    13 * '''Entity: Restaurant'''
     22'''Entity: Restaurant'''
    1423
    15 Description: Represents a restaurant, which contains menus and tables.
    16 Primary Key: RestaurantID(autogenerated).
    17 Attributes:
     24* Description: Represents a restaurant, which contains menus and tables.
     25* Primary Key: RestaurantID(autogenerated).
     26* Attributes: rating, socialMediaLinks, website, operatingHours, phone, cusineType, address, name.
    1827
    1928* '''Entity: Menu'''
    … …  
    2130Description: Represents the menu associated with a restaurant.
    2231Primary Key: MenuID(autogenerated).
    23 Attributes:
     32Attributes: itemName, category, price, description, dietaryInformation.
    2433
    2534* '''Entity: Table'''
    … …  
    2736Description: Represents a table in a restaurant that can be reserved.
    2837Primary Key: TableID(autogenerated).
    29 Attributes:
     38Attributes: capacity, location, isSmokingArea, description.
    3039
    3140* '''Entity: Reservation'''
    … …  
    3342Description: Represents a reservation made by a customer.
    3443Primary Key: ReservationID(autogenerated).
    35 Attributes:
     44Attributes: paymentStatus, partySize, reservationDateTime, specialRequests, checkInTime, checkOutTime.
    3645
    3746* '''Entity: Payment'''
    … …  
    3948Partial Key: paymentId - Artificial ID for the payment.
    4049Attributes:
    41 date: Payment date.
    42 reservation_nr: Number of reservation paid.
    43 total_price: Derived attribute.
     50date, reservation_nr, total_price.
    4451
    4552== Релации
    … …  
    4855
    4956Description: A 1:N relationship between Restaurant and Menu.
    50 Details:
    51 A restaurant can have multiple menus.
    52 A menu belongs to one restaurant.
     57Details: Each restaurant has its menu. A restaurant can have multiple menus. A menu belongs to one restaurant.
     58
    5359Relationship: contains
    5460
    5561Description: A 1:N relationship between Restaurant and Table.
    56 Details:
    57 A restaurant contains multiple tables.
    58 A table belongs to one restaurant.
     62Details: Each restaurant has multiple different tables. A restaurant contains multiple tables. A table belongs to one restaurant.
     63
    5964Relationship: makes
    6065
    6166Description: A 1:N relationship between Customer and Reservation.
    62 Details:
    63 A customer can make multiple reservations.
    64 A reservation is made by one customer.
     67Details: A customer can make multiple reservations. A reservation is made by one customer.
     68
    6569Relationship: none specified for Table to Reservation
    6670