Show Bid Request
MS Access and SQL
Bid Request Id: 60450
|
|
|
|
Posted by: |
Jennagrace (2 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 0.00%
|
|
Posted: |
Apr 29, 2003
8:09:12 PM EDT
|
|
Bidding Closes: |
May 1, 2003
8:12:24 PM EDT
|
|
Viewed (by coders): |
321 times
|
|
Deadline: |
5/4/2003
TIME EXPIRED
|
|
|
|
|
Description:
This project must be separated into four parts:
Part One
1. Create a Microsoft Access database that has two tables.
2. One table is employee information and contains the employee&'s social_security_number, name, address, telephone, email_address, job_title_code, hire_date and salary. Note: Do NOT use real employees and social security numbers.
3. The second table is job title information and contains job_title code, job_title, exempt or non-exempt status, minimum_salary and maximum_salary.
4. Enter 10 employees and five job titles.
Part 2
1. Using SQL, add 10 more employees to your database using SQL.
2. First, group employees by job code.
3. Then group employees by salary.
4. Then group employees by salary within job code.
5. Post the SQL statements and the results.
Part 3
Using SQL:
Group employees by salary within job titles that are grouped into exempt and non-exempt. Note: The words 'Group employees' indicate Employees (names) should be part of the result set.
Then use UNION to create a third table of employee names, job titles and salary. Print out SQL statements and the results.
Part 4
Using SQL:
1. Calculate the average salary for exempt employees and the average salary for non-exempt employees.
2. Post the SQL statements and the results.
Deliverables:
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.
Platform:
Windows 98/2000/XP
Must be 100% finished and received by buyer on:
May 4, 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.
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!
|
$20 (USD)
|
Apr 29, 2003
11:25:01 PM EDT
|
10
(Excellent)
|
|
|
| Hey, this sounds like a simple project to complete for you. I'm very good at programming SQL and working with Access database. And would like to work with you again on this project. I can have this done for you, before you deadline so you can test it out and make any adjustments and also ask any questions that you may need to ask me.
Thanks,
Randy |
|
|
|
|
|
|
