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 based on the FullTimeIndicator flag. You need to design a data access layer to simplify the extraction process. What should you do?

A.    Design an Entity Data Model that contains the EMPLOYEES and ADDRESS entities.
B.    Create a view on the database to include full-time employees and their address details.
C.    Re-design the underlying database model to include employee and address information in one table.
D.    Design a conceptual Entity Data Model that contains an entity named EMPLOYEE_ADDRESS. Ensure that this entity contains information about employees and their addresses.

Read More