• Hi, the link for the Adventureworks DB is no longer active. I was able to complete the exercise by using adventureworks2008r2 and making a view and adding it to the Person schema

    USE [AdventureWorks2008R2]

    GO

    /****** Object: View [Person].[Contact] Script Date: 11/24/2015 13:55:53 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    CREATE VIEW [Person].[Contact]

    AS

    SELECT Person.Person.*, Person.EmailAddress.EmailAddress

    FROM Person.Person INNER JOIN

    Person.EmailAddress ON Person.Person.BusinessEntityID = Person.EmailAddress.BusinessEntityID

    GO