Ask a question from expert

Ask now

COIT20247- Database Design and Development

7 Pages699 Words75 Views
   

Central Queensland University

   

Database Design and Development (COIT20247)

   

Added on  2020-03-04

About This Document

The database implementation of AAS is shown in the report. The complete functionality and features of the AAS database are defined and described in the report. The normalization process is also discussed in detail.

COIT20247- Database Design and Development

   

Central Queensland University

   

Database Design and Development (COIT20247)

   Added on 2020-03-04

BookmarkShareRelated Documents
Student ID –Date -Module Tutor -1 | P a g e
COIT20247- Database Design and Development_1
Implementation Report IntroductionThe database implementation of AAS is being shown in the report. The complete functionality and features of AAS database are defined and described in the report. The normalization process is also shown in detail.NormalizationMapping of ER Diagram to Third Normal Form(Studytonight.com 2016)Functional Dependency ClientClient (ClientID, ClientName, Street, City, State, Postcode, Phone, IsSenior)Lot of Clients may share same information like name, address etc. To find the specificclient, an identity is required. The Client Id is the unique or primary key that is helping in finding the specific client.ClientName ClientIDState ClientID2 | P a g e
COIT20247- Database Design and Development_2
PartTypePartType (PartID, PartDescription, PricePerUnit)Lot of parts may have same prive. To find the specific part, an identity is required. The part Id is the unique or primary key that is helping in finding the specific part.PricePerUnit PartIDNormalisation DemonstrationA table is called in 3 NF if all the below mentioned rules are concerned--The table include the specific data.-The table include the primary key.-No transitive depend should be in the table.Following tables are showing the best example of third normalization-Client (ClientID, ClientName, Street, City, State, Postcode, Phone, IsSenior)PartType (PartID, PartDescription, PricePerUnit)Client and Part Type tables, both are satisfying the 3 NF rules. Therefore, both are in 3 NF.(Freetutes.com n.d.)3 | 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
Database Design and Development Assignment
|7
|916
|120

Assignment on The Database System
|5
|739
|52

Report On Implementation Of AAS Database
|6
|474
|35

AAS Database Management Assignment
|9
|625
|122

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