|
|
Posted by fireball on 12/12/06 17:02
please help, I need professional approach how to realize generalization
(parent_table <- child_table) idea in sql server databse?
in my Oracle db I can have PK of child_table as FK from parent_table: let's
have shop with shoes, selling shoes, and foosd as well. Example of keys in
my tables:
Product (=parent_table)
-------------
1
2
3
4
5
Food (=child_table)
-------------
2
3
4
Shoes (=child_table)
-------------
1
5
Is that good idea, or not, and may I have the same in SQLServer (2005) ?
(and, what about administrative aspects (like
performance/concurency/updating ..) of generalization in RDMS?)
regards
Navigation:
[Reply to this message]
|