Download a copy of theDatabase Examples/Northwinddatabase for your selected database application. Review the E-R diagram in your database application to verify that it matches theDatabase Examples/Northwindexample. Note the primary keys, foreign keys, and relationships. Then create QBE queries to determine results for each of the following. View the SQL generated for each query. Select all fields and all records in the Categories table. Select the CustomerName for all customers. Select the CustomerName for all customers in the country 'Italy'. Select the ProductName for all products in Category 1 with a price less than $5.00. Select the SupplierName for all suppliers from English-speaking countries (Australia, Canada, UK, USA) Select the first and last names of all employees having a birthday in September. Select the CustomerName and OrderID for all orders placed on 9 September 1996. Select the ProductName for all seafood products with a supplier from 'Boston'. Select the CustomerName and OrderID for all customers who ordered 'Aniseed Syrup', sorted in alphabetical order. Select the ProductName, Quantity, Price, and ExtendedPrice (Quantity * Price) for orders 10344 and 10345. Select the first and last names and current age of all employees having a birthday in September. Select the OrderID, count of products ordered, and total order cost for orders 10344 and 10345. Select the total number of orders and total cost of orders shipped by 'Speedy Express' in February 1997.

Download a copy of theDatabase Examples/Northwinddatabase for your selected database application. Review the E-R diagram in your database application to verify that it matches theDatabase...

Sep 11, 2021