logo

Database Design and Development Assignment

7 Pages916 Words120 Views
   

Added on  2020-04-01

Database Design and Development Assignment

   Added on 2020-04-01

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. Implementation of Relational Database...................................................................................................43. Short Implementation report....................................................................................................................44.The most complex task in the assignment.................................................................................................5Bibliography................................................................................................................................................6
Database Design and Development Assignment_2
2DATABASE DESIGN AND DEVELOPMENT 1. Normalizationa. The sample solution of ASS database is used for mapping the ERD into a set of relations into 3 NF.The table EmployeeEmployeeID PKFullNameStreetCityStatepostCodePhoneEmployeeTypeFor making it in 3 NF the following new table is created Employee (EmployeeID PK, Full Name, Address (Street, City, State, postCode), Phone, Type,Noof ExperienceYears, Certificate Level)ClientID PKFullNameStreetCityStatepostCodePhoneIsSeniorThe client table in already generalized and thus no changes are made in the client tableClient (ClientID PK, Full Name, Address (Street, City, State), Phone, Seniority Level)The car table given in the example is RegnNbr PKMakeModelColourProduced YearPriceWarranty DuedatePurchasedfromASSTo make it in 3NF the following table is created Car (RegNo PK, Make, Model, Colour, Manufacturing Year, Price, WarrantyDue Date,PurchasedFromASS)The service table given in the example isJobNbrPKJobDescriptionServiceDateTotalCostThe service table after normalization
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
|841
|84

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

Assignment on The Database System
|5
|739
|52

Database System Assignment docx
|4
|566
|98

Database Design and Development
|5
|955
|111

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