Question: Use Microsoft Access to find and install the Northwind Database with all the information. Convert the database into a SQL document Import all the information

Use Microsoft Access to find and install the Northwind Database with all the information.

Convert the database into a SQL document

Import all the information into MySQL

Start a tee file and:

Run a query on all the items in the inventory

Run a query to find all the sales representatives

Run a query that show items with available inventory above 50

Run a query that show items with available inventory below 0

Run a query on which employees placed orders for Company C

Run a query on amount of all items and the amount sold.

***Bonus*** Run a query on company that sales were between 2000 and 5000, (Requires multiple tables and calculations)

Submit tee file.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!