QUESTION $3(20$ Marks$)$

The past decade has seen a proliferation of different data types including audio, text, and video. Consequently, $1-$tier database structures were not able to sustain this growth and varied data types. This has resulted in the adoption of a $3-$tier architecture which has grown exponentially across all industries.

$3\mathrm{.}1$

Provide a contrast between a schema and a subschema utilised in database management. $(9$ Marks$)$

$3\mathrm{.}2$

Analyse how a multi$-$valued attribute is achieved. $(5$ Marks$)$

$3\mathrm{.}3$

Provide a detailed discussion on $3-$tier architecture. $(6$ Marks$)$

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.