View1 has entity type CUSTOMER with attributes CID, LAST_NAME, FIRST_NAME, ADDRESS (which includes, number, street, city, state, zip), SALESPERSON, EMPID)
View2 has entity type CLIENT with attributes ID, LNAME, FNAME, ADDRESS (number and street), CITY, STATE, ZIP, CLIENT_SINCE (year), and entity type EMPLOYEE (ELNAME, EFNAME, EMPNO, DNAME). There is a 1-M relationship from EMPLOYEE to CLIENT (an employee may be the salesperson responsible for several customers).
CLIENT and CUSTOMER contain essentially the data for the same customers. In CUSTOMER, SALESPERSON (further identified by EMPID) represents the salesperson (last name, first name) responsible for the customer. It is a foreign key referencing the table EMPLOYEE (primary key: EMPNO). View1 and View2 must be integrated.

-In the integration the entity types CUSTOMER and CLIENT are merged into one entity type,CUSTOMER.Choose the most appropriate group of attributes for this new entity type:
A) CID, LNAME, FNAME, FULL_ADDRESS, SALESPERSON_LNAME, SALESPERSON_FNAME
B) CID, LNAME, FNAME, FULL_ADDRESS, EMPID
C) CID, LNAME, FNAME, FULL_ADDRESS, EMPID.
D) CID, LNAME, FNAME, ADDRESS, CITY, STATE, ZIP, CUSTOMER_SINCE

Question

View1 has entity type CUSTOMER with attributes CID, LAST_NAME, FIRST_NAME, ADDRESS (which includes, number, street, city, state, zip), SALESPERSON, EMPID)
View2 has entity type CLIENT with attributes ID, LNAME, FNAME, ADDRESS (number and street), CITY, STATE, ZIP, CLIENT_SINCE (year), and entity type EMPLOYEE (ELNAME, EFNAME, EMPNO, DNAME). There is a 1-M relationship from EMPLOYEE to CLIENT (an employee may be the salesperson responsible for several customers).
CLIENT and CUSTOMER contain essentially the data for the same customers. In CUSTOMER, SALESPERSON (further identified by EMPID) represents the salesperson (last name, first name) responsible for the customer. It is a foreign key referencing the table EMPLOYEE (primary key: EMPNO). View1 and View2 must be integrated.

-In the integration the entity types CUSTOMER and CLIENT are merged into one entity type,CUSTOMER.Choose the most appropriate group of attributes for this new entity type:
A) CID, LNAME, FNAME, FULL_ADDRESS, SALESPERSON_LNAME, SALESPERSON_FNAME
B) CID, LNAME, FNAME, FULL_ADDRESS, EMPID
C) CID, LNAME, FNAME, FULL_ADDRESS, EMPID.
D) CID, LNAME, FNAME, ADDRESS, CITY, STATE, ZIP, CUSTOMER_SINCE

Quizplus · Accepted Answer

This choice has a comprehensive list of attributes that covers all necessary information about both customer and client. CID, LNAME, FNAME, ADDRESS, CITY, STATE, ZIP can be used to store general information about the customer. CUSTOMER_SINCE can be added to the list to keep track of the length of time the customer has been with the company. This information is important for customer profiling and marketing.

View1 Has Entity Type CUSTOMER with Attributes CID, LAST_NAME, FIRST_NAME