logo

Database Design and Development - PDF

4 Pages802 Words88 Views
   

Added on  2021-06-14

Database Design and Development - PDF

   Added on 2021-06-14

ShareRelated Documents
Running head: DATABASE DESIGN AND DEVELOPMENTDatabase Design and DevelopmentStudent Name:University Name:
Database Design and Development - PDF_1
1DATABASE DESIGN AND DEVELOPMENTTwo relations with functional dependencies and demonstration of normalizationAssessor (Assessor_ID [PK], Assessor_Name, Qualification, Date_of_Qualification)i.The primary key being identified in this relation is Assessor_ID that helps to identify anAssessor. Only one ID will be assigned against each Assessor name as only record willbe there against a particular assessor. The qualification may be common for differentassessors thus it has not been set as a primary key as well two or more assessors may alsohave the same name. There is also a possibility that two or more assessors have commonDate_of_Qualification. From, the relation it has been identified there is no occurrence ofrepeating attributes thus it can be said that it is in 1st Normal Form. ii.Assessor_ID is the primary key as it cannot be ensured that there is an Assessor withunique name means there is a possibility that two or more assessors may have samenames. The qualification is also not unique for assessors as two or more assessor mayhave same qualification. This means that every other attribute of the Assessor Table canbe determined with the help of Assessor_ID. The primary key is single valued attributeand there is no partial dependency hence it can be said that the relation is in 2nd NormalForm.iii.The Assessor_Name cannot be used for determining the other attributes of the AssessorTable as it is not unique. It has been identified that there are no transitive dependencieswithin the table hence it can be said that the relation is in 3rd Normal Form.Claim (Claim_ID [PK], Claim_Date, Assessor_ID [FK], Policy_Number [FK],Claim_Status) i.Claim_ID has been identified as the primary key in this relation that defines the attributesrelated to Claim. The Claim_ID has been chosen as the primary key as there will be only
Database Design and Development - PDF_2

End of preview

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

Related Documents
Database implementation Assignment
|6
|1153
|103

Database Design and Development
|7
|1063
|493

STUDENT NAME : MANISH KHATIWODA Student Id :11681209.
|5
|431
|34

Database Design and Development
|5
|955
|111

Conversion Of Database Form 2022
|12
|787
|43

Professor Database Design.
|5
|450
|63