logo

Database Design and Development: PDF

7 Pages1003 Words251 Views
   

Added on  2021-04-24

Database Design and Development: PDF

   Added on 2021-04-24

ShareRelated Documents
Running head: DATABASE DESIGN AND DEVELOPMENTDatabase design and development: A Case Study of CQ Insurance (CQI)Student Name:University Name:
Database Design and Development: PDF_1
DATABASE DESIGN AND DEVELOPMENT1Table of Contents1. ER diagram for CQ Insurance.....................................................................................................22. Assumptions and Business rules..................................................................................................22.1 Assumptions..............................................................................................................................22.2 Business Rules...........................................................................................................................33. Logical Design.............................................................................................................................4References........................................................................................................................................6
Database Design and Development: PDF_2
DATABASE DESIGN AND DEVELOPMENT21. ER diagram for CQ InsurancePropertyHome ContentsCustomerPolicyPolicy EnrolmentAgentClaimsPropertyIDPKLocationDetailsContentsIDPKDescriptionMarketValuePropertyIDFKCustomerIDPKCustNameCustAddressCustEmailCustomerIDFKPolicyNoPKDetailsPolDateDurationEnrolmentIDPKPolicyNoFKPropertyIDFKPEnrolDateAgentIDPKAgntNameSalaryContentsIDFKCustomerIDFKContactNoAgntMailClaimsIDPKEnrolmentIDFKCustomerIDFKAgentIDFKClaimsDateFigure 1: ER diagram for CQ Insurance(Source: Created by Author)2. Assumptions and Business rules2.1 AssumptionsThe ERD (Entity Relationship Diagram) has been presented above according to the caseof CQ Insurance (CQI) that provides insurance policies for Home buildings as well as contents.
Database Design and Development: PDF_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Design and Development: A Case Study of CQ Insurance (CQI)
|7
|1116
|134

Database Design and Development: A Case Study of CQ Insurance (CQI)
|6
|532
|375

Entity Relationship Diagram - PDF
|6
|884
|275

Database Design And Development - Assignment
|9
|1151
|309

Database Design and Development for CQI (Central Queensland Insurance)
|6
|733
|114

Database Development Management
|7
|917
|144