Coit20247 The Relational Database Implementation Assessment Answer
Answer:
1.a) Normalized from of the ERD
Customers (CustomerID, Name, Address, Email)
Properties (PropertyID, Adress, Details, CustomerID)
Policy (PolicyNumber, PolicyDate, Type, PropertyID)
HomeBuildingPolicy (PolicyNumber, Details, StartDate, Duration, EndDate)
HomeContentPolicy (PolicyNumber, Details, StartDate, Duration, EndDate)
Content_Item (ItemID, Itemname, Manufacturer, Model, Purchas Price, Quentity, PolicyNumber)
Assessor (AssessorId, Name, Address, Qualification, DateofQualification)
Claim (ClaimId, claimsDate, AssessorId, PolicyNumber, CustomerNumber, ReportID, ClaimStatusID)
Claim_Status (CalimStatusID, Name)
Settled_Claim (CalimStatusID, SettledDate, AmountSettled, PolicyNumber)
Rejected_Claim (CalimStatusID, RejectedDate, Reason, PolicyNumber)
Report (ReportID, ReportDate, InitialRecomendation, FinalAssesmentDate, TotalCost)
b) Normalization correctly listed for two of the relations
Functional Dependency
CalimStatusID à Name
ReportID à ReportDate, InitialRecomendation, FinalAssesmentDate, TotalCost
Normalization
Claim_Status (CalimStatusID, Name)
In the above entity has one primary key and another one is a candidate key. The candidate key is depended on the primary key. But the primary is nor depended on the candidate key. Therefore, no functional dependency is not present in this table. This table meets 1st 2nd and 3rd normalization rules.
Report (ReportID, ReportDate, InitialRecomendation, FinalAssesmentDate, TotalCost)
The primary key is ReportID which identify the report that is made by an assessor. In a same day many report can be made. Also the initial recommendation cab be same for two or more reports. This means that the ReportID is functionally determines on every other attributes. Therefore, any type of dependency is not present in this table. Hence this is in 2nd normal form.
Apart from the above demonstration, the total cost and final assessment date can be same for two or more report. Therefore, no transitive dependency is not present in this table. So its meet the 3rd normalization rule.
Implementation report
I am facing problem in designing the report for all rejected claims. First I was going to design the report manually. I was unable to include all the report related filed. But then I research on internet about the report design in ms access. The I decided to create a query a query for find out all rejected claims. Then I used report design wizard and use this query to implement this report and at last I was successfully creating the repot for all rejected claims.
Buy Coit20247 The Relational Database Implementation Assessment Answers Online
Talk to our expert to get the help with Coit20247 The Relational Database Implementation Assessment Answers from Assignment Hippo Experts to complete your assessment on time and boost your grades now
The main aim/motive of the finance assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignment help Australia. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at www.assignmenthippo.com are so much skilled, capable, talented, and experienced in their field and use our best and free Citation Generator and cite your writing assignments, so, for this, they can effectively write the best economics assignment help services.
Get Online Support for Coit20247 The Relational Database Implementation Assessment Answer Assignment Help Online
Want to order fresh copy of the Sample Coit20247 The Relational Database Implementation Assessment Answers? online or do you need the old solutions for Sample Coit20247 The Relational Database Implementation Assessment Answer, contact our customer support or talk to us to get the answers of it.
Assignment Help Australia
Want to order fresh copy of the Coit20247 The Relational Database Implementation Assessment Answers? online or do you need the old solutions for Sample Coit20247 The Relational Database Implementation Assessment Answer, contact our customer support or talk to us to get the answers of it.
