Q1: (10 points) Create a Database using access to implement the revenue cycle.

Prepare the tables and implement the relationship in the database design. Input 2-3 make-up records in each table. In the table, dont leave the Foreign_key to be null, I need you to input Foreign keys so you understand the Referential Integrity rules. (Save as 2-2-DB-Implementation-Name).

Q2: (10 points) Use the Access_Practice.accdb database to complete the following tasks:

What are the Invoice and Sales Person for customer Lcs Industries Inc.

What are the names and addresses of customers buying vanilla between 10/01/2017 to 12/31/2017

Calculate the total sales for each inventory item.

What are sales amount for each invoice? Based on the sales amount for each invoice, What are total sales amount for each employee?

What are the total sales for each customer?

Save all the queries and send me the Access file with the queries.

(Save the file as 2-2-DB-Query-Name)

ENTITY TABLES M:N RELATIONSHIP TABLES INVENTORY-ORDER Item# Order# Quantity Ordered INVENTORY-SALE Item# Sales# Quantity Shipped INVENTORY Item# Description Order Date CUSTOMER ORDER EMPLOYEE Order# Employee# Employee Name Date of Birth Date Hired Department [Customer#] Sales Price Quantity | | [Employee#] SALES (SHIP) Sales# Ship Date Customer#] [Employee#] CASH Account# CUSTOMER Customer# Name Address SALE/RECEIVE CASH Sales# Cash Receipt# Account Type | | Bank Balance RECEIVE CASH | Cash Receipt | | ZipCode Amount Received Date Received [Employee#] [Account#] [Customer#] Credit Limit