Em Andamento

homework

Home work project that is to be done in 5 steps with full documentation including design and internal comments on each of the 5 steps. The project starts small and keeps building upon it until all the requirements are met. This is for a beginning T-Sql class so it should be fairly simple.

Part 1

Create a T-SQL database that has 2 tables;

a. One table is employee information and contains the

employees SSN,Name,Adderess,Telephone,Email,Job

Title code,Hire Date, Salary

b. Second table is job title information and contains job

title code,job title,exempt/non-exempt status,minimum

salary, maximum salary

c. Enter 10 employees and 5 job titles into the tables

d. Use CREATE TABLE and CREATE DATABASE commands

e. write a brief summary describing the business

requirements for this project

Part 2

Write 3 T-SQL queries

a. The first query joins the two tables in the database

and uses BETWEEN to restrict record selection

b. The second query joins the two tables in the database

and uses LIKE to restrict record selection

c. The third query uses UNION of the two tables to

produce a result set. Creating a table similar to the

Employee Table, but which contains contractors.

## Deliverables

Add 3rows to the new table make sure the SSN

numbers are different than those in the Employee table.

Use the UNION to create a result set of all employees

and contractors include the SELECT lists, a literal

identifying the individual as an employee or

contractor

d. Prepare a report showing the the T-SQL statements

and the results

e. Prepare a brief summary describing the project design

and ER diagram

Part 3

Using T-SQL add 10 more employees to the database,

include one T-SQL INSERT statement in the code.

a. First, group rows by job title, providing counts of

employees for each title.

b. Then group rows by city, providing average salary for

each city

c. Then group rows by exempt/non-exempt status,

providing the highest and lowest employee salary

for each group.

d. Use functions and sub queries

e. Prepare a report showing T-SQL statements and

results.

f. Prepare a brief summary describing the attendant data

retrieval required. Including possible T-SQL instuctions

that may be used and why you would consider them.

Part 4a

Using a CREATE statement, generate a "Terminated

Employees" table having the same columns as the

Employees table

a. Add 5 employees to the new table

b. Using a UNION statement, create a result set of both

of both active and terminated employees, providing

names, job titles, salaries, and an indicator of active

or terminated.

c. Prepare a SELECT statement with a sub-select (rather

than a JOIN) to calculate the average salary for

exempt employees and provide an additional column

containing the literal "Exempt"

d. Prepare a report showing the T-SQL statements and

results.

Part 4b

Construct a prototype of the project database, load it with

several records demonstrating how data will be processed

and accessed in the application. Include at least one

UPDATE statement

Part 5

Create a complete T-SQL database combining all the

previous steps and commands

a. add stored procedures

b. use CURSORS

c. use TRIGGERS

## Platform

Windows 2000 and XP

Habilidades: Administração de Bancos de Dados, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: update prototype, union first, the select group, the prototype part 1, steps to write a report, set union, salary exempt, salaries, prototype update, prototype part 3, prototype part 2, prototype part 1, prototype engineering for hire, prototype diagram, prototype date, non exempt employees, non exempt employee, non exempt, new hire procedures, it job titles, how to write a summary report, how to write a report for homework, how to produce a prototype, how to make a prototype, how to hire employees

Acerca do Empregador:
( 3 comentários ) United States

ID do Projeto: #3023926

Premiar a:

TakeReal

See private message.

$25.5 USD em 7 dias
(1269 Avaliações)
7.5

12 freelancers are bidding on average $36 for this job

hasnut

See private message.

$51 USD in 7 dias
(157 Comentários)
6.4
saadrahmanvw

See private message.

$51 USD in 7 dias
(23 Comentários)
4.4
shashikhanvw

See private message.

$46.75 USD in 7 dias
(15 Comentários)
3.8
tzunivw

See private message.

$17 USD in 7 dias
(26 Comentários)
2.9
borninleningrad

See private message.

$25.5 USD in 7 dias
(5 Comentários)
2.9
codebased

See private message.

$34 USD in 7 dias
(6 Comentários)
2.6
ivanner

See private message.

$51 USD in 7 dias
(5 Comentários)
1.7
georganoss

See private message.

$34 USD in 7 dias
(3 Comentários)
0.0
ovidiuconsta

See private message.

$42.5 USD in 7 dias
(0 Comentários)
0.0
thenanny

See private message.

$8.5 USD in 7 dias
(0 Comentários)
0.0
frankjuszli

See private message.

$46.75 USD in 7 dias
(0 Comentários)
1.4