e some results for MGMT Boutique INC. You should: 1. Rename the database as MGMT2009_Boutique_ is your actual name. 2. Create relationships between pairs of tables and enforce referential integrity (NUMBER 1 & 2 HAVE ALREADY BEEN DONE PLEASE DO NOT ANSWER) PLEASE ANSWER OR ASSIST WITH THE FOLLOWING: (KINDY SHOW AN EXAMPLE possibly using any or your won made up database of how the following is done since the actual database for this task is not avaiable) 3. Append two (2) new customers, two (2
Please assist with the following Practie Excersises:
You are given a
You should: 1. Rename the database as MGMT2009_Boutique_ is your actual name. 2. Create relationships between pairs of tables and enforce referential integrity (NUMBER 1 & 2 HAVE ALREADY BEEN DONE PLEASE DO NOT ANSWER)
PLEASE ANSWER OR ASSIST WITH THE FOLLOWING: (KINDY SHOW AN EXAMPLE possibly using any or your won made up database of how the following is done since the actual database for this task is not avaiable)
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 Q1-SELLING-LOCATIONS
b. What is the total sales by Location for May 2008, storted in decending order? name the query Q2-SALES-MAT2008 (hint: "where" clause may be useful)
c. The company has been informed that the tax has increased to 175%. Calculate how much additional tax (i.e the difference) would have been collected bythe store by year. Name this query - ADDED TAX
Step by step
Solved in 3 steps
