Thecorrespondingminimalcardinality is0

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: is one that meets two conditions: 1. The entity is existence‐dependent, it cannot exist without the entity with which it has a relationship. 2. The entity has a primary key that is partially or totally derived from the parent entity in the relationship. For example, a company insurance policy may cover an employee and their dependents. An EMPLOYEE may or may not have any DEPENDANTS, however a DEPENDENT must be associated with an EMPLOYEE and if the EMPLOYEE is deleted then the DEPENDENT is also deleted. DEPENDENT is a weak entity in the relationship “EMPLOYEE has DEPENDENT”. Relationship Participation: Participation in a relationship is either optional or mandatory. Optional participation: means that one entity occurrence does not require a corresponding entity occurrence in the relationship. For example, an EMPLOYEE may have no DEPENDENT. Therefore the DEPENDENT entity is optional for the EMPLOYEE entity. The Crow’s Foot notation , an optional relationship is shown by drawing a small circle(O) on the side...
View Full Document

This document was uploaded on 03/07/2014.

Ask a homework question - tutors are online