I have 4 Database concept questons that i am not sure about Any Help would be gr

Question

I have 4 Database concept questons that i am not sure about

Any Help would be great thanks :

1;Explain the meaning of the following functional dependency:

   (CollegeDegree, YearsOnJob) Salary
What is the determinant of this functional dependency?

2.Think of a functional dependency involving children watching television. Write the functional dependency using the format shown in the Study Guide and textbook.

3.Think of a functional dependency involving teenagers driving. Write the functional dependency using the format shown in the Study Guide and textbook.

3.Think of a functional dependency involving senior citizens driving. Write the functional dependency using the format shown in the Study Guide and textbook.

Explanation / Answer

Answer)

1;Explain the meaning of the following functional dependency:
(CollegeDegree, YearsOnJob) Salary
What is the determinant of this functional dependency?

Here the CollegeDegree, YearsOnJob is the determinant of the functional dependency of the functional dependency (CollegeDegree, YearsOnJob) Salary.
If there is more than one attribute to determine another attribute in an entity as in (CollegeDegree, YearsOnJob) Salary, then such a determinant is termed as a compound determinant.
Here it means that the salary will be dependent on the college degree and the years of job that you have done. This is the meaning of the compound determinant of the functional dependency.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.