Changes between Version 2 and Version 3 of Conceptual Design – ER Diagram and Data Requirements

Timestamp:

08/26/25 13:08:05 (2 months ago)

Author:

221531

Comment:

--

Conceptual Design – ER Diagram and Data Requirements

@@ -1 +1 @@
 
 == ER Diagram
-[[Image(ticket:1:Diagram.jpg​)]]
+[[Image(ticket:2:ER_Diagram.jpg​)]]
 
 == Data Requirements
@@ -100 +100 @@
 * ingredient_id - primary key, numeric, required
 * name - text type, required
+
+=== Relations===
+=== 1:1 ===
+* Restaurant → Menu  \\
+    **''has''** – a relation which indicates that a restaurant has one menu and a menu belongs to only one restaurant.
+
+* Address → Restaurant  \\
+    **''is_located_at''** – a relation which indicates that a restaurant is located at one location, and a location can have only 1 restaurant.
+=== 1:M ===
+* User → Address  \\
+    **''has''** – a relation which indicates that a user can have multiple addresses, and an address can belong to one user.
+
+* Customer → Order  \\
+    **''has''** – a relation which indicates that a user can have multiple addresses, and an address can belong to one user.
+=== M:N ===