Hi, I have to design an ERD based on these order and delivery note samples.
-Order ID (random)
-Date of order
-table (list of item ordered)
ID (ordered number, random) | Item's name | Description | Unit | Quantity
Delivery note sample
-Delivery note ID (random)
-Place of delivery
-Date of delivery
-table (list of item delivered)
ID (ordered number, random) | Item's name | Unit | Unit Price | Quantity | Total Price per Item
So far I've created an ERD as the one attached. However I notice that each order will have its own delivery note (with the same customer's name, customer's address, item's name, quantity) so there must be some kind of relationship between them. How should I create a relationship between these two entities then?