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:

Multi-Cultural Collage

An approach to marketing that integrates diverse cultural elements and influences to appeal to a wide array of demographic segments.

Deterritorialization Framework

A theoretical concept often used in cultural studies and sociology that describes the process of diminishing the importance of physical location and boundaries in social and cultural practices.

Global Brands

Global brands are brands that are recognized and available across multiple countries, often with a consistent identity and marketing strategy.