QUESTION $2$

$(20$ Marks$)$

The article state that, $"...$Having a well$-$designed database is the key to having your database meet these criteria, and the six$-$step database design technique ensures that the data model upon which your database is based is sturdy, reliable, and accurate." Detail how each of the following concepts achieves this:

$2\mathrm{.}1$ Concept $1$: Normalization,

$(15$ Marks$)$

Concept $2$: Denormalization

$2\mathrm{.}2$ Consider the following table and converted into $3^{rd}$ Normal form and fill in missing spaces.

$(5$ Marks$)$

$($a$)$

$($b$)$

$($c$)$

$($d$)$ Primary key of the first Table

$($e$)$ Primary key of the Second Table

$\backslash$table$[[$Staff$\_$No$,$Salary$\_$Number,sName,Salary$],[101,1011,$Klyen,$2000],[102,1021,$Kim,$4000],[103,1031,$Jane,$3000]]$