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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started