Database Assignment
The following activities use the Northwind database, which is available from your instructor.
1. Create a query that shows the Country, City, CustomerID, and Customer CompanyName for all customers located in France, Spain, or Sweden. Sort the query by Country, then CompanyName.
2. Create a query that shows the ProductID, ProductName, and UnitPrice for all products with a UnitPrice greater than $50. Sort the query in descending order of UnitPrice. 10pts.
3. Create a query that shows the CategoryName, ProductID, ProductName, and UnitPrice for all products in the Produce or Seafood categories. Sort the query in order of CategoryName, then ProductName. 10 pts.
4. Create a query that shows the Supplier CompanyName, CategoryName, ProductID, and ProductName for all products in the Produce or Seafood categories. Sort the query in order of Supplier CompanyName, then CategoryName, then ProductName. 10 pts.
5. Create a query that shows the OrderID, OrderDate, Customer CompanyName, and Country for all orders placed by customers in the United Kingdom. Sort the query by CompanyName.
6. Create a query that shows the OrderID, OrderDate, Customer CompanyName, ProductName, Quantity, and UnitPrice for all products included in the order. Use UnitPrice from the Order Details table (not the Products table). Only show orders from the companies named "Lonesome Pine Restaurant" or "Rattlesnake Canyon Grocery." Sort the query by OrderDate, then CompanyName.
7. Create a form that will let you enter data for all fields included in the Customers table.
8. Create a form that shows the CategoryID, CategoryName, and Description for each category, along with the ProductID, ProductName, and UnitPrice for all products in that category. The form should have Category in the main form and Products in the subform. 10 pts.
9. Create a well-formatted report that shows the data from the query in Activity #2.
10. Create a well-formatted report that shows the Supplier's CompanyName, CategoryName,ProductName, and UnitPrice for all products. 5 pts.
11. Create a well-formatted report that shows the data from the query in Activity #6.
Please submit your Northwind database with your name as the filename to Blackboard through the submission link.