Show Bid Request
Database Triggers
Bid Request Id: 54481
|
|
|
|
Posted by: |
rubz (4 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 20.00%
|
Buyer Security Verifications: |
Good
|
|
Approved on: |
Mar 24, 2003
10:07:16 PM EDT
|
|
Bidding Closes: |
Mar 26, 2003 EDT
|
|
Viewed (by coders): |
110 times
|
|
Deadline: |
3/26/2003
TIME EXPIRED
|
|
|
|
|
Description:
This project is bout creating some database triggers with SQL scripts..There is very tiny lil 3 problems on it..which i have to get done as soon as possible..like arround in 5-6 hours.This database triggers should work Under Oracle 8i or 9i with sqlplus.
Deliverables:
a)
Implement and test a statement trigger that verifies a consistency constraint:
“A truck cannot be used for two or more different trips on the same day”.
b)
Implement and test a row trigger that verifies the following consistency constraint:
“The values of attribute LEG# in TRIPLEG table must be contiguous, i.e. 1,2,3,4 … for
each trip”.
c)Implement SQL script that adds to a relational table TRUCK an attribute TOTMTIME
(TOTal Maintenance TIME) and sets the values of the attribute consistent with the
current contents of the database. Attribute TOTMTIME should contain information about
the total time of all maintenance tasks performed on each truck. If a truck has not been
maintained so far set the appropriate value of TOTMTIMT to zero.
Implement and test a trigger that automatically updates the values of TOTMTIME
whenever it is necessary.
Platform:
Should work on Oracle 8i or 9i with SqlPlus.
A file named "a1create.sql" has got all the tables thats needed to get goin with the database is includin on the zip file.
Must be 100% finished and received by buyer on:
Mar 26, 2003 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
This bid was accepted by the buyer!
|
$15 (USD)
|
Mar 25, 2003
9:23:51 PM EDT
|
9.6
(Excellent)
|
|
|
Hi Rubz,
I would be happy to help you out with your request.
To fill you in a little, I have
been developing Oracle applications for over 10 years now. I specialize in writing SQL and PL/SQL code.
I am certified through Oracle's OCP program, as well as ExpertRating's. I have also successfully completed several SQL and PL/SQL projects through RentACoder.
Looking forward to hearing from you.
-OraDev |
|
|
|
|
|
|