Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Lab Exercise: Database Entry, Queries and Reports This document contains 5 pages. Use the Coke database to perform the following steps: 1. Enter the
Lab Exercise: Database Entry, Queries and Reports This document contains 5 pages. Use the Coke database to perform the following steps: 1. Enter the data in the tables in the specified order (SEE PAGE 2 FOR DATA): I a. Customer b. Distributor C. Category d. Product e. Order f. OrderLine 2. Create a query with fields Customers name and phone whose orders were supplied by the distributor Van Distributors. 3. Create a query to show the number of orders that contains Coca-Cola. 4. Create a query to show the total amount of items ordered by category (Note: you would want to use the category name instead of the Categoryld). 5. Create a query to show the distributor that distributed the most orders. 6. 7. Create a report to show the total fee due to each distributor. 8. Create a query to show the customer, his order and the total quantity of products in each order. Create a report to show the daily invoice for each customer (prices for products and their totals). PLEASE SEE PAGE 2 FOR THE DATA
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started