Update for SQL Server Database - StudentOfFortune.com

Question

Asked by:

Rating : No Rating
Questions Asked: 15
Tutorials Posted: 0

$15.00 Update for SQL Server Database

From Computer-Science: General-CS
Closed, but you can still post tutorials
Due on Jun. 08, 2009
Asked on Jun. 05, 2009 at 09:00:58AM

Q:
This is the updated requirements for my database:
Choose an EEO-1 Classification: Increase all employees salaries that have the selected EEO-1 classification by 8%.
· Increase all employees salaries by 2%.
· Choose an employee from the employee table; delete this employee.
Then, write SQL statements to:
-Calculate the average salary for all employees.
-Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees. This can be two separate statements.
-Calculate the maximum salary for all employees.
-Calculate the minimum salary for exempt employees and the maximum salary for non-exempt employees in a SINGLE SQL statement. Use subqueries to incorporate both elements in the query.
-Calculate the count of all male employees and count of female employees.

Attachments:
week3assignment.txt (9K)

Attachments:

Available Tutorials to this Question

Posted by:

Neel
Rating (255): C-
Questions Asked: 0
Tutorials Posted: 1644, earned $2,275.49

$15.00 Update for SQL Server Database

This tutorial hasn't been purchased yet.
Posted on Jun. 05, 2009 at 10:50:07AM

A:
Preview: ... udent, I h ...

The full tutorial is about 8 words long plus attachments.

Attachments:
sql_server.doc (28K) (Preview)

Posted by:

GojuZeus
Rating : No Rating
Questions Asked: 0
Tutorials Posted: 11, earned $9.00

$15.00 SQL Functions for mathemetical calculations

This tutorial was purchased 1 time and hasn't been rated yet.
Posted on Jun. 05, 2009 at 11:11:23AM

A:
Preview: ... SQL query format to be used is as follows: UPDATE TABLE SET COLUMN = # WHERE ITEM = 'Z' TABLE is the name of the table whose values you want to update, for example your Employee table. COLUMN = # can be replace by any sort of mathematical calculation. If you needed to increase a column's value by 5%, this would say COLUMN = COLUMN + COLUMN*0.5 . The Where statement allows you to specify which items you wish to increase. If you only wish to increase sales workers, it would say Where EEO-1 Classification = 'Sales Worker'. If you wish to update all items, you can leave the Where statement out. The very first question solution would be: UPDATE Employee SET Salary = Salary + Salary*0.8 WHERE EEO-1 Classification = 'Sales Worker' DELETE FROM TABLE WHERE COLUMN=TITLE This is the basic format of a deletion. You need to specify the table title (Employe ...

The full tutorial is about 709 words long plus attachments.

Attachments:
sqltutorial.txt (4K) (Preview)

Posted by:

akio
Rating (29): A-
Questions Asked: 0
Tutorials Posted: 130, earned $1,127.57

$15.00 Update statements and calculate statements tested for your SQL Server Databases

This tutorial was purchased 5 times and rated A by students like you.
Posted on Jun. 05, 2009 at 11:39:26AM

A:
Preview: ... hment. Any q ...

The full tutorial is about 9 words long plus attachments and additional clarification.

Attachments:
UpdateAndCalcuatePart.txt (1K) (Preview)