First National Bank — Enterprise EER Design

The business problem

First National Bank's old data model treats every customer the same — but individuals and businesses behave very differently, and shoehorning them into one entity creates years of downstream pain. Use Enhanced ER modeling (specialization, inheritance, weak entities) to design a schema that respects the differences while still giving the bank one unified view.

This case is the cleanest exercise in the course for practicing EER constructs: when you genuinely need them, and how to translate them into a relational schema once you do.

Case kit