Learning Goal: I’m working on a databases multi-part question and need guidance to help me learn.

ER & Data Creation query files are attached, just answer these questions.

1. Write a query involving any two relations and translate it into a relational algebra expression.

2. Show visual explanation for the above querys execution plan.

3. Show how internally performs a Select statement for any relation.

4. Create an index for a column in any two relations.

5. Create a new user with a password.

6. Create two SQL triggers that must check condition in two relations.

No AI generated answers, please use APA when needed. Please use MySQL Workbench.