Google Answers Logo
View Question
 
Q: Question in writing a VERY simple queries and a negation theory question ( No Answer,   2 Comments )
Question  
Subject: Question in writing a VERY simple queries and a negation theory question
Category: Computers > Programming
Asked by: snowtime-ga
List Price: $15.00
Posted: 14 Sep 2004 17:06 PDT
Expires: 16 Sep 2004 20:18 PDT
Question ID: 401262
Please help me answer the question below:

For each of the following schema, write four meaningful queries: one
that uses conjunction (the upward arrow sign), one that uses
disjunction, (the downward arrow sign, one that uses negation, and one
that uses a combination of operators)

1) account = (id*, amount_due, due_date)

a)
b)
c)
d)

2) Sales_item = (id*, description, amount_in_stock, cost, selling_price)

a)
b)
c)
d)

I need this answered by Thursday morning at the latest, and I will run
it by my computer science professor for accuracy.  Also I am willing
to give a very generous tip if the question is answered to my
satisfaction and in a timely manner.

Also as a bonus question (for extra tip) I would just like a bit of
theory answered as it relates to the negation symbol

if I have a question like the following (i am substituting words for
their counterpart symbols):

negation (F Conjuction T ) 

 the answer would be true but the conjunction symbol would stay the
same (it wouldn't change to disjunction. Correct?

negation ( y > z ) 

the answer would change to y < z and the greater than would change to
less than or equal to. Right??    -

The theory question then is, why doesn't the symbol change in the
first problem, but changes in the second problem. (is this order of
operation or what). I know its pretty simple but I'm a computer
programming neophyte and therefore could use a thorough yet simplistic
answer.


                           Regards,

Collin
Answer  
There is no answer at this time.

Comments  
Subject: Re: Question in writing a VERY simple queries and a negation theory question
From: dreamboat-ga on 14 Sep 2004 17:20 PDT
 
There are probably 500 different programs in which queries can be
written. Care to let us know which one it is you're studying?
Subject: Re: Question in writing a VERY simple queries and a negation theory question
From: snowtime-ga on 16 Sep 2004 00:08 PDT
 
This was just an assignment given by the professor and as such is just
theoretical, meaning that there isn't a real program attached to it,
this question is still open until 6:00 PM EST. And the tip will be
GOOD if someone answers it.

Thanks all,

Collin

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy