1. In AWS RDS, create a MySQL database instance (Free tier), following
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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.