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