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.