Solved

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

Question 48

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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents