$2.$ Recall that a database has many types of users, each of whom may require a different view

of the database. For example, one user of the Person$-$vaccinatedin$-$Centre database of

question $1$ may be accessing and printing the details and job types of each Person

frequently and thus a view for this user is created. Another view for this database is checking

that centre has available budget before expenditure such as for buying supplies.

$($Total for que $2$ is $10$ marks$)$

i$)$ Using this Person$-$vaccinatedin$-$Centre database, give $2$ additional views that may be

needed by other user groups for the database.

$(5$ marks$)$

$5$

Solution : $(5$ marks for que $2$i$)$

$($a$)$

$($b$)$

ii$)$ Give $5$ examples from many of the different types of key, domain, foreign key, entity and semantic

integrity constraints that you think can apply to the Person$-$vaccinatedin$-$Centre database of

question $1.(5$ marks$)$

Solution : $(5$ marks for que $2$ii$)$

GA : any $5$ of the following can be used.

$($a$)$

$($b$)$

$($c$)$

$($d$)$

$($e$)$

$($f$)$

$($g$)$