orders

group: orders

Customer = {
CID, Name, City, State
1, 'Bob', 'New York', 'New York'
2, 'Alice', 'Newark', 'New Jersey'
3, 'Carol', 'Jersey City', 'New Jersey'
4, 'Chuck', 'Boston', 'Massachusetts'
5, 'Craig', 'Newark', 'New Jersey'
}

Order = {
OID, CID, Date
1, 1, '2022-01-01'
2, 1, '2022-02-01'
3, 2, '2022-03-01'
4, 2, '2022-04-01'
5, 3, '2013-12-31'
6, 4, '2022-05-01'
7, 5, '2022-06-01'
8, 2, '2022-07-01'
9, 5, '2022-08-01'
10, 5, '2022-09-01'
}

Product = {
PID, ProductName, Price
1, 'computer', 1000
2, 'keyboard', 100
3, 'mouse', 50
4, 'monitor', 500
5, 'tablet', 600
}

LineItem = {
LID, OID, PID, Number, TotalPrice
1, 1, 1, 1, 1000
2, 2, 2, 1, 100
3, 3, 1, 2, 2000
4, 4, 3, 2, 100
5, 5, 4, 3, 1500
6, 6, 5, 1, 600
7, 7, 5, 2, 1200
8, 8, 5, 3, 1800
9, 9, 5, 4, 2400
10, 10, 3, 5, 250
}