Business Analytics Management - What Lies Under the Hood - IT Assignment Help

Assignment Task

In-class exercise: Increasing the salary of your most experienced online employees
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 enti-tled 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

1. Right-click your database
2. Select Create
3. Click Database
4. Name your database as “BAM_Exercise”
5. Click OK

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)

This IT Assignment has been solved by our IT 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.