|
Post by corbinp on Oct 30, 2012 17:39:05 GMT -5
One of the queries states:
List the average cost of a project
Maybe this is obvious to others, but I need a little bit of clarification for this query. I know it has to do with the amount spent on a project, but I'm not sure where the average part comes in, as there is only 1 value in consideration.
If someone could clarify this, I would appreciate it.
Thanks
Corbin
|
|
|
Post by Bob P on Oct 30, 2012 17:42:29 GMT -5
There is one value now but in the future there could be more. Can you your system deal with that situation? Bob
|
|
|
Post by corbinp on Oct 30, 2012 18:27:29 GMT -5
I see, thank you for the prompt response
|
|
adm88
New Member
Posts: 10
|
Post by adm88 on Oct 30, 2012 20:15:37 GMT -5
Wait how there is one value? There are four projects, so you have four different values. Aren't we supposed to write a statement that shows an average budget for these four projects?
|
|
|
Post by corbinp on Oct 30, 2012 20:20:39 GMT -5
thats what i had thought, but the statement asks for the average of A project, assuming just one
|
|
|
Post by Bob P on Oct 30, 2012 20:31:50 GMT -5
I looked through some of the HW's and not everyone is dealing with the ambiguity that exists in this homework. This is real life - often times data is not uniform. How is manager supposed to know what TBA will be working on a project means? And what does it mean to list the average cost of a project - what would be the most useful? Do you think your interface could help explain how your queries are working. Nobody has a guide, user manual or explanation of their queries - I think most of you are missing the point because you are being so "technical".
Bob
|
|