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

IN PROGRESS
Bids
21
Avg Bid (USD)
$71
Project Budget (USD)
$30 - $250

Project 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 required:
MySQL, Oracle, SQL, UML Design
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 95
in 2 days
$ 100
in 0 days
$ 70
in 1 days
Hire kkolukul
$ 100
in 1 days
Hire YankoNik
$ 45
in 3 days
$ 100
in 1 days
$ 50
in 0 days
Hire zhsoftstudio
$ 100
in 2 days
Hire hitgon
$ 50
in 2 days
Hire kingbrave
$ 50
in 2 days