> I'd just like to know other folks thoughts on this issue. I would like to > see this through and to BE RIGHT about this.
I'm not sure there *is* a right answer. Personally I prefer to do all management of referential integrity via application code, simply because then all the logic is in one place, and also it's historically been easier to do it in a DBMS-independent way if you take that approach. However, your arguments in the other direction are all very good ones, except for this one - > .. Also in rebuttal to the above, isn't this is what is meant by a > ~Relational Database~, that records are ~related~ and should be managed as > logical units? No. It's a widespread misconception that "relational database" refers to the relationships between records in different tables. For what it's worth, the term was actually coined with reference to the internal logical structure of the tables themselves: http://www.acm.org/classics/nov95/s1p3.html Nick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2288 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
