Posted: March 7th, 2014

POS 410 Week 4 SQL Reports

REQUIRED: Prepare ALL Code per the Coding Standards document.  Refer to the handout located in the Handouts and Extras thread – Coding Standards for POS 410 – before proceeding with this assignment.

Need a Professional Writer to Work on this Paper and Give you an A+ 100 % Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN

Optional: Read the Week 4 Handouts in the Course Materials Forum.

 

Optional:  Complete the Week 4 Learning Activity Tutorials in the Main Forum to assist.

 

Use the database and tables from previous week’s assignment.  Write SQL queries using the SQL SELECT statement.

 Need a Professional Writer to Work on this Paper and Give you an A+ 100 % Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN

 

NOTE:  One SQL Query contains only one SELECT statement and only one FROM statement and may use other statements and clauses to complete the query.  See sample queries in the Course Materials forum.

 

 

 

REQUIRED:  Use Each Assignment Request Below As The “Comment” For Each Query. Copy and paste the Assignment request between 2 multi-line comment indicators.  A multi-line comment indicator is a slash and an asterisk – the comments – and then an asterisk and slash:   /*comments*/:  Example:  /* Assignment Request: Write one SQL Query to Increase all employees’ salaries with the selected Job Class by 5.375%.   (You select the Job Class of your choice.)*/

 

REQUIRED: Take a screen shot showing each query code set in the current screen and results of the query.  There should be 7 separate screen shots including before and after updates and deletes screen shots.

 

1.     Assignment Request:Write one SQL Query to Increase all employees’ salaries with the selected Job Class by 6.175%.   (You select the Job Class of your choice.)

 

2.     Assignment Request:Write one SQL Query to Increase all employees’ salaries by 3.875%.

 

3.     Assignment Request:Write one SQL Query to Delete employee:  Dorsett Andrews by Employee ID, First Name and Last Name.

 

 

Use the database and tables from previous week’s assignment and after the above updates to the database to write SQL statements that do the following:

 

 

Write Queries: 

 

 

 

REQUIRED:  Use Each Assignment Request Below As The “Comment” For Each Query. Copy and paste the Assignment request between 2 multi-line comment indicators.  A multi-line comment indicator is a slash and an asterisk – the comments – and then an asterisk and slash:   /*comments*/:  Example:  /* Assignment Request: Write one SQL Query to Increase all employees’ salaries with the selected Job Class by 5.375%.   (You select the Job Class of your choice.)*/

 

 

REQUIRED: Take a screen shot showing each query code set in the current screen and results of the query.  There should be 7 separate screen shots.

 

 

REQUIRED:ALL queries must return results that fit the query request.  When 3 tables are joined, then all the data must be displayed for all three tables.  The number of records will differ depending on the type of join used.

 

1.     Assignment Request: Write one SQL Query to Calculate the average No. of Exemptions for all employees. (Output shows Alias)

 

2.     Assignment Request: Write one SQL Query to Calculate the average Age for all employees. (Output shows Alias)

 

3.     Assignment Request: Write one SQL Query to Calculate the maximum salaries for employees by Job Classification. (Output shows Alias)

 

4.     Assignment Request: Write one SQL Query to Calculate the maximum salary for all employees. (Output shows Alias)

 

5.     Assignment Request: Write one SQL Query to Calculate the minimum salaries for Employees by Job Title. (Output shows Alias)

 

6.     Assignment Request: Write one SQL Query to Calculate the minimum salary for all employees. (Output shows Alias)

 

 

7.     Assignment Request: Write one SQL Query to Count all employees and GROUP BY Age and Gender. (Output shows Alias)

Need a Professional Writer to Work on this Paper and Give you an A+ 100 % Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN

DUE MONDAY!     WHAT TO SUBMIT:

Ø

Submit the Assignment to the Assignments Page of eCampus.

 

Review the Week 4 Grading Rubric to ensure that all parts of the deliverable for Week 4 have been included.

 

• One (1) NOTEPAD text file will all required code correctly commented per instructions.

Ø

o    All SQL Code joining tables, Increasing salaries & deleting specified employee properly formatted per the Coding Standards document

o    All SQL Code for aggregate functions properly formatted per the Coding Standards document

o    All SQL Code Selecting all tables with updated information properly formatted per the Coding Standards document

Ø

• One (1) word document with all screen shots labeled

o    Screen shots showing each successful implementation of code

o    Screen shots of table output after increases

Ø

• Certificate of Originality

 

Ø  NOTE:  There will be a minimum of 15 screen shots required for this assignment

Need a Professional Writer to Work on this Paper and Give you an A+ 100 % Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN