COIT20247 Database Design and Development Assignment 2 Implementation Report

COIT20247 Database Design and Development (T1
2018)
Assignment 2
Student ID:
Module Tutor:
5/21/2018

Implementation Report
Introduction
The report is explaining in brief all the important features developed in the
assignment. Normalization concept is the base of the assignment and the report is
completely describing the normalization process.
Normalization
ER Diagram Mapping
Person (FFPersonID, FFPersonName, FFStreet, FFCity, FFPostcode, FFPersonType)
Assessor (FFPersonID, FFQualificationName, FFDateQualified)
Foreign Key (FFPersonID) References Person
Property (FFPropertyID, FFStreet, FFCity, FFPostcode, FFPersonID)
Foreign Key (FFPersonID) References Person
Policy (FFPolicyID, FFEffectiveFromDate, FFPremiumAmount, FFPaidDate,
FFIsHomeBuildingPolicy, FFIsHomeContentsPolicy, FFTotalPolicyAmount,
FFPropertyID)
Foreign Key (FFPropertyID) References Property
Home_Building (FFPolicyID, FFHouseType, FFYearBuilt, FFIsAlarmFitted,
FFHasWindowsLocks, FFInsuredAmount, FFBuildingPremiumAmount)
Foreign Key (FFPolicyID) References Policy
Home_Content (FFPolicyID, FFContentPremiumAmount)
Foreign Key (FFPolicyID) References Policy
Content_Item (FFItemID, FFItemName, FFManufacturer, FFModel,
FFPurchasePrice, FFQuantity, FFClaimedStatus, FFPolicyID)
Foreign Key (FFPolicyID) References Policy
Claim (FFClaimID, FFLodgedDate, FFStatus, FFPolicyID, FFPersonID)
Foreign Key (FFPersonID) References Person
2 | P a g e

Settled_Claim (FFClaimID, FFSettledDate, FFAmountSettled)
Foreign Key (FFClaimID) References Claim
Rejected_Claim (FFClaimID, FFRejectedDate, FFRejectedReason)
Foreign Key (FFClaimID) References Claim
Items_Claimed (FFClaimID, FFItemID, FFItemName, FFQuantity, FFItemStatus)
Foreign Key (FFClaimID) References Claim
Foreign Key (FFItemID) References Content_Item
Assessment_Report (FFReportID, FFReportDate, FFInitialRecommendation,
FFReportType, FFClaimID, FFPersonID)
Foreign Key (FFClaimID) References Claim
Foreign Key (FFPersonID) References Assessor
Final_Assessment_Report (FFReportID, FFFinalAssessmentDate, FFTotalAmount,
FFCostReportMemo)
Foreign Key (FFReportID) References Assessment_Report
3 | P a g e