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:

Verified
Correct Answer:
Verified
Q26: With the _ approach to view integration,a
Q27: View1 has entity type CUSTOMER with attributes
Q28: The incremental approach to view integration has
Q29: Requirements are easy to capture.Users can always
Q30: Conflicts arising from different uses of fields
Q32: The consistency rules for relationship cardinalities state
Q33: When using a form-driven approach to database
Q34: Data entry forms can be an important
Q35: The _ approach to view integration works
Q36: In the third step of form analysis,_