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
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