[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.

 

NewSchema 

Check back for updated T-SQL.


About Rob Sanders

IT Professional and TOGAF 9 certified 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 *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>