Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Computer Engineering Expert

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?

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M981798

Have any Question?


Related Questions in Computer Engineering

1 what would be the purpose for a user to protect a

1. What would be the purpose for a user to protect a file from "read" or "write" access by other users? 2. Is there a reason why it would be safer for administrators to use two different accounts when working with a comp ...

Question suppose a computer using direct mapped cache has

Question : Suppose a computer using direct mapped cache has 2 20 words of main memory and a cache of 32 blocks, where each cache block contains 16 words. a. How many blocks of main memory are there? b. What is the format ...

Question suppose we iterate the application of a blurring

Question : Suppose we iterate the application of a blurring filter with kernel size 5 on an image of 800 times 600 pixels. How many times should we apply the filter for the color of the pixel at position (20, 20) to be i ...

Systems and networksconsider sending a large file from a

(Systems and Networks) Consider sending a large file from a host to another host using a reliable connection such as TCP. Suppose the reliable connection uses additive-increase, multiplicative-decrease (AIMD) without slo ...

Questionargentina has 10000 hours of labormonth- producing

Question:Argentina has 10,000 hours of labor/month: - producing 1 lb. coffee requires 2 hours; - producing 1 bottle wine requires 4 hours. Brazil also has 10,000 hours of labor/month: - producing 1 lb. coffee requires 1 ...

A cell phone company offers 15 different voice packages and

A cell phone company offers 15 different voice packages and 15 different data packages. Of those, 6 packages include both voice and data. How many ways are there to choose either voice or data, but not both?

Question discussion pointdefine and briefly discuss the

Question: Discussion point: Define and briefly discuss the following brainstorming techniques, the delphi technique, brainstorming, or nominal group technique. Please read the above discussion point and write the respons ...

Select a company with which you are at least somewhat

Select a company with which you are at least somewhat familiar. Explain how this particular company could benefit from a data warehousing and data mining initiative. What value do you see in data mining in the context of ...

Subject digital securityprovide an fidm authentication

subject : Digital Security Provide an FIdM authentication system that you have used (being subjet to). Tell the name of the organizations acted as the IdP (Identity Provider) and SP (Service Provider)?

Regional blocs like the eu are straining the british have

Regional blocs like the EU are straining. The British have voted to Brexit! What has caused the tension and what does the future hold - for Brexit and beyond?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As