Show Bid Request
Homework HELP! Simple SQL Access Queries
Bid Request Id: 55412
|
|
|
|
Posted by: |
GenXcoder (8 ratings)
(Software buyer rating 9.25 )
|
|
Non-action Ratio: |
Very Good - 8.33%
|
Buyer Security Verifications: |
Good
|
|
Approved on: |
Mar 30, 2003
11:40:35 AM EDT
|
|
Bidding Closes: |
Mar 31, 2003
12:00:00 PM EDT
|
|
Viewed (by coders): |
198 times
|
|
Deadline: |
3/31/2003 3:00:00 PM
TIME EXPIRED
|
|
|
|
|
Description:
I need some help with my homework that I'm running behind with; I've been working too much! I have an Access database that I've comleted, but I need someone to help me run some simple SQL queries on it.
Deliverables:
1)Create a query called Billing to allow San Diego to list the Lease and Boat information for each customer. The query should provide the information listed below (NOTE: Please see attached zip file for pictures of finished queries).
2)For all Equipment list the LeaseID, LeaseDate, LengthOf Lease, and if there is a customer assigned to Note: Not every lease will have a customer. Create a query name Lease_Report that uses an outer join to provide this data (NOTE: Please see attached zip file for pictures of finished queries).
3)Query: San Diego wants to know all the scheduled maintenance that was assigned to a boat. Order by BoatID (NOTE: Please see attached zip file for pictures of finished queries).
4)Query: For scheduling purposes San Diego want to list all employees that are scheduled to work on a Lease (NOTE: Please see attached zip file for pictures of finished queries).
5)Query: San Diego is finishing up the end of the year auditing so they want you to Create a Query that will list all of the BoatId, BoatYear, BoatSize, Color and LeaseID, LeaseDate, and LengthOfLease. Order by LeaseID (NOTE: Please see attached zip file for pictures of finished queries).
6)Report: San Diego wants to have a printout of the query produced in # 5 use the same fields to create a report. Sort by LeaseID.
------------------------------------------------------
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Complete ownership and distribution copyrights to all work purchased.
Platform:
Windows 9x, NT
Must be 100% finished and received by buyer on:
Mar 31, 2003 3:00:00 PM 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!
|
$4 (USD)
|
Mar 30, 2003
12:16:20 PM EDT
|
9.95
(Excellent)
|
|
|
Hello!
It's looks like test :-)
I can accomplish your task in next 2-3 hours.
--
Sergey |
|
|
|
|
|
|