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
Q37: In a tools rental business, a form
Q38: Which of the following is not true
Q39: To resolve synonyms and homonyms,you would rename
Q40: The complexity of a database reflects the
Q41: Which of the following should exist in
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
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