Introduction to database | Computer Science homework help

Homework Help

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.

Continue to order Get a quote

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.