logo

COIT20247 Database Design and Development (T12018) - Assignment 2 Implementation Report

Normalization of ERD and analysis of functional dependencies in a database design.

8 Pages769 Words319 Views
   

Added on  2023-06-12

About This Document

This report covers the implementation of the database design for CQI, including normalization, ER diagram mapping, functional dependency, SQL queries, and learning features. The database is implemented in third normal form and all tables have separate data, primary keys, and fields depending upon the primary key only. The report also includes complex features such as sub queries and database reports.

COIT20247 Database Design and Development (T12018) - Assignment 2 Implementation Report

Normalization of ERD and analysis of functional dependencies in a database design.

   Added on 2023-06-12

ShareRelated Documents
COIT20247 Database Design and Development (T12018)
Assessment Item 2 – Assignment 2
Student ID:
Module Tutor:
COIT20247 Database Design and Development (T12018) - Assignment 2 Implementation Report_1
Implementation Report
Introduction
The report is totally based upon the database design and implementation. The database for CQI is
implemented in the assignment and the report is giving complete knowledge about it.
Normalization
ER Diagram Mapping
Person (FlddPersonID, FlddPersonName, FlddStreet, FlddCity, FlddPostcode, FlddPersonType)
Assessor (FlddPersonID, FlddQualificationName, FlddDateQualified)
Foreign Key (FlddPersonID) References Person
Property (FlddPropertyID, FlddStreet, FlddCity, FlddPostcode, FlddPersonID)
Foreign Key (FlddPersonID) References Person
Policy (FlddPolicyID, FlddEffectiveFromDate, FlddPremiumAmount, FlddPaidDate,
FlddIsHomeBuildingPolicy, FlddIsHomeContentsPolicy, FlddTotalPolicyAmount,
FlddPropertyID)
COIT20247 Database Design and Development (T12018) - Assignment 2 Implementation Report_2
Foreign Key (FlddPropertyID) References Property
Home_Building (FlddPolicyID, FlddHouseType, FlddYearBuilt, FlddIsAlarmFitted,
FlddHasWindowsLocks, FlddInsuredAmount, FlddBuildingPremiumAmount)
Foreign Key (FlddPolicyID) References Policy
Home_Content (FlddPolicyID, FlddContentPremiumAmount)
Foreign Key (FlddPolicyID) References Policy
Content_Item (FlddItemID, FlddItemName, FlddManufacturer, FlddModel, FlddPurchasePrice,
FlddQuantity, FlddClaimedStatus, FlddPolicyID)
Foreign Key (FlddPolicyID) References Policy
Claim (FlddClaimID, FlddLodgedDate, FlddStatus, FlddPolicyID, FlddPersonID)
Foreign Key (FlddPersonID) References Person
Settled_Claim (FlddClaimID, FlddSettledDate, FlddAmountSettled)
Foreign Key (FlddClaimID) References Claim
Rejected_Claim (FlddClaimID, FlddRejectedDate, FlddRejectedReason)
Foreign Key (FlddClaimID) References Claim
Items_Claimed (FlddClaimID, FlddItemID, FlddItemName, FlddQuantity, FlddItemStatus)
Foreign Key (FlddClaimID) References Claim
Foreign Key (FlddItemID) References Content_Item
Assessment_Report (FlddReportID, FlddReportDate, FlddInitialRecommendation,
FlddReportType, FlddClaimID, FlddPersonID)
Foreign Key (FlddClaimID) References Claim
Foreign Key (FlddPersonID) References Assessor
Final_Assessment_Report (FlddReportID, FlddFinalAssessmentDate, FlddTotalAmount,
FlddCostReportMemo)
Foreign Key (FlddReportID) References Assessment_Report
COIT20247 Database Design and Development (T12018) - Assignment 2 Implementation Report_3

End of preview

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

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

COIT20247 - Database Design and Development
|8
|824
|70

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

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

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