Solved

Salespeople for the Coverall Insurance Company Meet with Customers and Try

Question 32

Essay

Salespeople for the Coverall Insurance Company meet with customers and try to sell them one or more of the company's five insurance policies. If they are successful in their sales efforts they obtain a signed insurance policy from the customer and the initial check for the first premium. These are sent to the company's headquarters for processing. The contract is kept on file, and the check is given to the cashier for processing into one of the company's cash accounts. Policy payment reminders are mailed to the customer (monthly or quarterly, depending on the terms of the policy). The customer sends subsequent policy payments to the cashier for processing.
Below is a partial REA business process level conceptual model for Coverall. Convert this conceptual model into a logical model consisting of a set of minimal relational database tables. Underline primary keys and write FK next to foreign keys.
Salespeople for the Coverall Insurance Company meet with customers and try to sell them one or more of the company's five insurance policies. If they are successful in their sales efforts they obtain a signed insurance policy from the customer and the initial check for the first premium. These are sent to the company's headquarters for processing. The contract is kept on file, and the check is given to the cashier for processing into one of the company's cash accounts. Policy payment reminders are mailed to the customer (monthly or quarterly, depending on the terms of the policy). The customer sends subsequent policy payments to the cashier for processing. Below is a partial REA business process level conceptual model for Coverall. Convert this conceptual model into a logical model consisting of a set of minimal relational database tables. Underline primary keys and write FK next to foreign keys.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions