Decomposing an IS-A Relationship

Entity CLIENT contains

ClientNumber

ClientName

Address

AmountDue

SocialInsuranceNumber

TaxIdentificationNumber

ContactPerson

Phone

Problem: Too many NULL values

Solution: Separate into CLIENT entity plus several subtypes

CLIENT

INDIVIDUAL

CLIENT

CORPORATE

CLIENT

1

Previous slide

Next slide

Back to first slide

View graphic version