Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Normalization Question
Message
 
To
15/10/2010 20:20:27
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01485679
Message ID:
01485681
Views:
69
>>I need to store addesses for different entities. I will create an address table. Anything wrong with creaing a 'ParentID' column and then populating it with the PK of the entity the address belongs to? I know some would say that you shoulds create a CustomerAddresses table and an EmployeeAddresses table, and so on. What do you think?
>
>An Address is an entity, a Customer is an entity and an Employee is an entity. What is a CustomerAddress entity and how is a CustomerAddress "entity" different from an EmployeeAddress entity?

They're many to manys, so I suppose they're not really entities.

I dunno.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform