In AWS RDS, create an 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 record- ing provided in Week 3. attach a screenshot

4. After you connect to the MySQL database on RDS, create a database named hrdb (us- ing 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.

1

1. Write a query to get unique department ID from employee table.

2. Write a query to get all employee details from the employee table order by first name, descending.

3. Write a query to get the names (first_name, last_name), salary, PF of all the employees (PF is calculated as 15% of salary).

4. Write a query to get the total salaries payable to employees.

5. Write a query to get the number of employees working with the company.

6. 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.

7. Write a query to display the name (first_name, last_name) and hire date for all employees who were hired in 1987.

8. Write a query to display the last name of employees having e as the third character.

9. Write a query to get the maximum salary of an employee working as a Programmer.

10. Write a query to get the average salary and number of employees working the depart- ment 90.