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
Q43: In which approach does the integration of
Q44: View1 has entity type CUSTOMER with attributes
Q45: In view design,an ERD representing a form
Q46: Which of the following statements is true
Q47: In the view design process,in addition to
Q49: The following is indicative that a ternary
Q50: A _ is a group of words
Q51: In a form hierarchy diagram,a rectangle is
Q52: In which approach does the integration of
Q53: View design and integration uses the _
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents