If everyone wants to get all technical with relational database theory, a table name should be singular because it is an ENTITY.
Most entities (tables) have relationships (foreign key linking) with other entities. These relationships can be thought of as verbs, and entities can be thought of as nouns. For example, if you linked an ARTIST table to a ARTWORK table, you could say, "ARTIST creates PAINTING." This is especially helpful if you create entity-relationship diagrams, which I highly recommend for larger projects. I wish I had a good resource to point you to other than my Database Systems textbook from college. Chris > Isn't a set singular? > > So a set refers to one set such as a table containing People, but more > than one set (sets - plural) would be like People and Organization > (two sets). > > So a table name should be singular using the set reference :P > > -----Original Message----- > From: [EMAIL PROTECTED] > Date: 10/19/04 9:28 am > To: CF-Talk > Subj: RE: Field Naming > > As said there is no definitive but here's my two pennies worth. > > >> After all, we are talking about sets here, and it's natural to > pluralise them. > > My old database teacher would have a fit with that... but each to > their > own :) > > We use two words to describe (and name) each table > > An example here would be > > TABLE: PROJECT_DETAIL > COLUMN: PD_ID, PD_NAME... etc > > The column name is collapsed two a two letter prefix, not actually > came > across a time when their was a duplicate prefix within a schema but > I'm > sure if it happened you could use a different > > Anyways... > > -- > dc > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181865 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
