QUESTION $3$

$(20$ Marks$)$

Consider the following Table, please note that only the columns are shown in this table However this is not an empty table.

Table:Employee

$\backslash$table$[[$EMP$\_$ID$,$F$\_$NAME,L$\_$NAME,Salary$],[,,,]]$

$3\mathrm{.}1$ Write an SQL statement to list of all employees ordered by salary$($high to low$)$

$(7$ Marks$)$

$32$ Write an SQL statement to creates a report with the employee data for the top $5$ salanes in the company.

$(7$ Marks$)$ This kind of report must be ordered based on a given criteria, in our example, the order criteria will again be salary DESC:

$3\mathrm{.}3$ Write an SQL statement to Show All Rows with an Above Average Value

$(6$ Marks$)$

QUESTION $4$

$(20$ Marks$)$

It is true that: "A database is the bachbone of any application, and therefore it must be sturdy, reliable, and accurate". We can adopt deadlocks control mechanisms and transaction recovery techniques to ensure that our database data is accurate at all operation conditions.

$4\mathrm{.}1$ Discuss the THREE $(3)$ basic techniques to control deadlocks.

$(10$ Marks$)$

$4\mathrm{.}2$ State why Transaction Reoovery is important.

$(10$ Marks$)$

QUESTION $5$

$(20$ Marks$)$

According to the article: $"...$Having a well$-$designed database is the key to having your database meet these criteria...", emphasis the need to a proper relationship between entities. The following diagram highlights a typical relationship for a college.

$5\mathrm{.}1$ State all relationships with cardinalities displayed by the ERD.

$(10$ Marks$)$

$52$ Discuss at least FIVE $(5)$ rules that defines $"$RDBMS$"$

$(10$ Marks$)$