Let us look at a temporary staffing agency that happens to be based In Scotland. They provide workers to hotels in varlous locations, and they table that they use to keep track of these contracts looks like this:

A functional dependency {8] means that if you know the values of the attributes in set A, then you will know the value of the attributes in set B. Another way to put that is that if there are multiple rows with the same values for the various columns in (Al, then those same rows must have the same values in each of the columns in (a). For example, you will notice that everywhere that H25 shows up as the Hotel Number, the hotel location is in Edinburg. On the other hand, notice that there are three rows in which the hotel location is Edinburg, but the Hotel Number is not the same in all three cases. Two of them are dentified as H25 and the third is H16. That tells us that (Hotel Number) other way around. Which makes sense, large cities typically have a number of hotels would generally guess that Hotel Number uniquely identified hotels. Also note that there are two folks with the name Diane Hocine (what are the odds?) but we know they are different people because they each have a different National Insurance Number >Hotel Location) but not the in them, and we With that introduction, look at the values in this little table, and . Find the rest of the functional dependencies a for each functional dependency, spell out exactly which rows/values in the data support your claim of that functional dependency b Dagram the functional dependencies the way that we showed you in class 2. Diagram the normalized model of the above data in UML 2. Make the relation scheme diagram corresponding to the UML that you create.