> When I was reading through this thread, I started asking > myself who names a table tblpeople anyway? lol! I know I > have less experience than most on the list, but I've never > built a tblperson or tblpeople. What does tblperson > represent?
> tbldoctors > tbllawyers > tbladministrators > tblemployees > tblusers > Where would I use tblperson and need to make it plural > anyway? What does tblperson represent? Wouldn't you use > something more specific? I can think of one perfect example -- a contact-management app. :) Although generally speaking if you catalog people you'd rather maintain a single table with all people and then associate additional data related to their other classifications (dr, lawyer, etc) in additional tables -- if a person happens to be both a doctor and a laywer then if you've got a tbldoctor table and a tbllawyer table but no tblperson table, then you'll be duplicating data in your database which is contrary to the purpose behind normalization. I used to work on an application that had this problem with their user types -- teachers, students, parents, staff -- each in separate tables -- the only thing that wasn't in those tables was the login, but because the login was badly designed, those had to be duplicated also if an individual user was both a teacher and a staff user. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:4:200700 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
