Model Core Days Country Tax% Corei7 6 3 India 5 Corei7 4 2 Ireland 0 Corei7 4 2

Question

Model        Core    Days       Country       Tax%

Corei7          6              3             India             5

Corei7          4              2            Ireland           0

Corei7          4              2             India             5

Corei7          8              4              US               0

Corei5          4              2             Japan           5

XeonE7        4              2             Korea          5

XeonE7        4              2             Japan           5

Pentium        6              3             Ireland         0

AMD830       4               2            Mexico          6

AMD760       4               2             Japan           5

AMD S         8                4              US              0

Identify all the data driven functional dependencies in the CAR relation listed above. then identify the minimal cover (Fc) for the entire set of functionl dependencies (F).

Explanation / Answer

Above CAR example is having functional dependency when

Core -> Days means that the values of Days are determined by the values of Cores. Two tuples sharing the same values of Cores will necessarily have the same values of Days.

Here number of Days are dependent on Cores, i.e., Days->Cores/2 which means if we have 6 cores then it would take 3 days.

so we can conclude that whenever two rows in this table feature the Cores (4) they also necessarily have same Day Values(after divided by 2)

minimal Cover is: Core->Days,Core->Model,Days,Model->Core

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

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