c) Write FIVE (5) queries that demonstrates your knowledge and understanding of SQL. SQL statements to be used should include: Select, Update, Delete, From, Where, And, Count, Ascending, Order By. Ensure some of your queries use multiple commands. TWO (2) of the queries should join TWO (2) or more tables together. (20 marks) Task 3 Assessment and evaluation - 15 Marks Provide a written assessment and evaluation of the work you have undertaken. Your discussions should include:

How the database you have created meets the data and information requirements of your chosen organisation as identified in task 1a).

Why the use of ER modelling is an essential part in the design of a database solution, and how you used it to identify and rectify any design issues you encountered.

Any assumptions that you have made.

How the database supports the transactions that you identified in task 1a).