Instructions

This assignment addresses course outcomes $CO1,$

CO$2$ and module learning objectives LO$1.$

Consider the following relation.

A$-$ Given the previous extension $($state$),$ which of the

following dependencies may hold in the above relation? If

the dependency cannot hold, explain why by specifying the

tuples that cause the violation.

$AB$

$BC$

$CB$

$BA$

$CA$

B$-$ Does the above relation have a potential candidate key

that consists of only one attribute? If it does, what is it$?$ If

it does not, why not?

C$-$Does the above relation have a potential candidate key

that consists of multiple attributes? If it does, what is it$?$ If

it does not, why not?