How Software Gets Done  


Login

Software Buyers
Request bids
Search coders
My Buyer Account
Buyer help
Buyer articles
Buyer FAQ
Latest news
 
Software Coders
Newest open work
Browse all work
Search all work
My Coder Account
Coder help
Coder articles
Coder FAQ
Latest news
 
Affiliates
My Affiliate Account
Affiliate help
Affiliate FAQ
Latest news
 
Newest Bid Requests.
C# form designer (repost)
By SC Development on Jul 10
Max Bid: Open to fair suggestions


Game Written
By Will867 on Jul 10
Max Bid: Open to fair suggestions


Running Windows and Macintosh programs on Linux
By stevenkurt on Jul 10
Max Bid: $1,000


application form sender
By kaveh7 on Jul 10
Max Bid: $35


Javascript Editor/IDE
By rehlik242 on Jul 10
Max Bid: $1,000


Flash Cartoon Series about shopping - just for fun
By XFile on Jul 10
Max Bid: Open to fair suggestions


Click here to put this ticker on your own site and/or get live RSS newsfeeds

Open Work Categories.
Database 
(137 open)
   Access 
(50 open)
   MySQL 
(82 open)
   Oracle 
(8 open)
   SQL Server 
(44 open)
   Other DB 
(17 open)
Documentation / Tech Writing 
(13 open)
Data Entry 
(19 open)
Game Development 
(23 open)
Graphics / Art / Music 
(42 open)
   Graphics 
(47 open)
     Adobe AfterEffects 
(1 open)
     Adobe Photoshop 
(12 open)
     Adobe Premiere 
(3 open)
     3d Animation 
(13 open)
   Art (Misc.) 
(16 open)
   Music 
(12 open)
   3d Modeling 
(13 open)
Language Specific 
(93 open)
   ASP 
(52 open)
   ASP .NET 
(33 open)
   C# 
(43 open)
   C++ / C 
(105 open)
   Carbon (Mac OS) 
(2 open)
   Cocoa / Obj-C 
(2 open)
   Cold Fusion 
(10 open)
   Delphi 
(27 open)
   Java 
(54 open)
   JSP 
(8 open)
   Perl 
(40 open)
   PHP 
(82 open)
   XML/XSL 
(28 open)
   Visual Basic 
(133 open)
   Visual Basic .Net 
(52 open)
   Other 
(54 open)
Misc 
(31 open)
   CAD 
(3 open)
MultiMedia 
(36 open)
   Video Editing 
(4 open)
Network 
(43 open)
   Network Design 
(12 open)
   Network Implementation 
(14 open)
Platforms 
(74 open)
   Windows 
(154 open)
     MS Exchange 
(6 open)
     MS Office 
(13 open)
     Other 
(16 open)
   Darwin 
(1 open)
   Internet Browser 
(37 open)
   Linux 
(62 open)
   UNIX 
(27 open)
   Hand Held/PDA Programming 
(9 open)
Requirements 
(13 open)
Security 
(28 open)
Testing / Quality Assurance 
(16 open)
Web 
(143 open)
   Page Design 
(75 open)
   Flash 
(35 open)
   Web Services 
(66 open)
   Web (Other) 
(74 open)
Training 
(12 open)
   Computer Based 
(11 open)
Other
 
Other Sites

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

Creating queries (database)
Bid Request Id: 14680
Bookmark in my 'To Do' list
Posted by: Mohammed khan (7 ratings)
(Software buyer rating 10)
Non-action Ratio: Very Good - 7.69%
Buyer Security Verifications: Good
Approved on: Apr 26, 2002
2:33:38 PM EDT
Bidding Closes: Apr 30, 2002
2:36:10 PM EDT
Viewed (by coders): 300 times
Deadline: 5/1/2002
TIME EXPIRED
Phase:
100% of work completed and accepted. Coder has been paid.
Max Accepted Bid: Bidding is closed
Project Type: Personal Project / Homework Help
Bidding Type: Open Auction
Categories: Database
Enter chat room for this bid request
(0 active users at Jul 10, 2003 10:47:28 AM EDT)

Description:
Create all necessary tables based on the schema shown on the following page.

b. Prepare a relational schema diagram for the database shown on the following page.

c. Populate the tables with the data shown on the following page and some of your own.

d. Perform the following queries:

1. Retrieve, in alphabetic order, the name and address of all employees who work for “Research” department.

2. List the names of all employees who have a dependent with the same first name as themselves.

3. For every project located in “Stafford”, list the project number, the controlling department number, and the department manager&'s name,
address, and birthdate.

4. Retreive the name of employees who work on every project.

5. Find the names of employees who work on all the projects controlled by department number 5.

6. Make a list of project numbers for projects that involve an employee whose last name is ‘Smith&', either as a worker or as a manager of the department that controls the projects.

7. List the names of all employees with two or more dependents.

8. Retrieve the names of employees who have no dependents.

9. List the names of employees who have at least one dependent.

10. Find the number of employees whose salary is above the average salary.


e. Perform one of the above queries using either PL/SQL or Embedded SQL.



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.

SEE ATTACHED FILE FOR ALL THE DESCRPTION

Platform:
Oracal 8i

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

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!
OraDev
(5 ratings)
in Wilmington, Massachusetts
United States
Bid id: 160,570
This coder is certified! Click here for transcript
 
$10 (USD) Apr 26, 2002
9:14:38 PM EDT
 9.6
(Excellent)
   
I definitely have the expertise to complete your request in a timely fashion. I have extensive experience using PL/SQL, and I take my work very seriously. Looking forward to hearing from you.
 




Quick Bid Request 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.
 
Top Coders.

Anuj Gakhar
Rated a 9.98 on 100 jobs 
Securenext
Rated a 9.96 on 109 jobs 
Buddies
Rated a 9.82 on 80 jobs 
Andrei Remenchuk
Rated a 10 on 13 jobs 
Codman
Rated a 9.97 on 149 jobs 
Michael Sharp
Rated a 9.97 on 181 jobs 
D-N-S
Rated a 9.93 on 37 jobs 
markesh
Rated a 10 on 22 jobs 
teleCODERS
Rated a 9.93 on 67 jobs 
Tometa Software, Inc.
Rated a 10 on 10 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.