Dick Applebaum wrote: > On Oct 19, 2004, at 8:47 AM, Keith Gaughan wrote: > > >>> If everyone wants to get all technical with relational database >>> theory, a table name should be singular because it is an ENTITY. >> >> The way I was taught it, a table represents a *set* of entities. > > Actually, a table is an entity that contains a set of entities.
'tis true, but then ER diagrams and the like are for modelling relationships between various entitities in the platonic sense as opposed to the more solid ones you're dealing with when you go to an RDBMS. A table is just a set of those entities made substantial and isn't itself modelled in ER diagrams, a way of grouping entities with same platonic form modelled in the ER diagram. K. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://www.digital-crew.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181881 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
