In Progress

Oracle and SQL project week 11+13

I need two projects completed. Emp+database script goes with the problems posted here. I also attached another assignment I need completed.

First Problem:Write a PL/SQL program to accomplish the following: Using the sample emp database, give everyone in dept 10 a 5% raise, everyone in dept 20 a 7.5% raise, everyone in department dept 30 a 10% raise. Do this using a simple IF...ELSE and a loop.

Second Problem:Modify the problem in #1 to meet the following criteria: IF dept is 10 and the salary is greater than 2000 give a 6% raise otherwise give a 7% raise. IF dept is 20 and the salary is greater than 2500 give a 5% raise otherwise give a 5.5% raise. IF dept is 30 and the salary is greater than 1000 give a 7% raise otherwise give a 6.5% raise.

Third Problem: Set up an inventory table and a transaction table that has sales, returns, and purchases (the transaction table should have a code with S for sales, R for returns and P for purchases). Create scripts to create and insert data into these tables.

Fourth Problem: Using the tables you created in the fourth problem, process the transactions and determine the impact on inventory. Display information that gives the original inventory and the inventory after the sales, returns and purchases have been processed. You need to use cursors.

Skills: Oracle, SQL

See more: sql to oracle, sql oracle pl sql, sql in pl sql, sql code oracle, raise oracle pl sql, pl sql in oracle, pl sql code sample, pl sql and oracle, pl sql and, oracle sql projects, oracle sql pl, information week, if oracle pl sql, for in pl sql, for i in oracle pl sql, code pl sql, 30 second scripts, sql r, sql in r, r sql, pl sql oracle, p sql, oracle sql with, in pl sql, sql projects

About the Employer:
( 23 reviews ) poop, United States

Project ID: #4461435

Awarded to:

sadeque

Lets Start.....

$88 USD in 7 days
(7 Reviews)
3.5

3 freelancers are bidding on average $99 for this job

rakib062

Please check private message.

$154 USD in 3 days
(6 Reviews)
3.4
bhaveshkhatarani

ready to start work now.

$55 USD in 1 day
(0 Reviews)
0.0