Question

3. b) Construct an appropriate conceptual Entity Relationship Diagram (ERD) for the requirements specified below. The Chen notation should be used to create the diagram. An insurance company has customers and offers products. When a customer takes out insurance they buy a policy. The minimum amount of information on the policy is the type of insurance taken out, the annual premium and the full name of the insured. A so called insured person does not necessarily have to be a client of this particular insurance. Damage claims are also recorded. Damage claims record the date and are made in relation to certain policies.

Answer 1

Answer:

The business pattern can be modeled by using entities that are found in the Claim (Claim, Elementary Claim, Claim-Agreement Rlship) and Agreement (Agreement, Financial Services Agreement, Financial services agreement component, Top level financial services agreement, Insurance policy) packages of the Business Data Model as illustrated in the ERD example.

Figure 1. ERD example for Relating a claim to an insurance policy, using the Agreement and Claim packages in BDM

eement riship Agreement Financial services agreement Financial services agreement c Top level tinancial services agreement Acme insurance policy --4- >。 GE edam benefit request → Coverage Insurance policy Elementary clam Property Claim Damage coverage -> Liability coverage Public liability Property Damage

Claims

• Claim - the claim entity is an anchor entity in the claims area that represents the demand for money, services, or goods from one party to another party under terms and conditions that are defined in a financial services agreement. In this case, a commercial fire claim is recorded.
• Elementary Claim - an entity that is a subtype of Claim that represents the smallest unit of a claim and is the bottom level of the claim decomposition that corresponds to the coverages in the insurance policy. In this scenario, this captures the property damage claim record.

Agreement

An agreement represents a mutual understanding between two or more parties, each committing to the fulfillment of one or more obligations.

Financial Services Agreement

The Financial Services Agreements entity represents the agreements between financial services providers and their customers.

Insurance Policy

The insurance policy entity is a subtype of a Financial Services Agreement where the owner of the agreement is usually a policyholder, and the agreement specifies the obligations of the insurer to pay benefits and of the premium payer to pay premiums.

Coverage Component

The Coverage Component entity is an agreement component that details the circumstances under which a benefit (money or services) will be paid. For example, in case of fire, benefits will be payable to the policyholder.

Claim to Agreement Relationship

Recording a claim against a claim – you can record the relationship between a claim and policy.