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.

Beceriler: Oracle, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 23 değerlendirme ) poop, United States

Proje NO: #4461435



Lets Start.....

%selectedBids___i_period_sub_7% gün içinde 88%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(7 Değerlendirme)

3 freelancers are bidding on average $99 for this job


Please check private message.

in %bids___i_period_sub_35% gün içinde154%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

ready to start work now.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)