Question: Winter will soon be here and with it, the plows on the streets. The table below presents data about snowplows, mechanics responsible for the plows,

Winter will soon be here and with it, the plows on the streets. The table below presents data about snowplows, mechanics responsible for the plows, and the drivers of the plows. The plows are owned by the Boston Metropolitan Area Snow Removal Commission and the managers are BMASRC employees. They are, however, driven by drivers who are regularly employed by local landscaping companies. An hourly cost of usage has been determined for each plow, and in addition, there is an hourly rate that is paid to the driver. This rate depends on both the plow and the driver. (10 points) a) Identify the functional dependencies between the attributes b) Convert the table into a relation (named PlowDrivers). In what normal form is this relation (justify your view)? c) For the PlowDrivers relation, give specific examples of possible insertion, deletion, and modification anomalies. Can you find any current examples of problems with the data? d) Create the set of relations needed to represent the data in 3NF. Winter will soon be here and with it, the plows on the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!