Perform physical design for efficiency if necessary.

Construct SQL statements for querying the database effectively.

Details are provided in the assignment item Project Task $3.$ In Project Task $3,$ you are required to write $12$ SQL queries based on the tables from the provided relational model Download relational model.

These queries are detailed in the task$-3.$sql Download task$-3.$sqlfile, along with their corresponding scores.$$

All table names, attribute names, primary keys, and foreign keys are specified exactly as shown in the relational model Download relational model.

Please fill in your answers in the designated spaces within the task$-3.$sql Download task$-3.$sqlfile, and submit it on or before the deadline.

Do not modify any of the provided SQL queries in the task$-3.$sql Download task$-3.$sqlfile.

Your answers should consist of SQL queries covered in this course $($in slides or introduced in class$).$

Each query will be evaluated as follows: correct $($full mark$),$ partially correct $($half mark$),$ or incorrect $($zero mark$).$ A query is considered correct if it produces the expected output from our test cases. The decision on whether a query is partially correct or incorrect will be made by the grader.

Before submitting, carefully verify that your SQL queries are executable and yield the correct output.

In addition to creating your own tables for testing, further methods for testing your SQL queries will be provided later.

$($I am checking whether the university supports specific database servers for you to connect to test your SQL queries, rather than providing you with the table creation code. Providing the table creation code will be a last resort if no other options are available. I will update for this soon.$)$

Important Notes:

The date format in Oracle is $"$dd MMM yyyy$"($e$.$g$.,"20$ Dec $2024").$ In MySQL$,$ it is $"$yyyy$-$mm$-$dd$"($e$.$g$.,"2024-12-20").$ Your answers should follow the Oracle standard.

Member$\_$Fee, Non$\_$Member$\_$Fee, Quota, etc., are numeric values.

The data type for Gender in the REGISTERED$\_$USER table is CHAR$(1),$ which can have a value of either $\text{'}$M$\text{'}$ for male or $\text{'}$F$\text{'}$ for female, and it cannot be NULL.