CQ Insurance Database Diagram

Running head: CQ INSURANCE DATABASE DIAGRAM
CQ Insurance Database Diagram
Name of Student-
Name of University-
Author’s Note-

1CQ INSURANCE DATABASE DIAGRAM
1. ER Diagram
Figure 1: Data Relationship Diagram of CQI
2. Business Rules and Assumptions
Business Rules taken for the ERD:
Entities Relationship
agents_details - customer_agent One - one relationship
agents_details - customer_details One - many relationship
customer_details - property_details One - many relationship

2CQ INSURANCE DATABASE DIAGRAM
customer_details - accidents_record One - many relationship
customer_details - policy_details One - many relationship
customer_details - payment_details One - many relationship
property_details - policy_details One - one relationship
accidents_record - policy_details One - one relationship
policy_details - payment_details One - one relationship
Assumptions made for the ERD:
All total there are seven entities in the ER Diagram. The assumptions that are taken for
the ERD are:
agents_details entity: agent_ID is assumed as a primary key.
The customer_agent has a connection with agents_details entity, which has agent_ID
and customer_ID as foreign key. The relation between agents_details and the customer_agent
has a one to one relationship. The customer_agent is a subtype entity.
In customer_details entity, customer_ID is assumed as the primary key and policy_ID,
agent_ID, and accident_ID is assumed as a foreign key. The customer_details is a super entity as
it has relationship with many sub entities.
In accidents_record entity, the accident_ID is primary key and customer_ID is assumed
as a foreign key.