• Networking
  • Programming
  • DBMS
  • Operating System
  • Internet
  • Hardware
  • Software

Tech Differences

Know the Technical Differences

Difference Between Strong and Weak Entity

strong-entity-vs-weak-entityTalking about the Strong and Weak entity, we must know what does an entity means. An entity is a unique object in the real world. It is described as the set of attributes. The collection of the same type of entities together forms the entity set.

Here, we will discuss two types of entities Strong entity and Weak entity. The weak entity always depends on the strong entity for its existence. Let us discuss the differences between both, the Strong entity and weak entity with the help of comparison chart shown below.

Content: Strong Vs Weak Entity

  1. Comparison Chart
  2. Definition
  3. Key Differences
  4. Conclusion

Comparison Chart

Basis for ComparisonStrong EntityWeak Entity
BasicThe Strong entity has a primary key.The weak entity has a partial discriminator key.
DependsThe Strong entity is independent of any other entity in a schema.Weak entity depends on the strong entity for its existence.
DenotedStrong entity is denoted by a single rectangle.Weak entity is denoted with the double rectangle.
RelationThe relation between two strong entities is denoted by a single diamond simply called relationship.The relationship between a weak and a strong entity is denoted by Identifying Relationship denoted with double diamond.
ParticipationStrong entity may or may not have total participation in the relationship.Weak entity always has total participation in the identifying relationship shown by double line.

Definition of Strong Entity

The Strong Entity is the one whose existence does not depend on the existence of any other entity in a schema. It is denoted by a single rectangle. A strong entity always has the primary key in the set of attributes that describes the strong entity. It indicates that each entity in a strong entity set can be uniquely identified.

Set of similar types of strong entities together forms the Strong Entity Set. A strong entity holds the relationship with the weak entity via an Identifying Relationship, which is denoted by double diamond in the ER diagram. On the other hands, the relationship between two strong entities is denoted by a single diamond and it is simply called as a relationship.

Let us understand this concept with the help of an example; a customer borrows a loan. Here we have two entities first a customer entity, and second a loan entity.

strong-entity-and-weak-entity

Observing the  ER-diagram above, for each loan, there should be at least one borrower otherwise that loan would not be listed in Loan entity set. But even if a customer does not borrow any loan it would be listed in Customer entity set. So we can conclude that a customer entity does not depend on a loan entity.strong-entity-and-weak-entity The second thing you can observe that the Customer entity has as primary key Cust_ID which uniquely identify each entity in Customer Entity set.  This makes Customer entity a strong entity on which a loan entity depends.

Definition of Weak Entity

A Weak entity is the one that depends on its owner entity i.e. a strong entity for its existence. A weak entity is denoted by the double rectangle. Weak entity do not have the primary key instead it has a partial key that uniquely discriminates the weak entities. The primary key of a weak entity is a composite key formed from the primary key of the strong entity and partial key of the weak entity.

The collection of similar weak entities is called Weak Entity Set. The relationship between a weak entity and a strong entity is always denoted with an Identifying Relationship i.e. double diamond.

For further illustration let us discuss the above example, this time from weak entity’s point of view. We have Loan as our weak entity, and as I said above for each loan there must be at least one borrower. You can observe in the loan entity set, no customer has borrowed a car loan and hence, it has totally vanished from loan entity set. For the presence of car loan in loan entity set, it must have been borrowed by a customer. In this way, the weak Loan entity is dependent on the strong Customer entity.

weak_entity_setThe second thing, we know is a weak entity does not have a primary key. So here Loan_name, the partial key of the weak entity and Cust_ID primary key of customer entity makes primary key of loan entity.

In the Loan entity set, we have two exactly same entities i.e. a Home loan on date 20/11/2015 with amount 20000. Now how to identify who had borrowed them this can be done with the help of primary key of the weak entity (Loan_name + Cust_ID). So, it will be determined that one home loan is borrowed by Customer 101 Jhon and other by Customer 103 Ruby. This is how the composed primary key of weak entity identify each entity in weak entity set.

Key Differences Between Strong Entity and Weak Entity

  1. The basic difference between strong entity and a weak entity is that the strong entity has a primary key whereas, a weak entity has the partial key which acts as a discriminator between the entities of a weak entity set.
  2. A weak entity always depends on the strong entity for its existence whereas, a strong entity is independent of any other entity’s existence.
  3. A strong entity is denoted with a single rectangle and a weak entity is denoted with a double rectangle.
  4. The relationship between two strong entities is denoted with single diamond whereas, a relationship between a weak and a strong entity is denoted with double diamond called Identifying Relationship.
  5. The strong entity may or may not show the total participation in its relations, but the weak entity always shows total participation in the identifying relationship which is denoted by the double line.

Conclusion

Each entity in a strong entity set can be identified uniquely as it has a primary key but, we may or may not identify each entity in a weak entity as it does not have a primary key and it may contain redundant entities.

Related Differences:

  1. Difference Between Float and Double
  2. Difference Between Super Key and Candidate Key
  3. Difference Between Generalization and Specialization in DBMS
  4. Difference Between Primary key and Foreign key in DBMS
  5. Difference Between Primary and Candidate Key

Comments

  1. Sabbir Jaman says

    January 12, 2018 at 1:35 pm

    Very Nice Tutorial !!!

    Reply
  2. Suvendu Mandal says

    February 15, 2018 at 3:01 pm

    Your post is really very helpful. Thank you.

    Reply
  3. anonymous says

    April 20, 2018 at 3:24 pm

    Super !! very useful for people who are in a hurry 😀

    Reply
  4. Yagni Madhav says

    July 7, 2018 at 7:41 am

    cool very helpful.

    Reply
  5. kamal Neupane says

    September 11, 2018 at 4:19 pm

    you are amazing Mam….please post more ..

    Reply
  6. Aditya raut says

    November 2, 2018 at 3:43 am

    nice guys good and beneficial so far

    Reply
  7. Tanvi Laddha says

    December 1, 2018 at 2:50 am

    Thank u so much! This answer is worth, I mean, I was searching for this very answer. Everything required is covered so perfectly…

    Reply
  8. Eric Mundia says

    February 23, 2019 at 3:33 pm

    You are the very best! awesome answer, very useful.

    Reply
  9. BOT says

    May 12, 2019 at 12:21 pm

    Cool

    Reply
  10. Keith Carlos Nyazenga says

    February 5, 2022 at 4:05 pm

    well explain

    Reply
  11. Keith Carlos Nyazenga says

    February 5, 2022 at 4:06 pm

    well explained , thank you

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Top 10 Differences

  • Difference Between OLTP and OLAP
  • Difference Between while and do-while Loop
  • Difference Between Guided and Unguided Media
  • Difference Between Preemptive and Non-Preemptive Scheduling in OS
  • Difference Between LAN, MAN and WAN
  • Difference Between if-else and switch
  • Difference Between dispose() and finalize() in C#
  • Difference Between for and while loop
  • Difference Between View and Materialized View
  • Difference Between Server-side Scripting and Client-side Scripting

Recent Addition

  • Difference Between Unit Testing and Integration Testing
  • 4G Vs 5G
  • Raster Vs Vector Images
  • JPEG Vs TIFF
  • RJ11 Vs RJ12

Categories

  • DBMS
  • Hardware
  • Internet
  • Networking
  • Operating System
  • Programming
  • Software

Copyright © 2023 · Tech Differences · Contact Us · About Us · Privacy