[MiniProject] Part 2: The Refactor

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.

About Rob Sanders

IT Professional and TOGAF 9 certified Enterprise Architect with nearly two decades of industry experience, 18 years in commercial software development and 11 years in IT consulting. Check out the "About Rob" page for more information.

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.