1. In AWS RDS, create a MySQL database instance (Free tier), following the recording pro-vided in Week3. (Set the inbound IP address to 0.0.0.0, which make it accessible from any- where) — attach a screenshot.
2. In AWS Cloud9, create an environment (Free tier instance, with Ubuntu 18.04 system), following the recording provided in Week 3. —attach a screenshot.
3. Connect the database instance in AWS RDS from Cloud9 environment, following the recording provided in Week 3. — attach a screenshot
4. After you connect to the MySQL database on RDS, create a database named hrdb (using SQL statement), use SQL statement to show databases. — attach a screenshot.
5. Create tables and load data into those tables using the “hrdb.sql” I provided in D2L, then use SQL statement to show tables. — attach a screenshot Hint: in mysql shell, “use hrdb;” “source hrdb.sql;”
6. Answer the following questions with SQL statements, and attach screenshots. (You need to provide SQL statements and screenshots of the results/part of the results) — use employees’ table.
0. Write a query to get a unique department ID from the employee table.
- Write a query to get all employee details from the employee table order by the first name, descending.
- Write a query to get the names (first_name, last_name), salary, PF of all the employees (PF is calculated as 15% of salary).
- Write a query to get the total salaries payable to employees.
- Write a query to get the number of employees working with the company.
- Write a query to display the name (first_name, last_name) and department ID of all employees in departments 30 or 100 in ascending order.
- Write a query to display the name (first_name, last_name) and hire date for all employees who were hired in 1987.
- Write a query to display the last name of employees having ’e’ as the third character.
- Write a query to get the maximum salary of an employee working as a Programmer.
- Write a query to get the average salary and number of employees working the depart- ment 90.