Running head: DATABASE DESIGN AND DEVELOPMENTDatabase Design and DevelopmentCQ Insurance CompanyName of the StudentName of the UniversityAuthor Note
DATABASE DESIGN AND DEVELOPMENT2Table of ContentsER Diagram................................................................................................................................3Assumptions...............................................................................................................................5Business rules.............................................................................................................................5Logical Designs..........................................................................................................................7Logical Design...........................................................................................................................7Bibliography...............................................................................................................................9
Running head: DATABASE DESIGN AND DEVELOPMENTER DiagramPropertiesHome contentsCustomerPoliciesPolicy RegistrationInsurance AgentPolicy ClaimsProperty_IdPKLocationDetailsCoontent_IDPKDetailsMarket_ValueProperty_IdFKCustomer IDPKCustomer_NameCustomer_AddressCustomer_EmailCustomer_NumberFKPolicy_NumberPKPolicy_DetailsRegistration_dateVaidity_DurationPolicy_IdPKPolicdy_NumberFKItem_IdFKPolicy_DateEmployee_IdPKAgent_NameNet_SalaryProperty_IdFKCustomer_IdFKContact_DetailsAgent_MailClaim_IdPKPolicy_IdFKCustomer_IdFKAgent_IdFKclaim_DateIncludesMaturityEnrolled toEnrolled toEnrolled toDemandClaimsOwnsIncludesFigure 1: Entity relationship diagram of CQ Insurance CompanySource: (created by Author)
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Design and Development: PDFlg...
|7
|1003
|251
Entity Relationship Diagram - PDFlg...
|6
|884
|275
Database Development Managementlg...
|7
|917
|144
Database Design and Development: A Case Study of CQ Insurance (CQI)lg...
|6
|532
|375
Database Design and Development: A Case Study of CQ Insurance (CQI)lg...
|7
|1116
|134
Database Design and Development for CQI (Central Queensland Insurance)lg...