62672 - access/part A/Customer_Delivery.accdb
product_id actual_order_id
1 1
2 2
3 3
actual_order_id order_status_code customer_Id actual_order_date order_details
1 paid 1 7/28/20 order placed
2 delivered 2 7/31/20 order delivered
3 paid 3 8/1/20 order completed
Customer_id payment_method customer_name customer_phone customer_email
1 cash Lucy 576767777
[email protected] 2 card Joseph 0477988779
[email protected] 3 cash henry 465657777
[email protected] delivery_id actual_order_id delivery_status driver_employee_id truck_id delivery_date
1 1 delivered 1 1 7/29/20
2 2 shipped 2 2 7/31/20
3 3 delivered 3 2 8/6/20
Employee_Id Employee_Name Employee_phone
1 Joy 567677777
2 William 786577775
3 Sarah 564566556
product_id supplier_id product_name product_price product_description
1 1 Laptop ¤ 89.00
2 2 computer ¤ 100.00
3 3 CPU ¤ 50.00
Truck_Id truck_licence_number truck_details
1 3445555 Large
2 54545 Small
3 45645 better mileage
SELECT Employee.[Employee_Id], Employee.[Employee_Name], Employee.[Employee_phone]
FROM Employee
ORDER BY Employee.[Employee_Name];
SELECT Deliveries.[delivery_id], Deliveries.[actual_order_id], Deliveries.[delivery_status], Deliveries.[driver_employee_id], Deliveries.[truck_id], Deliveries.[delivery_date]
FROM Deliveries;
SELECT Customer.[Customer_id], Customer.[payment_method], Customer.[customer_name], Customer.[customer_phone], Customer.[customer_email]
FROM Customer
WHERE Customer.[customer_phone] = '0477988779';
62672 - access/part A/Report.docx
SELECT Employee.[Employee_Id], Employee.[Employee_Name], Employee.[Employee_phone]
FROM Employee
ORDER BY Employee.[Employee_Name];
SELECT Employee.[Employee_Id], Employee.[Employee_Name], Employee.[Employee_phone]
FROM Employee
ORDER BY Employee.[Employee_Name];
SELECT Customer.[Customer_id], Customer.[payment_method], Customer.[customer_name], Customer.[customer_phone], Customer.[customer_email]
FROM Customer
WHERE Customer.[customer_phone] = '0477988779';
62672 - access/Part B/Customer_Delivery.accdb
product_id actual_order_id
123 C001
124 C003
124 C005
order_status_code customer_Id actual_order_date order_details actual_order_id
Not_Delivered 1 8/4/20 order placed C001
Delivered 2 7/31/20 order delivered C003
Not_Delivered 3 8/1/20 order...