majorjohn
asked on
Weak and Strong Entities
Description of Weak and Strong Entities.
ASKER
Yes I need some more information with example.
Thanks,
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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