Create the Conceptual Model and Relational Model diagrams and insert them in the

assignment document.

Download the $$AP$2\_$populate$\_$tables.doc$$ file and run the queries to populate the

tables. Write and run the following queries:

$4.$ Create a new customer in the $$CustomerDim$$ table. The data should be your name,

your APIC campus address $($Sydney$,$ Melbourne, or Brisbane$),$ state where you live,

and your APIC email address. Create a new product in the $$ProductDim$.$

$5.$ Create a new sale inserting a new record in the $$SaleFacts$$ table. The record must

contain the reference to the new customer and the new product.

$6.$ Display the product names, brands and prices.

$7.$ Display warehouse names $($divisions$)$ located in Victoria.

$8.$ Display the amount $($$$)$ of sales in $2018.$ To do this you need to multiply the product

price by quantity and find the total.

$9.$ Display the total amount of sales for each branch separately. The result must have

three columns: branch address, branch state and the total for this branch.

$10.$ Display the total amount of sales for each warehouse and product separately. The

result must contain $3$ columns: warehouse name, product name and the total.

$11.$ Display a number of sales $($not $$!)$ for each product. The result must contain two

columns: product name and the number of sales for this product.

$12.$ For each sale display the date, branch name, customer name, warehouse name and

the sale quantity.

$13.$ Calculate a total amount of sales in the second quarter of $2017.$

$14.$ Calculate a total amount of sales in September $2017.$

Submit the assignment MS Word document in the Canvas Applied Project $2.$

Don$$t forget to include the assignment cover sheet!!!