Link to home
Start Free TrialLog in
Avatar of majorjohn
majorjohn

asked on

Weak and Strong Entities

Description of Weak and Strong Entities.
Avatar of pjmaze
pjmaze

hi,

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
Avatar of majorjohn

ASKER

Yes I need some more information with example.

Thanks,
Hi MajorJohn

Typical Expample of weak and strong entity

EMPLOYEE and DEPENDANTS

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!!
ASKER CERTIFIED SOLUTION
Avatar of traygreen
traygreen

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial