logo

Database Design and Development | Assignment

7 Pages841 Words84 Views
   

Added on  2020-03-28

Database Design and Development | Assignment

   Added on 2020-03-28

ShareRelated Documents
Running head: DATABASE DESIGN AND DEVELOPMENTDatabase Design and DevelopmentName of the StudentName of the UniversityAuthor Note
Database Design and Development | Assignment_1
1DATABASE DESIGN AND DEVELOPMENT Table of Contents1. Normalization..........................................................................................................................................22. Relational Database Implementation.......................................................................................................53. Short report for implementation..............................................................................................................54. Complexity in the assignment..................................................................................................................5Bibliography................................................................................................................................................7
Database Design and Development | Assignment_2
2DATABASE DESIGN AND DEVELOPMENT 1. Normalization1.1. The specimen arrangement of ASS database is utilized for mapping the ERD into an arrangement ofrelations into 3 NF.The Employee table created is as follows:EmployeeID PKFullNameStreetCityStatepostCodePhoneEmployeeTypeAfter normalization the table created is as follows:Employee (EmployeeID PK, Full Name, Street, City, State, postCode, Phone, Type, NoofExperienceYears, Certificate Level)The client table created is as follows:ClientID PKFullNameStreetCityStatepostCodePhoneIsSeniorThe car table given created is as follows:RegnNbr PKMakeModelColourProducedYearPriceWarrantyDue datePurchasedfromASSFor normalization of the car table the dependencies are removed and the accompanying table is made Car (RegNo PK, Make, Model, Colour, Manufacturing Year, Price, WarrantyDue Date,PurchasedFromASS)Service tableJob_Nbr PKJob_DescriptionService_DateTotal_CostAfter normalization the created service table is given below
Database Design and Development | Assignment_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

Database Design and Development
|5
|955
|111

Assignment on The Database System
|5
|739
|52

Database Design & Development- Report
|11
|1478
|299

Database Management System: Case Study of BigM System
|12
|1280
|412

Assessment Task 2
|10
|735
|219