complete in the following 60 minutes. (information attaced)instructions: You ha

complete in the following 60 minutes.
(information attaced)instructions: You have been hired to develop a small database for a local store that sells digital cameras. Currently
the owner keeps daily records in paper, like the form shown here.
Here are some of the business rules the company has. The attribute Total is computed by multiplying
the SalePrice times the Quantity. Also, the owner wants to keep the payment information on a
separate table.
Create a new blank Database (Using Microsoft Access) for this part of the exam. Save your Database
using your first and last name (angelikadimoka.accdb)
Following is the final normalized tables (please use this to help create your class diagram)
1. SaleForm(FormID, Date, Time, CustomerID, EmployeeID, CCID, Tax)
2. SaleItems(FormID, ItemID, Quantity, SalePrice)
3. Items(ItemID, Model, Desсrіption, Manufacturer, ListPrice))
4. Customer(CustomerID, CustLastName, CustFirstName, CustPhone, Address, ReferredFrom)
5. Employee(EmployeeID, EmpLastName, EmpFirstName, AssignmentID)
6. Assignment(AssignmentID, Title, Desсrіption, Salary)
7. CreditCard(CCID, CC#, CCCompany, ExpDate)
In Microsoft Access, please do the following:
1. Create the Class diagram in MS Access (tables are provided, please import to MS Access)
2. Create the following Queries in MS Access
a. List all customers Referred by Madonna (Display CustomerLastName,
CustomerFirstName, Phone, Address)
b. Find all the items that were sold in April 2022 (Display ItemID, Model, Desсrіption,
Date)
c. What is the average sale price for all items sold in April 2022 (Display
AverageOfSalePrice)
3. Recreate the Form shown below in MS Access