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
Correct Answer:

Verified
Correct Answer:
Verified
Q22: In a large database development effort,the process
Q23: The complexity of an individual database can
Q24: View design and integration uses the _
Q25: In a tools rental business, a form
Q26: With the _ approach to view integration,a
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
Q31: View1 has entity type CUSTOMER with attributes
Q32: The consistency rules for relationship cardinalities state