QUESTION 1 You are a database developer. You develop a database application for a SQL Server 2008 instance. The instance hosts a third-party database. You are not allowed to modify the database schema. The database contains two tables that are as shown in the following diagram. You plan to extract address information about full-time employees…