Does this really break any kind of rules, if we look at it as I have stated here?
Thanks for any thoughts,Yes. It is definitely breaking rules, the rules or normalization, and my guess is that you realize this or you would not be asking this question.
And sooner or later, making a bad design choice like this will come back to haunt you.
Have an Address table, and a Person table, and a Company table, and a PersonType table, and set the attributes accordningly. The query to get the data will be a bit more complex, but you'll reap the benefits of increased data integrity for a long time...|||So if I have a design like the following, how would you suggest that I exclude the companyName and ClientTitle if I'm mailing to a home address and the client has a home and company address in the address table? Thanks for your thoughts again.
tblClients
ClientID
ClientType = Indivudal or Company, etc...
CompanyName
ClientTitle
tblAddresses
AddressID
ClientID
tblClientTypeLookup = Individual, Company, etc...
No comments:
Post a Comment