SQL-5d - Sample Problem - Pulling out Office Data

Starts into solving the first identified problem with our sample data, and that is that member Office data is repeated and non-scalar. We identify what type of relationship it has with the Member table, identify a primary key for the Office table, enter the data, and remove it from the original table.