here is a table for cars in a used car lot , with numbered areas where parked: a

Question

here is a table for cars in a used car lot , with numbered areas where parked:

a) find a functional dependency (FD) with one attribute on each side that holds for the instance

b) Disprove the proposed FD "year area -> price"

c) find a multi-column key with model as one of us attributes that holds this instance

d) do you think the key you found in c. will hold up under further insertions b this application?

e)

(25 points) 6, FDs and nentaliznion Here is a table for cars in a used car lit, with nAnntened anne weere urns where parked Model Year(20xx) Price (in 100ms) Area Ford Toyota Ford 14 Kia 22 Toyota eep a. Find a functional dependency (FD) with one atribute on each sided sti

Explanation / Answer

solution a)

functional dependency (FD) : Model -> Area

Solution b)

"year area -> price" , here for the same value of year and area the price is different. So, we can disprove this FD.

Example, for Year 16 and Area 3, we have two prices 22 and 19.

Solution c)

multi-column key: { Model, Year}

Solution d) Yes, the key I found in 'c' will hold up under further insertions b this application because our key is { Model, Year} which will unique identify the rows of the table.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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