Select an employee from the employee table

Assignment Help Computer Engineering

Reference no: EM1336084

1. Database Tables

TABLE: Employees

Job_title_code
Social_security_number
Last_name
First_name
Address
City
State
Zip_code
Telephone_area_code
Telephone_number
Email_address
Hire_date
Salary

TABLE: Job_title

Job_title_code
Job_title
Exempt_non_exempt_status
Minimum_salary
Maximum_salary

2. Queries using the SQL SELECT statement.
(Note: Select all of the data from both of your tables before you perform the following)

A. Choose a job_title_code: Increase all employees' salaries that have: job_title_code by 10%.

B. Choose a job_title_code in the job_title table. Increase the Minimum_salary and Maximum_salary for this job_title_code.

C. Increase all employees' salaries by 5%.

D. Choose an employee from the employee table, delete this employee.

Reference no: EM1336084

Questions Cloud

Describe an organisational values and policies : Describe an organisational values and policies relevant to grievance, discipline and dismissal, identifying and the roles and responsibilities of individuals involved

Manager-s roles in a career management system : What are the manager's roles in a career management system? Which role do you think is most difficult for the typical manager?

Constant growth model with yearly compounding : Compute the 10-year growth rate forecast using the constant growth model with yearly compounding, and the constant growth model with continuous compounding for each occupation.

Explain marketing plan for internet commerce : Explain Marketing Plan for Internet Commerce and Develop the background information on the industry and identify a particular target market

Select an employee from the employee table : Choose a job_title_code in the job_title table. Increase the Minimum_salary and Maximum_salary for this job_title_code.

A simple cpm network : A simple CPM network

Show the potential impact to an organization : Show the potential impact to an organization that develops and implements a compensation and reward system that is perceived as being in the best interest of the organization, versus the best interest of the employees.

Potentially affected by the issue : What issue/topic is the article addressing? Who is potentially affected by the issue/topic?

Assume the government proposes to tax these benefits : Assume the government proposes to tax these benefits at the same rate as other types of income. What is the impact of the proposed tax on the optimal retirement age.

User Account

All Pages