Rent A Coder Alert: If you are receiving an error that says: 'page not found', or 'system could not find the file specified' on this site, it is caused by a bug in your browser. Please click here to fix it. (To disable this alert, click here).

    How Software Gets Done  
The RAC business office will be closed on Monday May 26, 2003 in observance of the United States holiday of Memorial Day. Please note that we will still approve bid requests and do phone verifications but they will only be done two times during the day, once in the morning and once in the late afternoon. We wish all celebrating Memorial Day a happy one. (current site time 5/24/2003 9:41:40 PM EDT)


(No Login on Secured Page)

Custom Software Buyers
Request new bids
Search Coders
My Account
 
My Buyer 'To Do' List
 
My bid requests
  My escrow account
 
My General Info
Verification
 
Help for Buyers
Articles for Buyers
FAQ for Buyers
Latest News
 

Custom Software Coders

Newest open work
Browse all work
Search all work
My Account
 
My Coder 'To Do' List
 
My bids
 
My General Info
  My credit account
 
Help for Coders
Articles for Coders
FAQ for Coders
Latest News
 

Affiliates

My account
 
My pipeline
 
My credit account
 
Help for Affiliates
Latest News
 
Newest Open Bid Requests.
Update dynamic ip using http tunnel
By cy on May 24
Max Bid: $40


XP Icons Needed
By CorporateWeb on May 24
Max Bid: $20


Email Extraction from Names
By franjavier on May 24
Max Bid: Open to fair suggestions


Company Logo
By Ghwerig on May 24
Max Bid: $50

(Screen Shot)

iPAQ printing facility (light)
By dev. printing for iPAQ on May 24
Max Bid: $220


broadband animated demo
By rik2 on May 24
Max Bid: $10


Click here to put this ticker on your own site

Open Work Categories.
Database 
(153 open)
   Access 
(58 open)
   MySQL 
(76 open)
   Oracle 
(8 open)
   SQL Server 
(59 open)
   Other DB 
(22 open)
Documentation / Tech Writing 
(19 open)
Data Entry 
(20 open)
Game Development 
(17 open)
Graphics / Art / Music 
(62 open)
   Graphics 
(67 open)
     3d Animation 
(21 open)
   Art (Misc.) 
(22 open)
   Music 
(17 open)
   3d Modeling 
(16 open)
Language Specific 
(113 open)
   ASP 
(62 open)
   ASP .NET 
(16 open)
   C# 
(32 open)
   C++ / C 
(105 open)
   Carbon (Mac OS) 
(3 open)
   Cocoa / Obj-C 
(1 open)
   Cold Fusion 
(8 open)
   Delphi 
(35 open)
   Java 
(56 open)
   JSP 
(4 open)
   Perl 
(38 open)
   PHP 
(88 open)
   XML/XSL 
(23 open)
   Visual Basic 
(136 open)
   Visual Basic .Net 
(58 open)
   Other 
(52 open)
Misc 
(36 open)
   CAD 
(5 open)
MultiMedia 
(41 open)
Network 
(38 open)
   Network Design 
(10 open)
   Network Implementation 
(11 open)
Platforms 
(69 open)
   Windows 
(150 open)
     MS Exchange 
(3 open)
     MS Office 
(14 open)
     Other 
(14 open)
   Darwin 
(3 open)
   Internet Browser 
(41 open)
   Linux 
(54 open)
   UNIX 
(30 open)
   Hand Held/PDA Programming 
(12 open)
Requirements 
(8 open)
Security 
(32 open)
Testing / Quality Assurance 
(15 open)
Web 
(168 open)
   Page Design 
(91 open)
   Flash 
(63 open)
   Web Services 
(76 open)
   Web (Other) 
(93 open)
Training 
(12 open)
   Computer Based 
(14 open)
 
Other
 
Other Sites

Download the free Rent A Coder IE toolbar!
 
Show Bid Request

Homework help
Bid Request Id: 14154
Bookmark in my 'To Do' list
Posted by: otteri_10 (3 ratings)
(Software buyer rating 10)
Non-action Ratio: Very Good - 0.00%
Posted: Apr 20, 2002
1:26:41 PM EDT
Bidding Closes: Apr 26, 2002
1:28:59 PM EDT
Viewed (by coders): 157 times
Deadline: 4/27/2002
TIME EXPIRED
Phase:
All funds have been escrowed. Waiting for work to be completed by coder.
Max Accepted Bid: Bidding is closed
Project Type: Personal Project / Homework Help
Bidding Type: Open Auction
Categories: Database, Java
Enter chat room for this bid request
(0 active users at May 24, 2003 9:41:40 PM EDT)

Description:
This is to done in SQLJ programming.

(1) Recreate the P table as an object table. Create an ACTIVES
table that contains all the S columns, as well as an SP
column that is a nested table of references to P records
(namely, the P records that are supplied by that supplier).

Load P and ACTIVES as follows:

Load P and ACTIVES as follows:

_____________________________
|P#|PNAME|COLOR|WEIGHT|CITY |
|__|_____|_____|______|______|
|P1|Nut |Red | 12 |London|
|P2|Bolt |Green| 17 |Paris |
|P3|Screw|Blue | 17 |Rome |
|P4|Screw|Red | 14 |London|
|P5|Cam |Blue | 12 |Paris |
|P6|Cog |Red | 19 |London|
|____________________________|


__________________________________________________________
|S# |SNAME|STATUS|CITY |SP |
|___|_____|______|_______|________________________________|
|S1 |Smith| 20 |London |references for P1,P2,P3,P4,P5,P6|
| | | | |records |
|S2 |Jones| 10 |Paris |references for P1,P2 records |
|S3 |Blake| 30 |Paris |reference for P2 record |
|S4 |Clark| 20 |London |references for P2,P4,P5 records |
|_________________________________________________________|


Code the following:

(a) a select statement that prints the entire part records
for parts supplied by S3.

(b) a select statement that prints all snum, pnum pairs such
that both the indicated supplier and the indicated part
are in London and the indicated supplier supplies the
indicated part.

(c) a select statement that prints the snums of suppliers
who supply a blue part that is stored in Paris.

(d) (i) a delete statement that deletes the P4 part from
the S1's SP set.
(ii) a select statement that prints the entire P records
that are referenced by S1's SP set.

(2) Redo (1), implementing SP as a varray of P records. The
deletion in (d)(i) is accomplished by a PL/SQL block that
contains a select into statement and an update statement.
(d)(ii) is still accomplished by a stand-alone select
statement that is not contained in a PL/SQL block.

(3) Redo (1), implementing SP as a varray of references to P
records.

(4) Redo (1), implementing SP as a varray of P#'s.





Deliverables:
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

Complete copyrights to all work purchased.


Platform:
unix, Oracle SQLPLUS

Must be 100% finished and received by buyer on:
Apr 27, 2002 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.

Special Conditions / Other:
Must be completed on time, no delays please.


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!
Jabaswavika
(0 ratings)
in Bangalore, Karnataka
India
Bid id: 156,356
 
$10 (USD) Apr 22, 2002
1:23:39 PM EDT
None Yet    
 
 
 
 
  See 4 private reply(ies)
to/from Jabaswavika.
 




Quick Search
 

 Advanced Search
Newest Open Work
Latest News

 
Credentials


 

 
Rent A Coder upholds the rigorous business practices required to be both a BBB member and Square Trade vendor.
  • All customer issues addressed within 2 days
  • Openly disclosed pricing and return policies
  • Participation in mediation at buyer request
  • Superior selling track record
This site is verified through its parent company, Exhedra Solutions, Inc.
 

Rent A Coder Top Coders.


Securenext
Rated a 9.98 on 99 jobs 
Anuj Gakhar
Rated a 9.98 on 92 jobs 
Codman
Rated a 9.97 on 145 jobs 
Buddies
Rated a 9.82 on 76 jobs 
Andrei Remenchuk
Rated a 10 on 12 jobs 
Michael Sharp
Rated a 9.98 on 179 jobs 
RNA
Rated a 9.92 on 37 jobs 
markesh
Rated a 10 on 22 jobs 
teleCODERS
Rated a 9.93 on 67 jobs 
hernest
Rated a 10 on 109 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers
 
Other
Rent A Coder is PayPal verified through its parent company, Exhedra Solutions, Inc.

Created in partnership with:

 


Affiliate Sites



Latest News | About Us | Kudos | Feedback/Contact    Affiliates | Advertise    Privacy | Legal

Copyright 2001, Exhedra Solutions, Inc. All rights reserved.
By using this site you agree to its Terms and Conditions.
"Rent A Coder" (tm), "Safe Project Escrow" (tm) and "How Software Gets Done" (tm)
are trademarks of Exhedra Solutions, Inc.