logo

COIT20247 - Database Design and Development

8 Pages824 Words70 Views
   

Added on  2021-05-30

COIT20247 - Database Design and Development

   Added on 2021-05-30

ShareRelated Documents
COIT20247 Database Design and Development (T12018)Assignment 2 Student ID:Module Tutor:
COIT20247 - Database Design and Development_1
Implementation Report IntroductionThe report is portraying the database design and implementation of the complete database of CQI. All important CQI features are being shown in the report like database report, queries etc. NormalizationER Diagram Mapping Person (FlPersonID, FlPersonName, FlStreet, FlCity, FlPostcode, FlPersonType)Assessor (FlPersonID, FlQualificationName, FlDateQualified)Foreign Key (FlPersonID) References PersonProperty (FlPropertyID, FlStreet, FlCity, FlPostcode, FlPersonID)Foreign Key (FlPersonID) References PersonPolicy (FlPolicyID, FlEffectiveFromDate, FlPremiumAmount, FlPaidDate, FlIsHomeBuildingPolicy, FlIsHomeContentsPolicy, FlTotalPolicyAmount, FlPropertyID) Foreign Key (FlPropertyID) References Property
COIT20247 - Database Design and Development_2
Home_Building (FlPolicyID, FlHouseType, FlYearBuilt, FlIsAlarmFitted, FlHasWindowsLocks, FlInsuredAmount, FlBuildingPremiumAmount)Foreign Key (FlPolicyID) References PolicyHome_Content (FlPolicyID, FlContentPremiumAmount)Foreign Key (FlPolicyID) References PolicyContent_Item (FlItemID, FlItemName, FlManufacturer, FlModel, FlPurchasePrice, FlQuantity, FlClaimedStatus, FlPolicyID)Foreign Key (FlPolicyID) References PolicyClaim (FlClaimID, FlLodgedDate, FlStatus, FlPolicyID, FlPersonID)Foreign Key (FlPersonID) References PersonSettled_Claim (FlClaimID, FlSettledDate, FlAmountSettled)Foreign Key (FlClaimID) References ClaimRejected_Claim (FlClaimID, FlRejectedDate, FlRejectedReason)Foreign Key (FlClaimID) References ClaimItems_Claimed (FlClaimID, FlItemID, FlItemName, FlQuantity, FlItemStatus)Foreign Key (FlClaimID) References ClaimForeign Key (FlItemID) References Content_ItemAssessment_Report (FlReportID, FlReportDate, FlInitialRecommendation, FlReportType, FlClaimID, FlPersonID)Foreign Key (FlClaimID) References ClaimForeign Key (FlPersonID) References AssessorFinal_Assessment_Report (FlReportID, FlFinalAssessmentDate, FlTotalAmount, FlCostReportMemo)Foreign Key (FlReportID) References Assessment_Report
COIT20247 - Database Design and Development_3

End of preview

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

Related Documents
COIT20247 Database Design and Development - Doc
|8
|859
|53

COIT20247 Database Design and Development - PDF
|8
|767
|87

COIT20247 Database Design and Development (T12018) - Assignment 2 Implementation Report
|8
|769
|319

COIT20247 Database Design & Development
|7
|643
|52

Normalized CQI Database Design and Development (T12018) Assessment Item 2 - Assignment 2 Student ID: Tutor: 2018 5/17/2018
|8
|769
|200

COIT20247 Database Design and Development : Doc
|9
|868
|57