***Welcome to ashrafedu.blogspot.com * * * This website is maintained by ASHRAF***

Posts

    Thursday 5 December 2019

    Weak entity in E-R model

    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