Based on the Sample2312 database provided. Safe updates must be enabled. Your solution must include all the queries in plain text and, at least, one validation snapshot per query. Your snapshots must include the notification area with date and time visible. Size your snapshots in a way that they are readable while including the day-time of the system. Write SQL statements that:

1. List the properties for rent (No, type, city, rooms and rent) that are suitable for client CR62. Suitability is determined by his/her maximum Rent, preferred Type and city. As city is not part of the table Client, the company clarified that he/she lives in Glasgow and that he/she is looking for places in the same city. The answer must come via a single query. (13 marks)

2. Property PG4 has a tax issue. Get the name of the staff member in charge of that property. Format the name to be displayed as a single (Name) column. Explain your results. (13 marks)

3. Modify (Alter) the column sex. Change its name to gender. Change also (if needed) its domain to accept the values NB, NC. (12 marks)

4. List the owners (full name, email and phone) that have more than one property offered for rent. (9 marks)

5. Execute: (16 marks) insert into Viewing values ('CR55' , 'PA14' , '2013-06-24 10:00' , 'Awesome'); In case of finding problems with the insertion: Describe the problem, Explain the cause, Propose one sound/valid solution.

6. Your secretary wanted to learn databases and executed: (15 marks). insert into CClient values (750, 'Smithe', 'Flat' ,'01425-198723' ,'Johnson' , 'CR60', 'johnsybad@msn.uk'); Describe and explain the issue, Rewrite the statement in a proper way (if applicable).

7. Attempt deletion of staff SG37 from the table Staff. Any changes in Registration? Provide an explanation. Display the table Registration before and after. (11 marks)

8. Properties for rent will be modified. The term Flat wont be used anymore, it will be replaced with Apartment. Execute the corresponding updates. Explain your results. Remember to include safe updates in your explanation. (11 marks)