Post in pre-embryonal stage!! Read at your risk :)
Foreign key inheritance @ the physical modeling level, when to?
1) non transferability @ conceptual modeling;
2) weak entity identification @ logical modeling.
tricks:
why replace natural structured keys with surrogate keys violating and missing conceptual constraints when you can keep both of them! You can define a natural structured primary key to implement the foreign key inheritance and enforce the non transferability constraint at the logical/physical level and on the other hand add a surrogate unique key to be used for afferent joins, just in case you identify that joining on a structured natural key is a performance issue that you can't accept.
In other words do the right thing for your model!
1)Define foreign key constraints on natural (and eventually structured) keys to maintain consistence with your conceptual model and implement a 'non transferability' constraint;
2)Join on an additional/complementary surrogate unique key (if strictly necessary).
If your physical model is well done (:maintainable and extensible) you can skip this second step and leave it as a later optimization prescription to be applied only in case the structured key joins will start degrade their performance for real.
Well sounds like I just implemented "Do The Right Thing" and "Premature Optimization" after all ;).
Additional thoughts that arise from this topic (it's just a post note for further topic development):
weakness of ER, lies of modelers: recursive relationships are often used to model hierarchical entities/structures. But hierarchical entities are weak by their nature, right? Don't you think? So how would you implement key inheritance on a recursive relationship than? No way...? Any idea? So "hierarchical ER data entities" are a lie? No way to enforce structural constraints of the hierarchy without special features. Alternative ER implementations than the self recursive relationship one then? etc.etc.
Comments
answer this post
It’s really payless to have hot enough articles just about this post. And sometimes some students switch on the PC and buy research paper and one could have the aid of the high quality custom essays writing corporations to buy an essay soon.
respond this topic
Do you want to have high grades? Hence, all you need to do is to compose the dissertations of the best quality or just buy thesis paper at the thesis service.
answer
Some students don't care about their future and they can accomplish not professional doctoral dissertation. However, I can say that any thesis writing service would make supreme thesis paper, which can suit everybody's needs.
reply this post
Sometimes, that can happen that students are irritated because of dissertation chaprers writing assignments. However, they not have any reason to worry, just because a distinguished dissertation service can sell thesis paper of great quality.
reply this post
We think, you could use the article submit for your facts about this post, because that is really good and must not be hidden from public!
Re
Some companies offer their dissertation writing service and format thesis just about this good post for sutdents’ success. Therefore, do not waste your time, notice the buy thesis service, buy your dissertation and be happy.
Re
The most right way to check out the quality of the thesis writing service is to buy the nice thesis papers about this topic in dissertations writing services.
Re
I guess, writing service make essay writing just about this good post. And this is an opportunity to buy an essay to reach a studying success.
Re
I would like to order custom written essays or buy custom essay papers about this good topic, selecting the essays writers.
Re
Thnx a lot for the smashing issue close to this topic. I could not detect this kind of thesis project in Internet and even was going to purchase the dissertation. Hence, I get all needed stuff at present time.