Show Bid Request
Database Questions (Piece of cake!)
Bid Request Id: 47758
|
|
|
|
Posted by: |
JustifySoul@ (13 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 0.00%
|
|
Posted: |
Feb 11, 2003
8:41:34 AM EDT
|
|
Bidding Closes: |
Feb 12, 2003
7:30:13 PM EDT
|
|
Viewed (by coders): |
177 times
|
|
Deadline: |
2/12/2003 8:00:00 PM
TIME EXPIRED
|
|
|
|
|
Description:
Your only MISSION, if you choose to accept it, is to just answer these following questions. Easy stuff! I have attached the database that you will need to use in order to answer them. Thank you...
1. List all the data for the attributes with names starting with 'F'.
2. List all the data for the attributes with names starting with 'F' or 'L'.
3. List allt he data for the attributes with names that have 'Encrypt' anywhere in it.
4. List the name and syntax of all attributes sorted first by the syntax, then the name.
5. List the LDAPName, the name and syntax sorted by the LDAPName.
6. Count the number of each syntax type.
7. List any description that occurs more than once.
8. For every Enumerator record, list what it Enumerates, its name, its value and its syntax(as joined from the Attributes table)(be careful to join on the correct columns. It is not Name and Name that you need to join on! It is the ID and what it Enumerates!)
9. For every Enumerator record, list what it Enumerates, its name, its value and its syntax(as joined from the Attributes table) Order the return by the value.
That is all you need to do is just answer these questions. Thoroughly.
Deliverables:
1) Complete all the questions. Answered in programing language. EX: SELECT *
FROM 'Wherever'
I hope you get the idea.
2) Please make sure that the answers are typed up on a document. Please email them to me VIA personal email as well. I have trouble sometimes getting the information through RentACoder. Please include it in a Word document.
3) Complete ownership and distribution copyrights to all work purchased.
Platform:
Please use the database that i have provided in order to answer all of these questions.
Must be 100% finished and received by buyer on:
Feb 12, 2003 8: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.
Special Conditions / Other:
Again, make sure that all the answers are typed out on a word document and please email them to me personaly as well. Thank you
This is easy stuff, an experienced Database Manger will see this as a piece of cake, so please, help me. And i gaurantee you a good rating. I'm sorry the bid does not seem at all appetizing, but it is very easy.
Why won't i do it myself then? Well, I can't stand this stuff!!! And i have no time.
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 |
|
|
|
|
$5 (USD)
|
Feb 11, 2003
10:24:34 AM EDT
|
9.84
(Excellent)
|
|
|
Hello.
I can answer your questions.
I have over 6 years of experience in work with VB, MS SQL Server and MS Access.
Thanks.
|
|
|
|
|
|
|
$5 (USD)
|
Feb 11, 2003
10:28:21 AM EDT
|
9.84
(Excellent)
|
|
|
Examples of my answers:
Q:
1. List all the data for the attributes with names starting with 'F'.
A:
SELECT Attributes.*
FROM Attributes
WHERE Name Like 'F*'
|
|
|
|
|
This bid was accepted by the buyer!
|
$5 (USD)
|
Feb 11, 2003
10:56:18 AM EDT
|
9.84
(Excellent)
|
|
|
For Access.
1. List all the data for the attributes with names starting with 'F'.
SELECT Attributes.*
FROM Attributes
WHERE Name Like 'F*'
2. List all the data for the attributes with names starting with 'F' or 'L'.
SELECT Attributes.*
FROM Attributes
WHERE Name Like '[FL]*'
3. List allt he data for the attributes with names that have 'Encrypt' anywhere in it.
SELECT Attributes.*
FROM Attributes
WHERE Name Like '*Encrypt*'
4. List the name and syntax of all attributes sorted first by the syntax, then the name.
SELECT Attributes.Name, Attributes.Syntax
FROM Attributes
ORDER BY Syntax,Name
5. List the LDAPName, the name and syntax sorted by the LDAPName.
SELECT Attributes.LDAPName, Attributes.Name, Attributes.Syntax
FROM Attributes
ORDER BY Attributes.LDAPName
6. Count the number of each syntax type.
SELECT Attributes.Syntax,COUNT(Attributes.Syntax)
FROM Attributes
GROUP BY Attributes.Syntax
7. List any description that occurs more than once.
SELECT Attributes.Description
FROM Attributes
GROUP BY Attributes.Description
HAVING COUNT(Attributes.Description)>1
8. For every Enumerator record, list what it Enumerates, its name, its value and its syntax(as joined from the Attributes table)(be careful to join on the correct columns. It is not Name and Name that you need to join on! It is the ID and what it Enumerates!)
SELECT Enumerators.Enumerates, Attributes.Name, Enumerators.Value, Attributes.Syntax
FROM Attributes INNER JOIN Enumerators ON Attributes.ID = Enumerators.Enumerates;
9. For every Enumerator record, list what it Enumerates, its name, its value and its syntax(as joined from the Attributes table) Order the return by the value.
SELECT Enumerators.Enumerates, Attributes.Name, Enumerators.Value, Attributes.Syntax
FROM Attributes INNER JOIN Enumerators ON Attributes.ID = Enumerators.Enumerates
ORDER BY Enumerators.Value
|
|
|
Attached File
|
|
|
|
|
|
UaCoder