logo

Report On Implementation Of AAS Database

6 Pages474 Words35 Views
   

Added on  2020-02-24

Report On Implementation Of AAS Database

   Added on 2020-02-24

ShareRelated Documents
Student ID –Date -Module Tutor -1 | P a g e
Report On Implementation Of AAS Database_1
Implementation Report IntroductionThe AAS database implementation is being described in the report. All details about functional dependency and normalization is being shown in the report.NormalizationMapping of ER Diagram to Third Normal Form(Lucid Software Inc. 2015)Functional Dependency EmployeeEmployee (EmployeeID, EmployeeName, Street, City, State, Postcode, Phone)Information of more employees may be similar e.g. Name, Address etc. Therefore, to find the specific employee, a unique key is required and EmployeeID is working as a unique key to find an employee.EmployeeName EmployeeIDState EmployeeID2 | P a g e
Report On Implementation Of AAS Database_2
PartTypePartType (PartID, PartDescription, PricePerUnit)Information of more parts may be similar e.g. price, description etc. Therefore, to findthe specific part, a unique key is required and PartID is working as a unique key to find an employee.PricePerUnit PartIDNormalisation DemonstrationThe third normalisation process is achieved by the following rules--All tables are containing unique data.-Al tables are containing primary key.-Transitive dependency should not be shown in any table.Tables Employee and PartType are in third normal form as shown below-Employee (EmployeeID, EmployeeName, Street, City, State, Postcode, Phone)PartType (PartID, PartDescription, PricePerUnit) (teach-ict.com n.d.)3 | P a g e
Report On Implementation Of AAS Database_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 Fundamentals Report 2022
|12
|526
|39

Logical and Physical Design of International Parcel Service Database
|11
|567
|286

AAS Database Management Assignment
|9
|625
|122

COIT20247 Database Design & Development
|7
|643
|52

COIT20247 Database Design and Development - Doc
|8
|859
|53