Part 1 Mapping Inheritance

Strategies

1. Each super and sub class have their own tables

2. 1 Super table that contains all the columns for each of the classes

3. Each super and sub class have their own tables, except this time, we use foreign keys to reference super classes

Example of 3

• note how the ID is both the foreign key and the primary key

• also note the delete on cascade

• subclasses should not be deleted

Part 2 Fan Traps and Chasm Traps

Fan Trap

Baso when the link between objects is not clearly stated.

Chasm Traps

Baso when a link is needed between two objects, but it is not clearly stated