Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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. image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions