3. Study the following database table that stores employee records and answer the questions that follow. EmployeeID Firs

[answerhappygod]

3. Study the following database table that stores employeerecords and answer the questions
that follow.
EmployeeID First_Name Last_Name Department Gender D_O_B
22-230702F56 Sue Manake Acc & IS Female 21/04/1984
83-270902T83 Jerry Peters Economics Male 10/06/1980
07-160935B07 Solomon Mutasa Acc & IS Male 14/02/1986
63-457602A52 Cecilia Taven Management Female 19/11/1988
Write SQL statements to do the following:
i. To display the details of only male employees in the Acc& IS department
[2marks]
ii. Get list all employees born after the year 1982. [2marks]
iii. Top modify the Last_Name of the employeeID 63-457602A52 toTavengwa.
[3 marks]
iv. To delete all the records of employees in Acc & ISdepartment the from the table.