Database Normalization and Implementation Report for COIT20247

COIT20247 Database Design and
Development (T1 2018)
Assignment 2
Student ID:
Student Name:
Tutor Name:
Date:

Implementation Report
Introduction
Complete report is demonstrating the database normalization concept in the RDBMS.
Normalization is the basic concept in RDBMS to make the accurate database
management system.
Normalization
ER Diagram Mapping
Person (FiilddPersonID, FiilddPersonName, FiilddStreet, FiilddCity, FiilddPostcode,
FiilddPersonType)
Assessor (FiilddPersonID, FiilddQualificationName, FiilddDateQualified)
Foreign Key (FiilddPersonID) References Person
Property (FiilddPropertyID, FiilddStreet, FiilddCity, FiilddPostcode, FiilddPersonID)
Foreign Key (FiilddPersonID) References Person
Policy (FiilddPolicyID, FiilddEffectiveFromDate, FiilddPremiumAmount,
FiilddPaidDate, FiilddIsHomeBuildingPolicy, FiilddIsHomeContentsPolicy,
FiilddTotalPolicyAmount, FiilddPropertyID)
Foreign Key (FiilddPropertyID) References Property
Home_Building (FiilddPolicyID, FiilddHouseType, FiilddYearBuilt,
FiilddIsAlarmFitted, FiilddHasWindowsLocks, FiilddInsuredAmount,
FiilddBuildingPremiumAmount)
Foreign Key (FiilddPolicyID) References Policy
Home_Content (FiilddPolicyID, FiilddContentPremiumAmount)
Foreign Key (FiilddPolicyID) References Policy
Content_Item (FiilddItemID, FiilddItemName, FiilddManufacturer, FiilddModel,
FiilddPurchasePrice, FiilddQuantity, FiilddClaimedStatus, FiilddPolicyID)
Foreign Key (FiilddPolicyID) References Policy
2 | P a g e

Claim (FiilddClaimID, FiilddLodgedDate, FiilddStatus, FiilddPolicyID,
FiilddPersonID)
Foreign Key (FiilddPersonID) References Person
Settled_Claim (FiilddClaimID, FiilddSettledDate, FiilddAmountSettled)
Foreign Key (FiilddClaimID) References Claim
Rejected_Claim (FiilddClaimID, FiilddRejectedDate, FiilddRejectedReason)
Foreign Key (FiilddClaimID) References Claim
Items_Claimed (FiilddClaimID, FiilddItemID, FiilddItemName, FiilddQuantity,
FiilddItemStatus)
Foreign Key (FiilddClaimID) References Claim
Foreign Key (FiilddItemID) References Content_Item
Assessment_Report (FiilddReportID, FiilddReportDate,
FiilddInitialRecommendation, FiilddReportType, FiilddClaimID, FiilddPersonID)
Foreign Key (FiilddClaimID) References Claim
Foreign Key (FiilddPersonID) References Assessor
Final_Assessment_Report (FiilddReportID, FiilddFinalAssessmentDate,
FiilddTotalAmount, FiilddCostReportMemo)
Foreign Key (FiilddReportID) References Assessment_Report
3 | P a g e