Oops. I meant "ARTIST creates ARTWORK." > 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=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181897 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54