QUESTION $4(20$ Marks$)$

Use the following EMPLOYEE table to answer related SQL questions below:

EMPLOYEE:

Empl$\_$ID

EMP$\_$Name

EMP$\_$Email

EMP$\_$AGE

EMP$\_$SALARY

X$0001$

Eva

Evak@Maredi.co$.$za

$44$

R$25000$

X$0002$

Lucy

LucyB@Maredi.co$.$za

$25$

R$12000$

X$0003$

Charlene

CharleneJ@Maredi.co$.$za

$24$

R$46000$

X$0004$

Danny

DannyB@Maredi.co$.$za

$35$

R$8000$

$4\mathrm{.}1$

Normalise the Employee table and provide a detailed explanation for each level of normalisation implemented. $($Your solution should be supplied on a separate Word document named $$Question $4\mathrm{.}1$ and submitted as part of your final submission$)$

$4\mathrm{.}2$

Formulate the SQL statement$($s$)$ required to rename one of the normalised tables to HR Remuneration and substantiate your answer.

QUESTION $5(20$ Marks$)$

The case study focuses on important features of real$-$time database management systems such as performance, indexing and scalability. Patten Matching is yet another important feature of a database management system which refers to a process of algorithmically searching for patterns in sequences of unprocessed data or tokens.

$$

Depict how pattern matching can be realised in Structured Query Language.

$$

Provide a detailed examination of the different types of DBMS languages.

END OF