logo

COIT20247 : Database Design and Development

7 Pages607 Words75 Views
   

Added on  2021-06-14

COIT20247 : Database Design and Development

   Added on 2021-06-14

ShareRelated Documents
COIT20247 Database Design and Development (T12018)Assessment Item 2 - Assignment 2Student ID:Module Tutor:
COIT20247 : Database Design and Development_1
Implementation Report IntroductionThe report is presenting the CQI database. The CQI database is designed and implemented in MS Access. All the required queries and reports are completed in the MS Access database.NormalizationER Diagram Mapping Functional Dependency ClaimClaim (ClaimID, LodgedDate, Status, PolicyID, PersonID)LodgedDate ClaimIDStatus ClaimIDPolicyID ClaimIDPersonID ClaimIDAll fields in the table Claim depend upon the ClaimID which is the primary key and uniquely identify the records in the Claim table.1 | P a g e
COIT20247 : Database Design and Development_2
Assessor Assessor (PersonID, QualificationName, DateQualified)QualificationName PersonIDDateQualified PersonIDAll fields in the table Assessor depend upon the PersonID which is the primary key and uniquely identify the records in the Assessor table.NormalizationThe normalized database is the best to store the data. It is very efficient. Following steps are required to achieve the third normalized database-1.Make separate tables with similar type of data e.g. Claim table for claims, property table for properties etc.2.Set one primary key in every table.3.All fields should only depend upon the primary key.4.Remove transitive dependency from every table.All the tables in the CQI database are following the above mentioned rules. So, the database of CQI is in third normal form. (Easy Computer Academy 2017)(Bigenners Book 2017)2 | P a g e
COIT20247 : Database Design and Development_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 - PDF
|8
|767
|87

COIT20247 Database Design & Development
|7
|643
|52

COIT20247 Database Design and Development- Doc
|7
|620
|34

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

COIT20247 Database Design and Development (T12018) - Assignment 2 Implementation Report
|8
|769
|319