OrdersWithCustomers
CustomerID
Name
Address
OrderID
Item
1
Alice
101 Main
501
Widget
1
Alice
101 Main
502
Gadget
2
Bob
42 Oak
503
Gizmo
Customers
CustomerID
Name
Address
1
Alice
101 Main
2
Bob
42 Oak
Orders
OrderID
CustomerID
Item
501
1
Widget
502
1
Gadget
503
2
Gizmo