0

http://web.cs.ucla.edu/classes/fall04/cs143/solutions/chap2.pdf

In the above link, there is the following statement - "Tuples in a weak entity set are partitioned according to their relationship with tuples in a strong entity". I have searched a lot, but I can't find anywhere what partitioning is and how (also why) exactly the tuples in a weak entity set are partitioned. If someone can illustrate it with an example it would be very helpful

2

1 Answer 1

0

I believe what it's trying to say is because weak entity sets don't have their own primary keys, they are dependent on the strong entity sets that they have a foreign key relationship with (because those related strong entity sets do have primary keys).

So in other words, a tuple in a weak entity set will be partitioned (split up) from other tuples in that same weak entity set by their related strong entity set tuples.

I'm assuming the purpose of weak entity sets is a form of normalization by breaking related fields out of the strong entity set into a separate related set all together (a weak entity set without a primary key).

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.