As with all good data schemas, there’s usually some refactoring as time goes by. This project isn’t immune to the shifting sands of time or perfection, and so today’s second instalment features a schema change.
Below is a representation of the schema shift. To summarise, separate Actor/Director tables have been merged into one single table, Person, and two join/junction tables have been defined – MovieActor and MovieDirector on the basis that a person may act in and/or direct a film (example, Clint Eastwood).
You will see why this change was made shortly.
Check back for updated T-SQL.