Help with a small PL/SQL database script (Oracle)

In Progress

Description

All of the tables for the system have been created, however I need a PL/SQL programmer to make changes to the code to ensure that when the data is entered and queried in SQL that the following restrictions are in place:

* Let the user know when the are no more vacancies available.

* Ensure that the double booking of rooms in the hotel will not be possible.

*Apply discounts to customers bills that book into the hotel frequently.

* Prevent any double bookings of hotel rooms

* Let the user know when the hotel's inventory/stock is running low, and prompt it to be re-ordered by a emmployee from a supplier (all tables included)

Therefore I need a PL/SQL programmer that knows about triggers, functions, procedures e.t.c to include these in.

Finally, the database should be able to answer basic queries, such as details on staff in a specific branch, which staff have booked customers in and where e.t.c

It should take approximately 1-2 hours for a PL/SQL coder to do this task and it is of high importance so I believe a rate of $25/hr is fair. Ideally, I want this completed as soon as possible so may pay extra for professional programmers and database experts.

***All code should be able to compile,***

If you have any questions please message me before bidding.

Thanks

Skills: MySQL, Oracle, SQL, UML Design

See more: script oracle database, oracle small script, with no restrictions, vacancies programmer, uml task, uml for sql, uml 1.2, sql to oracle, sql oracle pl sql, sql inventory system, sql in pl sql, sql database programmer, sql code oracle, programmer sql, programmers help, programmers database, procedures in oracle pl sql, procedures and functions in pl sql, procedures and functions in oracle, pl sql programmer, pl sql in oracle, pl/sql functions and procedures, pl sql functions and procedures, pl sql and oracle, pl sql and

Project ID: #2792939

21 freelancers are bidding on average $71 for this job

SharpMinds007

Hi I am a Oracle Certified PL/SQL Developer and would like to do this for you. Regards

$95 USD in 2 days
(99 Reviews)
5.5
diegogarcia0531

Hi, I can do the job

$100 USD in 0 days
(17 Reviews)
5.0
SCKRamana

I worked extensively in DBA all type quarry.thanks

$50 USD in 0 days
(25 Reviews)
4.6
gadgetmannz

Hi, I am a professional database developer with over 20 years experience in I.T., with the last 10 focusing on Oracle and SQL solutions. I have worked extensively with Oracle 11g including the creation of advanced que More

$65 USD in 3 days
(1 Review)
3.4
nishprojects

Please check your private message.

$70 USD in 1 day
(2 Reviews)
2.7
kkolukul

Having 7 yrs of experience in Oracle DB, sql, PLSQL. Can finish your work in good quality and time.

$100 USD in 1 day
(2 Reviews)
2.6
YankoNik

Dear Sir, I'm a Sql expert with more then 8 years experience.

$45 USD in 3 days
(11 Reviews)
2.5
ayaz12

Hello Sir! Plz Check PMB for detail. Thanks.

$100 USD in 1 day
(4 Reviews)
2.2
zhsoftstudio

Hello semicoder, I have a PL/SQL experience. Ready to start your project. Thanks.

$100 USD in 2 days
(1 Review)
1.6
hitgon

I can help you.

$50 USD in 2 days
(1 Review)
1.0
muhoilya

Hi, I can do your work I'm an expert in plsql(Oracle). Let me know if you are interested.Thanks

$30 USD in 1 day
(0 Reviews)
0.0
jhenidahinfotech

Dear Sir, I am working with SQL, Oracle PL SQL for the last 6+ years so i can provide your solutions easily. Thanks.

$50 USD in 2 days
(0 Reviews)
1.6
SahilDoda87

Hi, I can do this job efficiently. I am very confident of doing it as I have done a lot of such assignments. Please reply if you are interested. Sahil Doda

$50 USD in 2 days
(0 Reviews)
0.0
kingbrave

I can do this job,I have over ten year experience,similiar with oracle,procedure,function,etc

$50 USD in 2 days
(0 Reviews)
0.0
tapsinha

I Can do the job with my 7 years of PL/SQL experiance.

$70 USD in 2 days
(0 Reviews)
0.0
mrjackie

Let me help you!

$80 USD in 3 days
(0 Reviews)
0.0
samyaktech

Sent you my skillset.

$100 USD in 1 day
(0 Reviews)
0.0
sahaansh

Hello sir, i am having great knowledge regarding this project which is using oracle.

$65 USD in 1 day
(0 Reviews)
0.0
shtock

The goals of the project are clear and my skills in that kind of project are rather strong to deliver what you need in time and in budget.

$100 USD in 2 days
(0 Reviews)
0.0
yilmazbilge

I am a new freelancer but experienced PL/SQL developer ;)

$50 USD in 1 day
(0 Reviews)
0.0