Simulating a One-to-Many Relationship in Excel

Giovanni Pace

Description

Before writing SQL, let's simulate in Excel how a One-to-Many relationship would be handled without a relational database. I'll show the data redundancy problems, update difficulties, and why this simulation immediately clarifies the value of foreign keys.