Answer
The answer and procedures of the exercise are attached in the following image.
Explanation
Please consider the data provided by the exercise. If you have any question please write me back. All the exercises are solved in a single sheet with the formulas indications.
Answer:
No, the cost of the annual premium for 10 years was less than the accident claims
Explanation:
Since in the question it is mentioned that the annual premium is $1,200, $200,000 is the bodily injury coverage and $100,000 should be the property damage coverage
Also the $40,000 and $20,000 represent the medical cost and the car damage
So here the cost should not outweight the benefit of the transferring the risk as the annual premium cost for ten years should be lower than the accident claims
Answer:
Queries can perform many different functions in a database. Their most common function is to retrieve specific data from the tables. The data you want to see is usually spread across several tables, and queries allow you to view it in a single data sheet.