Implementation Report IntroductionThe AAS database management is being shown in the report. The complete detail along with database normalization is being shown in the report.Normalization Mapping of ER Diagram to Third Normal FormFunctional Dependency ClientClient (FFClientID, FFClientName, FFStreet, FFCity, FFState, FFPostcode, FFPhone,FFIsSenior)The detail of different clients may be same. In that situation, to find a particular client,a specific primary key is required. Client ID will work as a primary key for the Client table.FFClientName FFClientIDFFState FFClientID2 | P a g e
PartTypePartType (FFPartID, FFPartDescription, FFPricePerUnit)The detail of different parts may be same. In that situation, to find a particular part, a specific primary key is required. Part ID will work as a primary key for the PartType table.FFPricePerUnit FFPartIDNormalisation DemonstrationTables below are satisfying the rules of 3 NF-Client (FFClientID, FFClientName, FFStreet, FFCity, FFState, FFPostcode, FFPhone,FFIsSenior)PartType (FFPartID, FFPartDescription, FFPricePerUnit)-Each table is having separate identity.-Each table have primary key.-No transitive dependency.(H. Bdr 2013)(teratrax.com n.d.)3 | P a g e
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
COIT20247- Database Design and Developmentlg...
|7
|699
|75
Database Implementation Report for CQUnited Property Management Systemlg...
|8
|932
|250
COIT20247 Database Design & Developmentlg...
|7
|643
|52
COIT20247 Database Design and Development Implementation Reportlg...
|9
|778
|463
COIT20247 Database Design and Development (T12018) - Assignment 2 Implementation Reportlg...
|8
|769
|319
COIT20247 Database Design and Development - PDFlg...