Bill Benson
bensonforums at gmail.com
Tue Sep 16 19:23:15 CDT 2014
I just checked the adventureworks2012 sql server sample database and yes, there is a personphone table with fks to the businessentity table and the phonenumbertype table as I had suspected. Not pushing the idea further, just confirming that I have now been able to go back and do my diligence. However, there is no businessentitytype table as I had mistakenly assumed there to be. So apparently there is no attempt to distinguish what type of an entity is getting associated with a given phone number ---- e.g., institution, person, Bessie the cow... :-). It seems that the BusinessEntity table is just a log of all the, uh, entities that have been registered within the database, which includes in the case of that database, Employees Job candidates Businessentitycontacts Persons Gotta love the distinction between persons and employees, but I did not see a table called corporations so I guess what Romney said was really true, corporations are people too (unlike employees I guess) :-Q Stuart, I owe you an apology (whether or not you are still reading). I guess this businessentityid thing is just so that all those classified entities don't need their specialized keys (and corresponding FKs in the fact and junction tables, the businessentityid suffices. I don't really half know why this database is set up the way it is, I have not read any documentation on it yet. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Tuesday, September 16, 2014 6:45 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Another normalization question Bill, this sounds similar to what Mark suggested. It sounds like the way to go for me. Susan H.