Scribd
Upload
12 views5 pages

Products

The document contains a detailed inventory of products including their IDs, names, categories, prices, and stock status. It also includes a list of customer orders with details such as order IDs, customer names, dates, total amounts, and payment methods. Additionally, employee information and their shifts are provided, detailing their IDs, names, positions, hourly rates, and hours worked.

Uploaded by

mugetsu978
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
12 views5 pages

Products

The document contains a detailed inventory of products including their IDs, names, categories, prices, and stock status. It also includes a list of customer orders with details such as order IDs, customer names, dates, total amounts, and payment methods. Additionally, employee information and their shifts are provided, detailing their IDs, names, positions, hourly rates, and hours worked.

Uploaded by

mugetsu978
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

ProductID

ProductNameCategory UnitPrice CostPrice InStock


1 Espresso Hot Drinks 3.5 1.2 TRUE
2 Cappuccin Hot Drinks 4 1.5 TRUE
3 Latte Hot Drinks 4.5 1.7 TRUE
4 AmericanoHot Drinks 3 1 TRUE
5 Mocha Hot Drinks 4.8 1.9 TRUE
6 Hot ChocolHot Drinks 4.2 1.6 TRUE
7 Iced CoffeeCold Drinks 4 1.5 TRUE
8 Iced Tea Cold Drinks 3.5 1.2 TRUE
9 Smoothie Cold Drinks 5.5 2.2 TRUE
10 Croissant Pastries 2.5 0.9 TRUE
11 Chocolate Pastries 3 1.1 TRUE
12 Cheese Ca Desserts 4.5 1.8 TRUE
13 Chocolate Desserts 4.5 1.8 TRUE
OrderID
CustomerName
OrderDateOrderTime
TotalAmount
PaymentMethodStatus
1 John Smith2025-04-0 08:30:00 12.5 Cash Completed
2 Emily John2025-04-0 09:15:00 9 Credit CardCompleted
3 Michael B 2025-04-0 10:45:00 15.8 Cash Completed
4 Sarah Wils 2025-04-0 12:30:00 22.5 Credit CardCompleted
5 David Lee 2025-04-0 09:00:00 8 Cash Completed
6 Jessica Tay2025-04-0 11:20:00 17.3 Credit CardCompleted
7 Daniel Mar2025-04-0 14:45:00 13 Mobile Pa Completed
8 Rachel And2025-04-0 08:15:00 7.5 Cash Completed
9 Thomas Ja 2025-04-0 10:00:00 19.8 Credit CardCompleted
10 Lisa Garcia2025-04-0 13:30:00 11.5 Mobile Pa Completed
OrderDetailIDOrderID ProductID Quantity UnitPrice Subtotal
1 1 1 2 3.5 7
2 1 10 1 2.5 2.5
3 1 11 1 3 3
4 2 4 1 3 3
5 2 8 1 3.5 3.5
6 2 10 1 2.5 2.5
7 3 3 2 4.5 9
8 3 12 1 4.5 4.5
9 3 11 1 3 3
10 4 5 1 4.8 4.8
11 4 7 2 4 8
12 4 9 1 5.5 5.5
13 4 10 1 2.5 2.5
14 4 11 1 3 3
15 5 2 2 4 8
16 6 3 2 4.5 9
17 6 12 1 4.5 4.5
18 6 10 1 2.5 2.5
19 6 11 1 3 3
20 7 5 1 4.8 4.8
21 7 9 1 5.5 5.5
22 7 10 1 2.5 2.5
23 8 1 1 3.5 3.5
24 8 4 1 3 3
25 8 11 1 3 3
26 9 5 2 4.8 9.6
27 9 12 1 4.5 4.5
28 9 13 1 4.5 4.5
29 10 3 1 4.5 4.5
30 10 8 2 3.5 7
EmployeeIDFirstName LastName Position HourlyRate HireDate
1 James Wilson Manager 18 2024-01-15
2 Linda Martinez Barista 14.5 2024-02-01
3 Robert Johnson Barista 14.5 2024-02-10
4 Susan Garcia Cashier 13.5 2024-02-15
5 Michael Brown Barista 14.5 2024-03-01
ShiftID EmployeeID Date StartTime EndTimeHoursWorked
1 1 2025-04-0 07:00:00 15:00:00 8
2 2 2025-04-0 07:00:00 13:00:00 6
3 3 2025-04-0 13:00:00 21:00:00 8
4 4 2025-04-0 13:00:00 21:00:00 8
5 1 2025-04-0 07:00:00 15:00:00 8
6 2 2025-04-0 07:00:00 13:00:00 6
7 3 2025-04-0 13:00:00 21:00:00 8
8 5 2025-04-0 13:00:00 21:00:00 8
9 1 2025-04-0 07:00:00 15:00:00 8
10 4 2025-04-0 07:00:00 13:00:00 6
11 3 2025-04-0 13:00:00 21:00:00 8
12 5 2025-04-0 13:00:00 21:00:00 8

You might also like