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

question 31

Multiple Choice

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.

-Which of the following groups of names would be considered to be homonyms?

• A) ADDRESS in CUSTOMER and ADDRESS in CLIENT
• B) CID in CUSTOMER and ID in CLIENT
• C) LAST_NAME and LNAME
• D) All of the above

---

Definitions:

Efficient Amount

The optimal level of production or consumption where resources are utilized in the most effective manner without waste.

External Cost

A cost of economic activity not borne by the producer or consumer, but rather by a third party or the environment, often leading to market failure.

Efficient Amount

The quantity of a product or service that achieves a perfect balance between economic efficiency and the satisfaction of all market participants.

Government Intervention

Actions taken by a government to adjust or interfere in the economic affairs of a nation, with the intention of achieving economic or societal objectives.