Changes between Version 5 and Version 6 of Conceptual Design – ER Diagram and Data Requirements


Ignore:
Timestamp:
08/26/25 13:45:07 (7 days ago)
Author:
221531
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Conceptual Design – ER Diagram and Data Requirements

    v5 v6  
    143143    **''belongs''** – relation between Item and Order Items where an item can belong to multiple orders.\\
    144144\\
    145 * Delivery ↔ Delivery Assignment ↔ Delivery Firm \\
    146     **Junction: ** Delivery Assignment solves M:N relation of Delivery and Delivery Firm, by storing the composite key (delivery_id, deliveryfirm_id)\\
     145* Delivery Man ↔ Delivery Assignment ↔ Delivery Firm \\
     146    **Junction: ** Delivery Assignment solves M:N relation of Delivery Man and Delivery Firm, by storing the composite key (deliveryman_id, deliveryfirm_id)\\
    147147
    148     **''assigned''** – relation between Delivery and Delivery Assignment where a delivery can be assigned to multiple firms.\\
     148    **''assigned''** – relation between Delivery Man and Delivery Assignment where a delivery man can be assigned to multiple firms.\\
    149149
    150     **''contracts''** – relation between Delivery Firm and Delivery Assignment, where a delivery firm can contract multiple deliveries.\\
     150    **''contracts''** – relation between Delivery Firm and Delivery Assignment, where a delivery firm can contract multiple delivery mans.\\
    151151\\
    152152* Restaurant Owner ↔ Restaurant Owners ↔ Restaurant \\