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

The functional dependencies are:

model,core->days;  core->days;

model,country->tax%;  country->tax;

The minimal cover for the functional dependencies is:

here we remove redundent,augumented functional dependencies, (i.e if A->B then CA->B so we can remove CA->B) same like for the above dependencies remove unnecessary attributes to minimize the set then

core->days;

country->tax;

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

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