Honda king is an automotive repair


Honda King is an automotive repair shop where customers take their cars for service maintenance. A database designer was hired to create relations for a database to keep track of their service records. The following rules apply: 
1. Each mechanic has a unique number. 
2. All cars coming for service are assigned a unique tag number. 
3. The service price is determined by the car model. 
4. Each service is assigned a unique service record. Each service involves a single car and a single mechanic.
5. Each mechanic is paid an hourly rate which is determined by who the mechanic is. 
6. Service discounts are given. The discount code depends on the date of service. 
The database designer has come up with the following schema for the database: 

CarService (ServiceRecordNumber, tagNumber, CarModel, DateServices, ServicePrice, MechanicNumber, MechanicName, HourlyRate, DiscountCode)

List all functional dependencies present in given relation?

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Honda king is an automotive repair
Reference No:- TGS081798

Expected delivery within 24 Hours