Studybay uses cookies to ensure that we give you the best experience on our website. By continuing to use Studybay you accept our use of cookies view more on our Cookie Policy
How can I earn money with StudyBay Top writers
Order Assignment
This order has already been completed on Studybay
On Studybay you can order your academic assignment from one of our 45000 professional writers. Hire your writer directly, without overpaying for agencies and affiliates! Check price for your assignment
12 total offers received. Writer hired: Hopkins1

Computer Science - Assignment 6, Reports

Please down the "DePaul Merchants" database available as part of this assignment. DePaul Merchants is a trading company that sells products to other businesses. The database is a Microsoft Access database containing several tables: Customers: Contains information for all the customers. Employees: Contains information for all the employees. Products: Contains information for all the products that are being sold. Categories: Contains information for the categories of the products. Suppliers: Contains information for all the suppliers and vendors of the products. Shippers: Contains information for the companies that DePaul Merchants uses for shipping products to the customers. Orders: Contains information for the orders placed by the customers. Order Details: Contains information for the details of each order that contains the various products purchased in each order. In this assignment, you will be creating queries using the Access database. Design and test query based on each questions below. Save each query and name it for each question i.e., for question #1, name the query as "Q1". Here are the questions for which you would need to create queries: 1.) List all customers sorted by company name in ascending order. 2.) List the country and count of customers in each country sorted in descending order. 3.) List the orders placed by each customer and which employee placed the order on what date? 4.) List the total order price for each order placed by the customer. List the customer name and the (sum of UnitPrice * Quantity) for each order. 5.) List which shipping company was used the most for shipping products to the customers? 6.) List each supplier and the total count of products each supplier supplies to DePaul Merchants. 7.) List all non-discontinued products. 8.) List all non-discontinued products which needs to be reordered (hint: where reorder level < (units in stock + units on order)) 9.) List each category and the count of products for each category. 10.) List all customers whose contact name begins with "Ma"
Please down the "DePaul Merchants" database available as part of this assignment. DePaul Merchants is a trading company that sells products to other businesses. The database is a Microsoft Access database containing several tables: Customers: Contains information for all the customers. Employees: Contains information for all the employees.
Assignment ID
59632
CREATED ON
8 November 2016
COMPLETED ON
9 November 2016
Price
$30
This order has already been completed on Studybay
On Studybay you can order your academic assignment from one of our 45000 professional writers. Hire your writer directly, without overpaying for agencies and affiliates!
Check price for your Reports
A technical report on an issue
Reports, Computer Science
Price 30 $
Security, privacy, trust for big data
Reports, Computer Science
Price 30 $
Introduction to information systems
Reports, Computer Science
Price 30 $
Studybay assignment progress timeline
Studybay is a freelance platform where you can order a Computer Science - Assignment 6, Reports paper, written from scratch by professors and tutors.
8 November 2016
User posted an order for Computer Science
8 November 2016
12 writers responded and offered to do the job for a price between $15 and $15
8 November 2016
User contacted writer Hopkins1
8 November 2016
User hired writer Hopkins1 who offered a price of $15 for the job and has experience doing similar assignments
9 November 2016
Writer completed order Computer Science - Assignment 6, Reports for 1 day, meeting the deadline
9 November 2016
User accepted the job right away and completed the payment
9 November 2016
User left a positive review
Molar Mass of Ethanol and Other Main Facts
What is the molecular weight of ethanol? You will get to know more about the molar mass of ethanol as you check this out.
What the Surface Area of a Cylinder Is
To calculate the surface area of a cylinder correctly and easily, you need to get more information about specific formulas and basic definitions.
Things that will help you understand how to write an ode
Knowing how to write an ode makes one versatile and strong as a poet. Odes help readers to feel exuberant and awestruck as the poets.
Indoor And Outdoor Game titles Children And TEENAGERS Essay
Young People I have chosen this topic because I have discovered many child's who are incredibly fond of participating in video games became ambitious and...
Other assignments in this discipline
Linear regression in r
Code, Computer Science
Price 30 $.
Management backup and dr
Coursework, Computer Science
Price 40 $.
Discussion
Coursework, Computer Science
Price 40 $.
Shell canada fuels productivity with erp
Essay, Computer Science
Price 30 $.
Business intelligence and decision support
Coursework, Computer Science
Price 40 $.
Business intelligence and decision support
Research Paper, Computer Science
Price 40 $.
Enterprise systems architecture, development life cycle
Essay, Computer Science
Price 30 $.
Matlab
Code, Computer Science
Price 30 $.
banks banking on network security
Case Study, Computer Science
Price 40 $.
Literature review
Thesis, Computer Science
Price 140 $.
The digital divide
Coursework, Computer Science
Price 40 $.
Summary and research idea for network security papers
Research Proposal, Computer Science
Price 60 $.

Reviews about the work performed

4.9
quality
rating
3
reviews