logo

Database Development Management

7 Pages917 Words144 Views
   

Added on  2021-04-24

Database Development Management

   Added on 2021-04-24

ShareRelated Documents
Running head: DATABASE DEVELOPMENT MANAGEMENTAssessment item 1—Assignment 1Name of the StudentStudent number Unit numberName of the UniversityAuthor’s Note
Database Development Management_1
1DATABASE DEVELOPMENT MANAGEMENT Table of Contents1. ER Diagram.....................................................................................................................22. Assumptions and the Business Rules..............................................................................33. Development of the Logical Design................................................................................5Bibliography........................................................................................................................7
Database Development Management_2
2DATABASE DEVELOPMENT MANAGEMENT 1. ER DiagramCustomerHome ItemPropertiesEnrolled PolicyClaimsPolicyAgentCustomer_IDPKCustomer_NameStreetItem_IDPKDescriptionMarketValueProperty_IDPKDetailsLoactionSuburbStatePostCodeEmailCustomer_IDFKProperty_IDFKPolicy_IDPKPolicy_NumberFKItem_IDFKInsurance_Claim_IDPKPolicy_IDFKCustomer_IDFKPolicy_NumberPKDurationStrat_DateAgent_IDPKNameEmailContact NumebrSalaryAgent_IDFKDate_ClaimedProperty_IDFKCustomer_IDFKDate of Policy enrollmentEnd_dateDetailsOwnsEnrolled withClaimsRealized byIncludesEnrolledThe weak entity is shown using the dashed lines and the multivalued attributes are shownin red colour. The attributes of the tables are given below:EntityAttributesCustomer Customer_ID (primary key),Customer_Name, Street, Suburb, State,postcode, EmailAgent Agent_ID (Primary key), Name, Email,Contact_Number, SalaryPropertiesProperty_ID (Primary key), Customer_ID(Foreign key), Details, LocationClaimsInsurance_Claim_ID (Primary key),Policy_ID (Foreign key), Customer_ID(Foreign key), Agent_ID (Foreign key),date_claimedHome_ItemItem_ID (primary key), Property_ID (Foreignkey), Description, Market_ValueEnrolled_policyPolicy_ID (primary key), Customer_ID
Database Development Management_3

End of preview

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

Related Documents
CQ Insurance Database Diagram
|6
|635
|103

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

Database Design and Development
|7
|1063
|493

Database implementation Assignment
|6
|1153
|103

Database Design of CQ Insurance
|6
|625
|494

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