Create report to show the total fee due to each distributor

Assignment Help Operation Management

Reference no: EM133569212

Assignment: Lab Exercise- Database Entry, Queries and Reports

Use the Coke database to perform the following steps:

Question A. Enter the data in the tables in the specified order:

1. Customer
2. Distributor
3. Category
4. Product
5. Order
6. OrderLine

Question B. Create a query with fields Customers name and phone whose orders were supplied by the distributor Van Distributors.

Question C. Create a query to show the number of orders that contains Coca-Cola.

Question D. 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 CategoryId).

Question E. Create a query to show the distributor that distributed the most orders.

Question F. Create a query to show the customer, his order and the total quantity of products in each order.

Question G. Create a report to show the total fee due to each distributor.

Question H. Create a report to show the daily invoice for each customer (prices for products and their totals).

Reference no: EM133569212

Questions Cloud

Explain your chosen work art historical significance : Explain your chosen work's art historical significance, what was so revolutionary or significant about it that the work made it to the art history books.

What can you do as a leader to ensure your project team : Using the information you learned from readings, what can you do as a leader to ensure your project team that this is the right thing to do?

Explain the essential facts of the case : Explain the essential facts of the case. Tell the story of the case. State the decision in administrative hearings and in the lower court(s) Rationale:

How to reply in a paragraph saying how much it means to you : how to reply in a paragraph saying how much it means to you to lead a training and help mentor young staff develop and how honored you are to be a selected

Create report to show the total fee due to each distributor : Create a query to show the customer, his order and the total quantity of products in each order. Create a report to show the total fee due to each distributor.

What is the overall focus of goffman most famous study : what is the overall focus of Goffman's most famous study? Discuss what "dramaturgy" involves and what the video describes it to be.

How do you interpret eve in the 21st century : How do you interpret Eve in the 21st century? Did Eve have the attributes of a feminist? Could it be the reason male interpreters of Genesis blamed her

What kind of culture would you rather live in : What kind of culture ( masculine or feminine) would you rather live in? Explain why you prefer one culture over another noting the "cons" too.

Describe how your findings from relevant research literature : Describe how your findings from the relevant research literature can shape, inform and improve current business and professional practice related to your topic.

User Account

All Pages