COIT20247 Database Design and Development Implementation Report

Studfd
COIT20247 Database Design and
Development (T12018)
May 20
Student ID:
Module Tutor:

S
Implementation Report
Introduction
The report is showing everything that is developed in the CQI database. Al queries
with query results and database report are shown in the report very clearly. All
implemented features like normalization rules; functional dependencies etc. are also
being mentioned in the report.
Normalization
ER Diagram Mapping
2 | P a g e

Relational Database
Person (FilddPersonID, FilddPersonName, FilddStreet, FilddCity, FilddPostcode,
FilddPersonType)
Assessor (FilddPersonID, FilddQualificationName, FilddDateQualified)
Foreign Key (FilddPersonID) References Person
Property (FilddPropertyID, FilddStreet, FilddCity, FilddPostcode, FilddPersonID)
Foreign Key (FilddPersonID) References Person
Policy (FilddPolicyID, FilddEffectiveFromDate, FilddPremiumAmount,
FilddPaidDate, FilddIsHomeBuildingPolicy, FilddIsHomeContentsPolicy,
FilddTotalPolicyAmount, FilddPropertyID)
Foreign Key (FilddPropertyID) References Property
Home_Building (FilddPolicyID, FilddHouseType, FilddYearBuilt,
FilddIsAlarmFitted, FilddHasWindowsLocks, FilddInsuredAmount,
FilddBuildingPremiumAmount)
Foreign Key (FilddPolicyID) References Policy
Home_Content (FilddPolicyID, FilddContentPremiumAmount)
Foreign Key (FilddPolicyID) References Policy
Content_Item (FilddItemID, FilddItemName, FilddManufacturer, FilddModel,
FilddPurchasePrice, FilddQuantity, FilddClaimedStatus, FilddPolicyID)
Foreign Key (FilddPolicyID) References Policy
Claim (FilddClaimID, FilddLodgedDate, FilddStatus, FilddPolicyID, FilddPersonID)
Foreign Key (FilddPersonID) References Person
Settled_Claim (FilddClaimID, FilddSettledDate, FilddAmountSettled)
Foreign Key (FilddClaimID) References Claim
Rejected_Claim (FilddClaimID, FilddRejectedDate, FilddRejectedReason)
Foreign Key (FilddClaimID) References Claim
3 | P a g e