Changes between Version 13 and Version 14 of Logical and Physical Design – Database Creation

Timestamp:

08/28/25 20:10:56 (5 days ago)

Author:

221531

Comment:

--

Logical and Physical Design – Database Creation

@@ -4 +4 @@
 === Notation
 - Entities are denoted with capital letters and their attributes are defined (a1, a2, ..., an) where n is the number of attributes the entity has.
-- Primary keys are denoted with underscore and boldness.
-- Foreign keys are denoted with asterisk suffixing the attribute.
+- Primary keys are written in bold and underline.
+- Foreign keys are marked with asterisk after the attribute name.
 \\
 === Relations - Relational Schema
-**USER**(**__user_id__**, first_name, last_name, email, password, phone)
+**APP_USER**(**__user_id__**, first_name, last_name, email, password, phone, **__administrator_id*__**(ADMINNISTRATOR))
 \\
 \\
-**RESTAURANT_OWNER**(**__user_id*__**(USER))
+**ADMINISTRATOR**(**__user_id*__**(APP_USER), authorized_from, authorized_to)
 \\
 \\
-**DELIVERY_MAN**(**__user_id*__**(USER))
+**RESTAURANT_OWNER**(**__user_id*__**(APP_USER))
 \\
 \\
-**CUSTOMER**(**__user_id*__**(USER))
+**DELIVERY_MAN**(**__user_id*__**(APP_USER))
 \\
 \\
-**ORDER**(**__order_id__**, **user_id***(USER), **__address_id*__**(ADDRESS),order_date, comment, status)
+**CUSTOMER**(**__user_id*__**(APP_USER))
+\\
+\\
+**ORDERS**(**__order_id__**, **address_id***(ADDRESS), **restaurant_id***(RESTAURANT), **deliveryman_id***(DELIVERY_MAN), **user_id***(CUSTOMER), **__address_id*__**(ADDRESS),order_date, comment, order_status, total_amount)
 \\
 \\
@@ -53 +56 @@
 \\
 \\
-**MENU**(**__menu_id__**, **__restaurant_id*__**(RESTAURANT), **__item_id*__**(ITEM), created_at, updated_at, name)
+**MENU**(**__menu_id__**, **__restaurant_id*__**(RESTAURANT), created_at, updated_at, name)
 \\
 \\
 **CATEGORY**(**__category_id__**, name, description)
+\\
+\\
+**MENU_ITEM**(**__menu_id*__**(MENU), ***__item_id__**(ITEM))
 \\
 \\