The table below represents some sample data from a spreadsheet kept by a local c

Question

The table below represents some sample data from a spreadsheet kept by a local car dealership for their inventory tracking. Review the table and assumptions below, then answer the exercise questions that follow. Assumptions bullet No two makers produce a car with the same model bullet The color does not play a part in the MSRP bullet No two models within a make have the same price in a given year bullet A given model in a given year may be offered in multiple colors Exercises Part 1. List all the functional dependencies found in the spreadsheet. Remove any trivial or implied functional dependencies. Use FD rules if necessary to minimize the number of FDs needed to cover all FDs. List all the multi-valued dependencies found in the spreadsheet. Remove any trivial or implied multi- valued dependencies. MVDs already listed as FDs need not be listed again here. Part ll List all candidate keys. List al 4NF violators. Follow the 4NF decomposition steps outlined in the lecture slides to put the spreadsheet into 4NF. All intermediary decompositions, new candidate keys, and remaining 4NF violations should be documented for each step of the process.

Explanation / Answer

1) the functional dependency is as follows,

Model --> make

Price -->model

Price --> make

Price -->year

Multi valued dependency

Price --> year --> make -->model

Part b:

Here the make and the colour are the candidate key

4 nf violates if the multiple valued dependency does not have candidate key

To remove multi value dependency the table can be split into two

Make

Model

Colour

Year

Table 2

Make

Model

Price

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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