logo

Assignment on The Database System

5 Pages739 Words52 Views
   

Added on  2020-04-07

Assignment on The Database System

   Added on 2020-04-07

ShareRelated Documents
Running head: DATABASE SYSTEMDatabase System Name of the Student:Name of the University:Author Note
Assignment on The Database System_1
1DATABASE SYSTEM 1.Normalizationa. The list of relations for the ASS Database are provided below:Client (ClientID (primary key), FullName, State, Street, City PostalCode, Phone, Level)Car (RegNo (primary key), Model, Maker, Color, ProducedYear, CarPrice, WarrantyPeriod, ClientID)Complaint (ComplaintID (primary key),, JobNumber, Reason, Lodgeddate, Outcome)Employee (EmployeeID (primary key), FullName, Street, City, State, PostalCode, Phone,EmployeeType)EmployeeType (EmployeeType (primary key), Type, Desc)LabourWork (EmpleyeeID, JobNO, StartTime, FnishTime, LabourCost)PartType (PartID, PartDescription, PricePerUnit, PartUsed)PartUsed (PartID (primary key), JobNo (foreign key), QuantityUsed, PartCost)Service (JobNo (primary key), Description, ServiceDate, TotalCost, RegNO (forgienKey),ReplacementRequired)b. 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:ClientIDFullName, State, Street, City PostalCode, Phone, LevelThe client table has ClientID as the primary key and all the information regarding the clients canbe acquired from the client table by using the ClientID. Hence the 3NF normalization for the relation isalso maintained efficiently. The FullName, State, Street, City PostalCode, Phone and the Level express
Assignment on The Database System_2

End of preview

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

Related Documents
Database System Assignment docx
|4
|566
|98

Database Design and Development Assignment
|7
|916
|120

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

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