Database Design and Development: A Case Study of CQ Insurance (CQI)

Running head: DATABASE DESIGN AND DEVELOPMENT
Database design and development: A Case Study of CQ Insurance (CQI)
Student Name:
University Name:

1DATABASE DESIGN AND DEVELOPMENT
Table of Contents
1. Entity Relationship (ER) diagram...............................................................................................2
2. Assumptions and Business rules..................................................................................................2
2.1 Assumptions..........................................................................................................................2
2.2 Business Rules.......................................................................................................................3
3. Logical Design.............................................................................................................................3
Bibliography....................................................................................................................................5

2DATABASE DESIGN AND DEVELOPMENT
1. Entity Relationship (ER) diagram
Figure 1: Entity Relationship (ER) diagram of CQ Insurance (CQI) case study
(Source: Created by Author)
2. Assumptions and Business rules
2.1 Assumptions
The ERD in context to the case of CQ Insurance (CQI) has been designed by making the
assumptions as listed below:
 Several properties may be owned by an individual customer and a single property
may consist of various contents.