Weak and Strong Entities

Description of Weak and Strong Entities.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


The existance of a weak entity depends on the existence of a strong entity; it must relate to the strong via a on-to-many relationship set.

The primary key of a weak entity is formed by the primary key of the strong entity on which the weak entity set is existence depend, plus the weak entity set’s discriminator (partial Key).

A strong entity is one that has its own primary key and dont depand on any other entitie.

If you need more info, ask ..

see ya
majorjohnAuthor Commented:
Yes I need some more information with example.

Hi MajorJohn

Typical Expample of weak and strong entity


The entity DEPENDANTS depends of the entity EMPLOYEE
DEPENDANTS = Wife, childrens, family.

In a Company DB the DEPENDANTS entity can exist by it self. In these case we make the relation DEPENDANTS --<depends>-- EMPLOYEE

Bye Bye
The above model may not be a true example. It could also be possible for a dependent to be an Employee!! Nepotism is best kept in the family!!
Strong entity...
Table Orders
ID        int      Primary Key
OrderNum  varchar
OrderDate datetime

Table Items
ID        int      Primary Key
Desc      varchar

Table OrderDetail
OrderID   int      Foreign Key (references Order.ID)
ItemID    int      Foreign Key (references Item.ID)
Qty       int

In this example the items and orders tables are core level or "Stong" entities.  They stand alone without requiring other defined objects.
The Order detail is a "Weak" entity as it requires the existence of both an order and item to exist.

Is this what you are looking for?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.