Database Design and Development for CQI (Central Queensland Insurance)

Running head: DATABASE DESIGN AND DEVELOPMENT
Database Design and Development
Assignment 1: CQI (Central Queensland Insurance)
Name of Student
Name of the University
Author Note

DATABASE DESIGN AND DEVELOPMENT
ER Diagram
Figure 1: ER Diagram (CQ Insurance)
(Source: Created by Author)

DATABASE DESIGN AND DEVELOPMENT
Assumptions
Following assumptions have been assumed for this database design:
 The customer will have to register for the registration of the property, he or she owns and
they will have to provide personal information
 Individuals can own more than one property and each property will be recognized by
customer ID
 The customer will have to contact assessor for the claim and after evaluation only, the
customer could get his or her claim
 Price will be variable for different types of properties based on the initial value or current
market value
 Registration duration will be for an year, not more than that nor less than that value
 Properties details and value will be incorporated within the registration policy
 The Assessor will evaluate the policy claim, the claim failing the date of validity for the
claim will be considered as an invalid claim, and customer will be responded through a
rejection letter
 The properties would be owned by the owners and the items of the properties are stored
in a single table in the database and the valuation of the properties are to be done
according to the location of the property.
 The policy claims and the policy enrollment are stored in different entities in the
database. The policy claims is derived from the policy enrollment table