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

question 27

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 not to contain synonyms,for which one unique name should be chosen?

• A) CUSTOMER and CLIENT
• B) EMPID and EMPNO
• C) LAST_NAME and LNAME
• D) FIRST_NAME and FNAME

---

Definitions:

Rich Text

A text format that allows for the embedding or inclusion of various non-text elements, such as images, tables, and different font styles within a document.

Date Picker

A graphical user interface element that lets users select a date from a visual calendar presented within a program or webpage.

Design Mode

A mode in software development and design tools where users can create, modify, and arrange components or elements of an application or website.

Fillable Form

An electronic form that can be completed by typing directly into designated areas, often used for applications, surveys, or data collection.