Weak entity in E-R model
A weak entity is a type of entity which doesn't have its
key attribute. It can be identified uniquely by considering the primary key of
another entity. A weak entity set need to have participation with another entity set which is called Strong entity set.
The difference between a strong entity and a weak entity are:
Strong Entity Set
|
Weak Entity Set
|
Strong entity set
always has a primary key.
|
It does not have enough
attributes to build a primary key.
|
It is represented by a
rectangle symbol.
|
It is represented by a
double rectangle symbol.
|
It contains a Primary
key represented by the underline symbol.
|
It contains a Partial
Key which is represented by a dashed underline symbol.
|
The member of a strong
entity set is called as dominant entity set.
|
The member of a weak
entity set called as a subordinate entity set.
|
Primary Key is one of
its attributes which helps to identify its member.
|
In a weak entity set,
it is a combination of primary key and partial key of the strong entity set.
|
In the ER diagram the
relationship between two strong entity set shown by using a diamond symbol.
|
The relationship
between one strong and a weak entity set shown by using the double diamond
symbol.
|
The connecting line of
the strong entity set with the relationship is single.
|
The line connecting the
weak entity set for identifying relationship is double.
|
Example:
In the above ER Diagram, ‘Payment’ is the weak entity. ‘Loan Payment’ is the identifying relationship and ‘Payment Number’ is the partial key. Primary Key of the Loan along with the partial key would be used to identify the records.
No comments:
Post a Comment