This is homework for Accounting Information Systemes

HW2 Accounting Information Systems Due on June 9 2015- Total 30pt 1. By using given database specify the primary key(s), foreign key(s), and other data for each table. (2pt) Table Name Primary Key Foreign Keys (indicate a related table as well) Other Attributes 2. Retrieve Miguel Inc. databases. Write queries to answer the follow question. (Please provide me SQL queries (Hard Copy and/or Blackboard) as well as your actual access file (Blackboard).) (4 pt each) 1) How many different kinds of inventory items does Miguel Inc. sell? 2) List SalesInvoiceNumber made during October. 3) What were total sales ($ amount) in October? List total sales amount (name it as TotalSales). 4) What was the average dollar amount of each sales transaction? List average dollar amount of each sales transaction as to AveSales and its invoice number. 5) Which salesperson made the sales larger than $3,000? (List Salesperson name and the total dollar amount the salesperson made (name it as SuperSales)) 6) How many units of each product were sold? List ItemNumber, ItemDescription, and the number of each product (name it to SalesQuantity.) (Hint: Group by SalesInventory.ItemNumber, Inventory.Description) 7) Which product was sold equal or more than three transactions? List ItemNumber and the number of transaction (name it to QuantSales.)