logo

COIT20247 Database Design & Development

7 Pages643 Words52 Views
   

Added on  2021-06-17

COIT20247 Database Design & Development

   Added on 2021-06-17

ShareRelated Documents
Student ID: Student Name:COIT20247 DatabaseDesign and Development(T12018)Assessment Item 2 – Assignment 2
COIT20247 Database Design & Development_1
Implementation Report IntroductionThe report is showing the inclusive detail about CQI database. In CQI database, the queries and database reports are created to show the summary data for the upper level employees like administrators etc. The assignment is showing the proper way to map the ER diagram into the normalized relational database.NormalizationER Diagram Mapping
COIT20247 Database Design & Development_2
Functional Dependency Assessor TableAssessor (PersonID, QualificationName, DateQualified)QualificationName PersonIDDateQualified PersonIDEvery field is depending upon the PersonID, means only the PersonID can uniquely identify the assessor’s records. PersonID is the primary key in the Assessor table.ItemsClaimed Table ItemsClaimed (ClaimID, ItemID, ItemName, Quantity, Status)ItemName ClaimID, ItemIDQuantity ClaimID, ItemIDStatus ClaimID, ItemIDThe table ItemsClaimed is having the composite key (ClaimID, ItemID). Another fields depend upon the composite key (ClaimID, ItemID) only.NormalisationThere are some rules to obtain the third normalized database as following--Separate all tables according to the data.-Set primary or composite key in all tables.-All fields must depend upon the primary or composite key.-Eradicate transitive dependencies from the entire database.Above defined tables- Assessor and ItemsClaimed; both are following the above mentioned rules. Therefore both are in third normal form. All tables are similarly following the above mentioned rules. (Chapple M. 2018)(geeksforgeeks.org n.d.)
COIT20247 Database Design & 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 and Development
|7
|607
|75

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

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

Normalized CQI Database Design and Development (T12018) Assessment Item 2 - Assignment 2 Student ID: Tutor: 2018 5/17/2018
|8
|769
|200