logo

COIT20247 Database Design and Development : Doc

   

Added on  2021-06-17

9 Pages868 Words57 Views
Assignment 2Student ID:Tutor:
COIT20247 Database Design and Development : Doc_1
Implementation Report IntroductionThe report is giving complete information about database normalization. It is showingcomplete normalization process through CQI database that is developed in MS Accessdatabase. It is showing all query results, database report, functional dependencies in between tables etc.NormalizationER Diagram Mapping 2 | P a g e
COIT20247 Database Design and Development : Doc_2
Logical DesignPerson (FielddPersonID, FielddPersonName, FielddStreet, FielddCity, FielddPostcode, FielddPersonType)Assessor (FielddPersonID, FielddQualificationName, FielddDateQualified)Foreign Key (FielddPersonID) References PersonProperty (FielddPropertyID, FielddStreet, FielddCity, FielddPostcode, FielddPersonID)Foreign Key (FielddPersonID) References PersonPolicy (FielddPolicyID, FielddEffectiveFromDate, FielddPremiumAmount, FielddPaidDate, FielddIsHomeBuildingPolicy, FielddIsHomeContentsPolicy, FielddTotalPolicyAmount, FielddPropertyID) Foreign Key (FielddPropertyID) References PropertyHome_Building (FielddPolicyID, FielddHouseType, FielddYearBuilt, FielddIsAlarmFitted, FielddHasWindowsLocks, FielddInsuredAmount, FielddBuildingPremiumAmount)Foreign Key (FielddPolicyID) References PolicyHome_Content (FielddPolicyID, FielddContentPremiumAmount)Foreign Key (FielddPolicyID) References PolicyContent_Item (FielddItemID, FielddItemName, FielddManufacturer, FielddModel, FielddPurchasePrice, FielddQuantity, FielddClaimedStatus, FielddPolicyID)Foreign Key (FielddPolicyID) References PolicyClaim (FielddClaimID, FielddLodgedDate, FielddStatus, FielddPolicyID, FielddPersonID)Foreign Key (FielddPersonID) References PersonSettled_Claim (FielddClaimID, FielddSettledDate, FielddAmountSettled)Foreign Key (FielddClaimID) References ClaimRejected_Claim (FielddClaimID, FielddRejectedDate, FielddRejectedReason)Foreign Key (FielddClaimID) References Claim3 | P a g e
COIT20247 Database Design and Development : Doc_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

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 Implementation Report
|9
|778
|463

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

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

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