Business Analytics Management Report Writing - IT/Computer Science Assignment Help

Assignment Task:

Task:

Description:

You are Simon, a data analyst, working for an online clothing company. You have just attended a human resource meeting in which it was decided that the company will implement a loyalty program. According to the loyalty program, the company will increase the salary of those employees who have worked for the company for ten (10) years or more. The pay rise is 15 percent. Therefore, your manager, John, has given you a task to prepare a list of the employees entitled to pay rise. Unfortunately, it appears that the company database doesn’t have the required information. Before you can give the requested list, you have to create an employee table and insert the following information: Employee ID (emp_id) Employee name (emp_name) Job title (job_title) Manager ID (manager_id) Hire date (hire_date) Salary (salary) Commission (commission) Department ID (dept_id) To do this, please follow the process described below. Stage 1 Download and install DBeaver Stage 2 Download and install MySQL Community Server Stage 3 Connect MySQL database to DBeaver Stage 4 Create a database named BAM_Exercise 1. Right-click your database

2. Select Create

3. Click Database

4. Name your database as “BAM_Exercise”

5. Click OK Stage 5 Create a table named “Employee” including the columns mentioned in the description.

1. From SQL Editor select New SQL Editor

2. Copy and paste the below script into the SQL Editor pane

3. Click the topmost arrow to execute the script

4. Save the script (from File click Save)

Question 1: Using the SQL exercise from Session 2 as a basis (available on the course site), repeat stages 1-6 but be sure to add yourself as an entry in the Employee table INSERT INTO BAM_Exercise.Employee ( emp_name, job_title, manager_id, hire_date, salary, commission, dept_id ) VALUES ( 'YOUR NAME', 'Data Chief', 68319, '2021-06-15', 8350.00, 1800.00, 2001 )

Question 2: Repeat stages 7-12. Modify stage 12 to give the following output. The first four rows are those who have been working for more than 10 years and whose new salary exceeds 4,000 euros. The last row refers to you. Since you have been recently hired you have to modify the script to generate a list (below) that includes you as well (see below).

The above  IT Assignment has been solved by our  IT Assignment  Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.