You are given a database $-$ MGMT$2006\_202324$S$02\_$Boutique Inc Student File.accdb,

containing Currencies, Sales, and Locations tables to provide some results for MGMT Boutique

INC. $($That is$,$ your CC will provide you with the database$).$ You should:

$1.$ Rename the database as MGMT$2006\_$Boutique$\_$ is your actual name.

$2.$ Create relationships between pairs of tables and enforce referential integrity

$3.$ Append two $(2)$ new customers, two $(2)$ old customers and two $(2)$ new POS transactions. Be

sure to include sales for your two new customers.

$4.$ Create the following queries:

a$.$ List the names of places from which the company sells. Show all columns in the table.

Name this query Q$1-$SELLING$-$LOCATIONS.

b$.$ What is the total sales by location for May $2008,$ sorted in descending order? Name

this query Q$2-$SALES$-$MAY$2008.($Hint: $$Where$$ clause may be useful$)$

c$.$ The company has been informed that the tax has been increased to $17\mathrm{.}5\%.$ Calculate

how much additional tax $($i$.$e$.,$ the difference$)$ the store would have collected by year.

Name this query Q$3$ ADDED$-$TAX.