Question: You are given a database containing the previously described tables to provide some results for MGMT Insurance Ltd. (That is, your CI will provide you

You are given a database containing the previously described tables to provide some results for MGMT Insurance Ltd. (That is, your CI will provide you with the database). You should: 1. Rename the database as MGMT2006_ 2. Create relationships between pairs of tables and enforce referential integrity. 3. Add THREE new CLIENTS where you, the student, must state your first and last names as one of the new clients. Associate these new clients with a company and a start date for the deductions. 4. Also add a new DEDUCTION for each of your new clients along with their information on deductions of two or more premiums. 5. Then add TWO new DEDUCTIONS for TWO existing clients. 6. Create the following queries: a. List the names of employees who have arranged for monthly premiums to be deducted by their employer Place 2 B. Name this query Q1 Place2B. b. How many employees have deductions for a retirement plan? Name this query Q2 Retirement. c. What is the average premium for a policy? Name this query Q3 AveragePremium. d. Produce the total payments received by each business on behalf of their employees. Name this query Q4 TotalByBusiness. e. Create a query that prompts you (the user) for your first/last name and produces your client number, your first and last names, the salary deduction along with the total premium. Also include a calculated field named Excess to subtract the total premium from your salary deduction. Name this query Q5 Client.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!