Customers
CustomerID
Name
Email
1
Jane Doe
jane@example.com
2
John Smith
john@example.com
3
Sam Lee
sam@example.com
Menu
DrinkID
DrinkName
Price
UnitCost
101
Latte
4.50
1.20
102
Cappuccino
4.25
1.10
103
Espresso
3.00
0.80
104
Mocha
4.75
1.30
Orders
TransactionID
Date
CustomerID
DrinkID
1001
2023-10-01
1
101
1002
2023-10-02
2
103
1003
2023-10-03
1
102
1004
2023-10-04
3
104