Re: Counting propositions
Date: Fri, 18 Jun 2004 14:11:39 +0300
"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
> > :-)
> 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 ... :-)
- Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=