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.