a$.$

For the table below, fill in the missing values in $W$ column, consistent with functional dependencies: $xYZA,$

$AW.$ You can make any necessary assumptions, but be sure to state them.

Given the schema $R$ and the following functional dependencies:

$R(x_{,}{Y}_{,}Z,W,A)$ with $xYZA,WA$

does XY determine W$?($XY $$ W$?)$ Why or why not?

Suppose that you were also given relation $S$ :

$S(P_{,}L,U_{,}{M}_{,}E)$

What functional dependencies $($if any$)$ can you assume?

b$.$ Consider a TVShows table that keeps track of different TV shows. The table stores the show name and the year to which the entry

refers. Additionally, each row stores channel name, length of the show, the average cost of an episode, and the filming location's zip,

county and state. Moreover, each entry contains the name of the lead actor and their salary.

The table is already in First Normal Form, and its primary key is $($ShowTitle$,$ Year$).$

The schema for the TVShows table is:

$($ShowTitle$,$ Year, Channel, Length, Cost, Zip, County, State, Lead, Salary$)$

You are given the following functional dependencies:

ShowTitle $$ Channel

Zip $$ County, State

Lead $$ Salary

ShowTitle, Year $$ Channel, Cost, Length

Remove any existing partial dependencies to create a set of linked relational schema $($copying functional dependencies does

not define a schema, be sure to include primary$/$foreign keys$)$ in Second Normal Form.

Remove any existing transitive dependencies to create a set of linked relational schemas in Third Normal Form.

c$.$

Given the schema $R$ and the following functional dependencies.

$R(A,B,C,D,F)$ with $ABC,CD,FF(the$ latter $FDis$ always true$)$

Describe how to identify a primary key for relation $R($the primary key is a minimal set of columns that determines all

columns in the relation such that $?$ABCDF $)$

Decompose relation $R$ into a relational schema in third normal form