[thelist] ASP: More Selective Select
Damien COLA
damiencola at wanadoo.fr
Thu Jul 3 05:35:59 CDT 2003
I guess there can't be no productive debate on this ;-)
For me, the best proof that singular should rule tables world is that in
Merise method we're talking about an entity, not a set of things. You
have an entity, like THE employee, that you describe, in relation with
other entities.
It's only when you're using your database that you can talk about set of
objects, objects are rows.
But I understand the opposite view and in a parrallel dimension I am
supporting it. But in this dimension I am unoriginally supporting the
majority view.. ;-)
I agree with the second advice, which is also not to have too long
fields or table names, it's because I am still not using a RDS and have
to enter manually all SQL queries, deal with the results in PHP, etc..
Have a nice day,
Cordialement,
Damien COLA
http://www.VarMalin.com
-----Original Message-----
disagree
the concept is of sets of things
the set of employees, the set of jobs...
thus, select ... from employees
casey, a more important rule than using plural names for tables is NOT
to embed the "type of the thing" into the name of the thing
for example, do not say tblEmployees or colFirstname
adjective_that noun_practice verb_is adverb_really
adjective_disconcerting
;o)
rudy
--
* * Please support the community that supports you. * *
http://evolt.org/help_support_evolt/
Evolt.org conference in London, July 25-27 2003. Register today at
http://evolt.org.uk
For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
More information about the thelist
mailing list