Course contentsShow
← Computer Science
Lesson 1619 of 2,87237. Database Design and NormalizationFree lesson

Weak Entities and Identifying Relationships

Understanding entities that depend on other entities for identification and their special relationship requirements.

Weak Entities and Identifying Relationships

What you'll learn: How some entities can't stand alone and need another entity to be uniquely identified.

The Core Idea

In ER modeling, a weak entity is an entity that cannot be uniquely identified by its own attributes alone. It depends on another entity (called its owner or parent) for identification. The relationship connecting a weak entity to its owner is called an identifying relationship.

Think of it like apartment numbers in a building: "Apartment 3B" doesn't mean much by itself—which building? which street? The apartment's identity only makes sense when paired with the building it belongs to.

Why Weak Entities Exist

Some entities naturally have no meaningful standalone identifier. Consider:

  • Example: A Dependent entity in an employee database storing information about employees' family members. A dependent might have a name like "Sarah" and birthdate, but multiple employees might have dependents named Sarah born on the same day. The dependent is only uniquely identifiable when combined with their employee's ID.

Key Characteristics

  1. Partial key: The weak entity has a discriminator (or partial key)—an attribute that distinguishes it among entities related to the same owner, but not globally.
  2. Total participation: Weak entities must participate in the identifying relationship (they can't exist without their owner).
  3. The owner has a primary key that the weak entity borrows.
  4. Together, the owner's primary key + the weak entity's partial key form the weak entity's full identifier.

In ER diagrams, weak entities are drawn with double rectangles, and identifying relationships with double diamonds.

Key Takeaway: Weak entities rely on another entity's key for their identity, linked through an identifying relationship where participation is mandatory.