$($a$)$ An important concept in the theory of relational databases is that of a functional

dependency.

$($i$)$ Define functional dependence and provide ONE $(1)$ example to support

your answer.

$(2$ marks$)$

$($ii$)$ Based on Table $1,$ create TWO $(2)$ functional dependencies in the

following table $($A$,B$ and $C$ are the names of the columns$).(4$ marks$)$

Table $1$: Dependency Table

$($b$)$ Describe TWO $(2)$ types of anomaly that could be caused by the table below.

Table $2$: Dependency Table