logo

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

   

Added on  2021-06-17

8 Pages769 Words200 Views
 | 
 | 
 | 
Assessment Item 2 – Assignment 2Student ID:Tutor:
Normalized CQI Database Design and Development (T12018) Assessment Item 2 - Assignment 2 Student ID: Tutor: 2018 5/17/2018_1

Implementation Report IntroductionThe report is giving complete overview about CQI database that is implemented as normalized database in MS Access. The CQI database is containing queries, reports etc. that are very helpful for management.NormalizationER Diagram Mapping Person (FielldPersonID, FielldPersonName, FielldStreet, FielldCity, FielldPostcode, FielldPersonType)Assessor (FielldPersonID, FielldQualificationName, FielldDateQualified)Foreign Key (FielldPersonID) References PersonProperty (FielldPropertyID, FielldStreet, FielldCity, FielldPostcode, FielldPersonID)Foreign Key (FielldPersonID) References PersonPolicy (FielldPolicyID, FielldEffectiveFromDate, FielldPremiumAmount, FielldPaidDate, FielldIsHomeBuildingPolicy, FielldIsHomeContentsPolicy, FielldTotalPolicyAmount, FielldPropertyID) Foreign Key (FielldPropertyID) References Property2 | P a g e
Normalized CQI Database Design and Development (T12018) Assessment Item 2 - Assignment 2 Student ID: Tutor: 2018 5/17/2018_2

Home_Building (FielldPolicyID, FielldHouseType, FielldYearBuilt, FielldIsAlarmFitted, FielldHasWindowsLocks, FielldInsuredAmount, FielldBuildingPremiumAmount)Foreign Key (FielldPolicyID) References PolicyHome_Content (FielldPolicyID, FielldContentPremiumAmount)Foreign Key (FielldPolicyID) References PolicyContent_Item (FielldItemID, FielldItemName, FielldManufacturer, FielldModel, FielldPurchasePrice, FielldQuantity, FielldClaimedStatus, FielldPolicyID)Foreign Key (FielldPolicyID) References PolicyClaim (FielldClaimID, FielldLodgedDate, FielldStatus, FielldPolicyID, FielldPersonID)Foreign Key (FielldPersonID) References PersonSettled_Claim (FielldClaimID, FielldSettledDate, FielldAmountSettled)Foreign Key (FielldClaimID) References ClaimRejected_Claim (FielldClaimID, FielldRejectedDate, FielldRejectedReason)Foreign Key (FielldClaimID) References ClaimItems_Claimed (FielldClaimID, FielldItemID, FielldItemName, FielldQuantity, FielldItemStatus)Foreign Key (FielldClaimID) References ClaimForeign Key (FielldItemID) References Content_ItemAssessment_Report (FielldReportID, FielldReportDate, FielldInitialRecommendation,FielldReportType, FielldClaimID, FielldPersonID)Foreign Key (FielldClaimID) References ClaimForeign Key (FielldPersonID) References AssessorFinal_Assessment_Report (FielldReportID, FielldFinalAssessmentDate, FielldTotalAmount, FielldCostReportMemo)Foreign Key (FielldReportID) References Assessment_Report3 | P a g e
Normalized CQI Database Design and Development (T12018) Assessment Item 2 - Assignment 2 Student ID: Tutor: 2018 5/17/2018_3

End of preview

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

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

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

Database Normalization and Implementation Report for COIT20247
|8
|766
|500

COIT20247 Database Design and Development Implementation Report
|9
|778
|463

COIT20247 Database Design and Development Assignment 2 Implementation Report
|8
|735
|329

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