PLEASE DRAW A BPMN DIAGRAM DRAW ITTT ON PAPPER OR SOMETHING As part of her job, Shelly needs to provide informaiton to her boss and coworkers Imagine you're playing Shelly's role Use the MS Access database file, conduct the following queries(2 5 points each) Shelly's boss Lily is a sales manager, and she wants to find the most loyal customers, thus, we want to query the customers with a balance greater than $3,000 and order the data in descending sequence by the customer's total purchase Lily is interested in getting a list of all invoices for the 4th Quarter of 2017 (October 1 December 31) Include the invoice number, date and total from the invoice table, also display the employee name (first and last) from the Employee table and calculate and include the commission earned using the formula of (inv total emp comm) Format the display of any currency type data to display as such Shelly's works as a sales person, and she wants a list of all product ID, description and prices for our Exterior (prod type), Water based (prod base), Primer (prod category) products Shelly's coworker Jacob is the inventory manager, and he needs to see any products that need replenishment A product needs replenishment if the prod QOH is less than the prod MIN column Display the product's ID, description, quantity on hand (QOH) and minimum number of stock Lily needs to find out which states provide the most sales Display a total of all sales (inv total) for each of the states Order the data by sales in descending sequence Lily also wants to see which how many customers do the store has from each state Shelly is given an important task to organize a party for most junior employees Therefore, she needs a list of employees hired after Dec 31st, 2010 who have a title of Associate or Driver Display their full names along with their emails Order the data by last name Do NOT display the employee's date of hire nor their title Lily wants to give awards to the 5 best employees She asked Shelly to provide the 5 employees with most sales, displaying their names and their total sales Lily also needs to know who the managers of the company are (by having the word Manager as part of the employee's title Create a list that displays the Employee number, name and title Lily asked Shelly to find out which states provide the most sales you need to get a total of all sales (inv total) for each of the states Order the data by sales in descending sequence PLEASE DRAW A BPMN DIAGRAM DRAW ITTT ON PAPPER OR SOMETHING

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 10, 2024

PLEASE DRAW A BPMN DIAGRAM!! ^^DRAW ITTT ON PAPPER OR SOMETHING As part of her job, Shelly needs to provide informaiton to her boss and

PLEASE DRAW A BPMN DIAGRAM!!

^^DRAW ITTT ON PAPPER OR SOMETHING

As part of her job, Shelly needs to provide informaiton to her boss and coworkers. Imagine you're playing Shelly's role. Use the MS Access database file, conduct the following queries(2.5 points each):

Shelly's boss Lily is a sales manager, and she wants to find the most loyal customers, thus, we want to query the customers with a balance greater than $3,000 and order the data in descending sequence by the customer's total purchase.
Lily is interested in getting a list of all invoices for the 4th Quarter of 2017 (October 1 December 31). Include the invoice number, date and total from the invoice table, also display the employee name (first and last) from the Employee table and calculate and include the commission earned using the formula of (inv_total * emp_comm). Format the display of any currency type data to display as such.
Shelly's works as a sales person, and she wants a list of all product ID, description and prices for our Exterior (prod_type), Water based (prod_base), Primer (prod_category) products.
Shelly's coworker Jacob is the inventory manager, and he needs to see any products that need replenishment. A product needs replenishment if the prod_QOH is less than the prod_MIN column. Display the product's ID, description, quantity on hand (QOH) and minimum number of stock.
Lily needs to find out which states provide the most sales. Display a total of all sales (inv_total) for each of the states. Order the data by sales in descending sequence.
Lily also wants to see which how many customers do the store has from each state.
Shelly is given an important task to organize a party for most junior employees. Therefore, she needs a list of employees hired after Dec 31st, 2010 who have a title of Associate or Driver. Display their full names along with their emails. Order the data by last name. Do NOT display the employee's date of hire nor their title.
Lily wants to give awards to the 5 best employees. She asked Shelly to provide the 5 employees with most sales, displaying their names and their total sales.
Lily also needs to know who the managers of the company are (by having the word "Manager" as part of the employee's title. Create a list that displays the Employee number, name and title
Lily asked Shelly to find out which states provide the most sales.you need to get a total of all sales (inv_total) for each of the states. Order the data by sales in descending sequence.

PLEASE DRAW A BPMN DIAGRAM!!

^^DRAW ITTT ON PAPPER OR SOMETHING