Project Requirements Due week 8 (Mar 9) – 20% You are given a database containing Customer, Service, Call and Rates tables to provide some results for MMC. (That is, your CC will provide you with the database). You should: 1. Rename the database as MGMT2006_G# , where G# is your group number. 2. Create relationships between pairs of tables and enforce referential integrity. 3. Add TWO new Customers and associate them with a Service. 4. Also add TEN new Calls along with their information for any ten customers. Be sure to include calls for your two additional customers. 5. Create the following queries: a. List the names of customers whose status is disconnected. Name this query Q1 – NOTCONNECTED. b. What is the total duration of calls, pre-paid and post-paid for customers with data-plans and for customers without data-plans? Round the duration to a fixed number with no decimal places. Sort in descending order by duration. Name this query Q2 – CallDuration. c. For each customer who has a post-paid service, show how many of these customers have opted to have their bills emailed compared to those who have theirs by postal mail. Name this query Q3- PPBills. d. For airtime minutes only, calculate the total amount of tax collected from customers for the month. Name this query Q4-TotalAirtimeTax. e. The company has been informed that the mobile tax has been increased to 20%. Calculate how much additional tax, airtime minutes only, would have been collected for the month. Name this query Q5 – AddAirTimeTax
