Second, students will interface with another database for the Northwind Company. Students will be responsible for investigating this database and answering questions below on pages 3-5 about:

• Identifying data input validation controls.
• Designating primary keys and creating relationships.
• Developing and running queries to answer business questions.

Students will be provided two class periods worth of time to begin the tutorial and work through Part I and II requirements. This time is provided for students to become acclimated to Microsoft Access in a space where they can address questions and concerns with the instructor when they arise. Please note that work for this project not completed during class time will need to be completed on the students own time prior to the due date below.

This project will be completed individually and submitted via the Blackboard link on Thursday, February 20 by class time.

Students are expected to submit the project timely. Submissions will be marked down 5 points per day late. Point distribution per question are noted on each question where a deliverable is required.

1. Under database tools, select relationships. Per table listed below, create relationships among the tables and list them below (17 points total).
   1. Hint: to refresh your memory on creating relationships, please refer to the Step C in the tutorial. Relationship type guide (refer to Appendix A on page 22 in the tutorial guide):
      1. 1:1 (one-to-one): either of the tables primary keys may be the foreign key.
      2. 1: (one-to-many): the primary key on the one side is embedded as the foreign key on the many side.
      3. : (many-to-many): primary keys from each table become foreign keys in a separate linking table (an associative entity).

Table Name	Related Table (1 point each)	Linking Attribute (1 point each)	Relationship Type (1 point each)
Inventory
Order
Employee
Customer
Shipper

2. Pick one relationship and explain its relationship type (refer back to Step C in the tutorial guide for examples) (2 points).

2. Develop and run the queries below based on the following questions (38 points total).
   1. For Query #6, develop and run a query based on a question you develop.

Query #	Question	Name(s) of tables (1 point each)	Attribute(s) (1 point each)	Criteria and/or sort type and/or group by (1 point each)	Answer (2 points each)
Example	How many customers are there in Germany?	Customer	CustomerID; Country	Count of CustomerID; Criteria of Germany for Country	11
1	What are the top two most ordered product IDs and what is the total quantity sold of each?
2	Which shipper(s) did Northwind use to ship orders on 5/30/1996 and how many orders did each shipper ship?
3	Which customers (provide names) have never placed an order? Hint: think about your experience with finding unmatched items
4	Which three employees had the most sales and what is the total quantity of sales each?
5	Which customer (provide name) purchased products on 8/22/1994 and what products (provide names) and how many of each product was ordered?
6

2. Interpret why the query you developed could be important in making future business decisions. Be specific (8 points).