Query implementations 1. 2. Write different queries, give SQL translations of them, and indicate their implementation and solutions. Create Data Queries as follows: Data update/deletion: List 2 different delete queries related to your tables. List 2 different update queries related to your tables. Data Retrieval (Select) Queries: List 2 simple select queries related to your tables. List 2 nested queries related to your tables. List 2 simple join queries related to tables. List 2 simple retrieval queries using group by, having clause, and aggregation functions. Views: List 2 different views, give SQL translations of them. 9 1. 2. 3. to your 4. IS Department User Interface Create a simple user interface for your database application. The user interface should include interface to the queries and views you created for the database. You can use any programming language or Oracle's application developer for creating the user interface. Query implementations 1. 2. Write different queries, give SQL translations of them, and indicate their implementation and solutions. Create Data Queries as follows: Data update/deletion: List 2 different delete queries related to your tables. List 2 different update queries related to your tables. Data Retrieval (Select) Queries: List 2 simple select queries related to your tables. List 2 nested queries related to your tables. List 2 simple join queries related to tables. List 2 simple retrieval queries using group by, having clause, and aggregation functions. Views: List 2 different views, give SQL translations of them. 9 1. 2. 3. to your 4. IS Department User Interface Create a simple user interface for your database application. The user interface should include interface to the queries and views you created for the database. You can use any programming language or Oracle's application developer for creating the user interface.