logo

Database System Assignment docx

4 Pages566 Words98 Views
   

Database Design and Development (COIT20247)

   

Added on  2020-02-18

Database System Assignment docx

   

Database Design and Development (COIT20247)

   Added on 2020-02-18

ShareRelated Documents
Running head: DATABASE SYSTEMDatabase System Name of the Student:Name of the University:Author Note
Database System Assignment docx_1
1DATABASE SYSTEM 1.Normalizationa. The list of relations for the ASS Database are provided below:Client (ClientID (primary key), FullName, Address, Phone, Level)Car (RegNo (primary key), Model, Maker, Color, ProducedYear, CarPrice, WarrantyPeriod)PartUsed (PartID (primary key), JobNo (foreign key), Quantity, PartCost)Service (JobNo (primary key), JobType, Description, StartTime, FinishTime, LabourCost)Employee (EmployeeID (primary key), FullName, Address, Phone, EmployeeType, Qualification,Experience)ClientCarPartUsedServiceEmployeeClientIDFullNameAddressPhoneNoLevelRegNOModelMakerColorProducedYearcarPriceWarrantyPeriodJobNoPartIDQuantityCostJobNoJobTypeDescStartTimeFinishTimeCostEmployeeIDFullNameAddressPhoneEmployeeTypeQualificationExperienceOwns,buysGetsSellsPerformsUsesRecievesDescriptionb. Functional dependencies The entities that are to be used for description in this report are client and CarThe Functional dependencies for Client is provided below:
Database System Assignment docx_2

End of preview

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

Related Documents
Assignment on The Database System
|5
|739
|52

Database Design and Development Assignment
|7
|916
|120

Database Design and Development | Assignment
|7
|841
|84

Database Design and Development
|5
|955
|111

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

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