Question
Answered step-by-step

Image transcription text

The scenario is for a small life insurance agency and their need to keep track of clients, agents, insurers, and quotations. 1) A Client is a customer, potential customer, or contact ofthe agency. We need to assign each client a number and save their last name, first name, birth date. gender, telephone number, email address, and the agent who brought the client into the agency. Jf a client is a "walk in" they are assigned to the first available agent. All clients must have one primary agent. 2) An agent is a licensed individual with the state. Each agent has a nationally unique license number, last name, first name, telephone number, and email address. An agent must be the primary agent for at least one client but may not be primary for more than 500 clients. An agent must also be part of at least one quotation and may share in an unlimited number of quotes. 3) The agency represents (does business with) many insurance companies (insurers). We will need to track each insurerwith an agency assigned alphanumeric code, the insurer's name, telephone number, fax machine number, and email address. There may be insurers in the database that have no quotes but an insurer may give an unlimited number ofquotat'ions. 4) When a client requests information about a policy a quotation is created. A quotation has a file number, the client number, date of the quotation, insurance company the quotation is requested from, and the final policy number of the client accepts the quote and purchases the policy. A quotation may be for only one client and insurer. A client may have an unlimited number of quotes. 5) A quotation may be written by 1 to 5 agents. if the policy is finally purchased commissions will be split among the agents as they see fit, as long as it totals 100%. This sharing percentage must be decided at quotation time. Using the business rules above, complete the table by choosing the correct connectivity for each ofthe relationships:

... Show more


client

insurer

agent

agent

Answer & Explanation
Verified Solved by verified expert
<p>ctum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, c</p> Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer

iscing

iscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur

sus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lec

gue

ultrit

risus ante, dapibus a molestie consequat, ultrice dui lectu

gue

at

ng elit. Nam lacinia pulvinar tort

gue

tipsum dolors ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac,

Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, cons

ultrit

at, ultrices ac magna. Fusce dui lectus, congue vce dui lectu

gue

u

, ultrices ac magna. Fusce dui l

or nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie c

ultrit

ongue vel laoreet ac, dictum vitae odio. Donecce dui lectu

gue

s

ur laoreet. Nam risus ante, dapibus

ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet.

sum dolor sit amet, consectetur adipiscing elit. Nam

ultrit

trices ac magna. Fusce dui lectus, congue vel laorce dui lectu

Step-by-step explanation

onec aliquet.congue vel laoreet ac,

ec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vita