⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠
Excalidraw Data
Text Elements
Shipment
PK,FK
Product_ID
Order_NUmber
ShipOrderDate
Customer
PK
Customer_ID
FirstName
LastName
Street
City
Zip
Phone
Order
FK
Order_number
Customer_ID
Customer_name
To_street
To_city
To-zip
Product_ID
One Order can only have one customer
A prodct can be part of no or many orders
A customer can have at min 0 orders and at max an inifite ammount so 0 to many
One order can have one or manny Prodcuts
Key
adding primary keys etc
Customer
Key
Key
Key
Key
Key
Key
Customer_ID
FirstName
LastName
Street
City
Zip
Phone
Order
PK
Key
Key
Key
Key
Key
Key
Order_number
Customer_ID
Customer_name
To_street
To_city
To-zip
Ship_date
Product
Key
Key
Key
Produkt_ID
Quantity
Product_type
Example for relations
PK
The customerid is a foregin key in the order table so that you can know which customer made the order
Ship_date
FK
Product
PK
Product_ID
Quantity
Product_type
PK,FK
ChargeCardTime
PackingTime
In the Shipment Entity Prodct_ID and Order_NUmber are combined to create composite Primary key, so you get a unieque value