1 a) Using the relations above, explain the following terms :

i.Entity Integrity [2] ii.Referential Integrity [2] iii.Domain Integrity

[2] 1b) Write SQL statements to create the tables below :

i) tblcomplain_resolve [6] ii) tblcustomers [4] NB: Include footnotes on your table creation sequence.

1c) Give the user mildred the right to add data in the table tblcomplains [4]

1d) Withdraw the right to delete data from user miriro on the table tblusers [4]

1e) Write SQL statements to compute the following

i) Number of complains that were logged by Customer ID 0001 which where resolved [6]

ii) Complains which are pending and the number of days they have taken without being resolved [6]

iii) Complains that where resolved on the same day they were logged [3]

1e) As a professional database administrator you would want to create known save points as you transact in case of a system crush as one of the key implementations to ensure that ensure that the database is taken from one consistent state to the next consistent state.

Using your expertise implement the following TCL:

i) While adding the following customer data and the customer complain log, create the two save points A, B. Customer Data - [ 0004, Marting, Mabwandi, artinmabwnadi@ymail.com, 78-6679T ] [4] ,

Complain Log [CID9003, 2022-09-20, 0004, Expired Buns] [4]

ii) Assuming that while attempting to execute the query statements above , the electricity supply system blacks out , write an SQL statement to reverse the transaction to save point A [3]