logo

Database Implementation - PDF

5 Pages864 Words134 Views
   

Added on  2021-06-17

Database Implementation - PDF

   Added on 2021-06-17

ShareRelated Documents
Running head: DATABASE IMPLEMEMTATIONDatabase ImplementationName of the Student:Name of the University:Author Note
Database Implementation - PDF_1
1DATABASE IMPLEMEMTATION NormalizationSet of RelationsPolicies (PolicyID (primary key), CustomerID (foreign key) EffectFrom, PremiumAmount,PaidDate, PolicyType, TotalPolicyAmount)Assessor (AssessorID (primary key), AssessorName, Qualification, QualificationDate)Claims (ClaimID (primary key), PolicyID (foreign key), LoggedDate, Status, ItemID (foreignkey), Actiondate, AmountSettled, RejectReason)Customers (CustomerId (primary key), CustomerName, Address)Property (PropertyID (primary key), CustomerID (foreign key), Address, Postcode)Items (ItemID (primary key), PropertyID (forgein key), ItemName, Price)Assessment Report (ReportID (primary key), ClaimID (foreign key) ReportDate, AssessorID(foreign key), ReportType)Functional DependenciesAttributeDependenciesPolicyIDCustomerID, EffectFrom, PremiumAmount, PaidDate, PolicyType,TotalPolicyAmountAssesorIDAssessorName, Qualification, QualificationDateClaimIDPolicyID, LoggedDate, Status, ItemsID, Actiondate, AmountSettled,RejectReasonCustomerIDCustomerName, AddressPropetyIDCustomerID, Address, PostcodeItemIDItemName, PropertyID, PriceReportIDClaimID, ReportDate, AssessorID, ReportType
Database Implementation - PDF_2

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

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

ERD Normalization Relational Schema
|11
|1761
|56

Database implementation Assignment
|6
|1153
|103