QUESTION $5$

NOTE: All SQL syntax must be correct, missing characters will be penalized!

$5.$a$.$ The Finance Department of SOUTHERN AFRICA NAZARENE UNIVERSITY stores

the Bonus field in the Employee table because a bonus is an attribute associated with

employees.

EMPLOYEE $($Employee ID$,$ Employee$\_$Fname, Employee$\_$Lname, Birthdate, Dept$\_$ID$,$

Bonus$)$

Given the structure and contents of the database shown in table above, use SQL

commands to answer questions $5.$a$.$i$-$ii$.$

i$.$ Write a SQL code to display the employees names, year of birth, and the bonus for

each employee. Sort the results by the employee$\_$id as in the table below.

ii$.$ Because you are a registered student at UNISA and you have classmates who are your friends, please write SQL code to enter your own correct information and also the information of anther student into the STUDENT table. That is $2$ records. For the student number of your friend you can use $33339999.$

iii. Write a SQL code to change your email address from your mylife email address to a Gmail address.

iv$.$ Write a SQL code to delete the STUDENT table from the database. Table $5\mathrm{.}1$:

ii$.$ Write the SQL code to delete the row for the employee who was paid R$24,000$ bonus.

$5.$b$.$ In the following questions, you will use the data of UNISA student registration information.

i$.$ Write the SQL code that will create the STUDENT table provided below. This table is a subset of the UNISA student registration database. $($Note that the DEPT$\_$CODE is the FK to DEPARTMENT, also use your own Data Declarations$).$

Table $5\mathrm{.}2$: The attributes of the Student Entity

ii$.$ Because you are a registered student at UNISA and you have classmates who are your friends, please write SQL code to enter your own correct information and also the information of anther student into the STUDENT table. That is $2$ records. For the student number of your friend you can use $33339999.(4)$ iii. Write a SQL code to change your email address from your mylife email address to a Gmail address.

iv$.$ Write a SQL code to delete the STUDENT table from the database.