Re: Stupid Database Tricks

On 13 jun, 10:41, vldm10 <vld..._at_yahoo.com> wrote:
> [...] Although, regarding that you are
> knowledgeable person I would like to know what is in your opinion
> reinvented (or looks like it) in my "model". You can roughly present
> it or one by one.

The ideas of :
1. Adding a special key to relations that identifies the entities or relationships represented by the tuples in the relation. 2. Using the presence of this key to split everything as much as possible into binary relations.

These are old ideas, and have already been rejected before. I have not seen any argumentation by you that explains why this would now have become a good idea.

Btw. did you realize that for a relation R(K, A_1, ..., A_n) where {K} is a superkey, it always holds that the relation equals the joins of R(K, A_1), ..., R(K, A_n)? Any assumptions about mutual independence are not necessary. Also note that such a relation is not necessarily in 5NF if {A_1, ..., A_n} are mutually independent, or even in 4NF, for that matter.

• Jan Hidders