Ask a question from expert

Ask now

AAS Database Management Assignment

9 Pages625 Words122 Views
   

Added on  2020-03-23

AAS Database Management Assignment

   Added on 2020-03-23

BookmarkShareRelated Documents
Student ID –Date -Module Tutor -1 | P a g e
AAS Database Management Assignment_1
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
AAS Database Management Assignment_2
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
AAS Database Management Assignment_3

End of preview

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

Related Documents
COIT20247- Database Design and Development
|7
|699
|75

Database Implementation Report for CQUnited Property Management System
|8
|932
|250

COIT20247 Database Design & Development
|7
|643
|52

COIT20247 Database Design and Development Implementation Report
|9
|778
|463

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

COIT20247 Database Design and Development - PDF
|8
|767
|87