Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Counting propositions

Re: Counting propositions

From: x <x-false_at_yahoo.com>
Date: Fri, 18 Jun 2004 14:11:39 +0300
Message-ID: <40d2cceb$1@post.usenet.com>

"Tony" <andrewst_at_onetel.net.uk> wrote in message news:c0e3f26e.0406180226.5b4153a0_at_posting.google.com...

> > You see, there might be a relational database that has no named
> > relation/relvar that (directly) assert employment.
>
> A badly designed, and probably un-normalised, database I would suggest
> ;-)

Well, you cannot always choose the design :-) Why unnormalized ?

> > It works only when you count Emp_IDs, not the propositions employing
Emp_IDs
> > :-)
>
> No, it always works when you count propositions whose intention is to
> state the existence of an employee. Of course it doesn't work if you
> count propositions about project assignment or the employees' CD
> collections etc.!

In order to count propositions whose intention is to state the existence of an employee, you rely on Emp_IDs one-to-one corespondence with the employees, so you really count those Emp_IDs. :-)

> But, for every table, "select count(*)" provides useful information -
> provided you understand what the table means.

I just showed you that you don't need to count the propositions for counting the employees. :-)
You only need to count the Emp_IDs ... :-)

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Fri Jun 18 2004 - 06:11:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US