Review Figure 2-8 and Figure 2-21. a. Identify any attributes in Figure 2-21 that might be composite

Question:

Review Figure 2-8 and Figure 2-21.
a. Identify any attributes in Figure 2-21 that might be composite attributes but are not shown that way. Justify your suggestions. Redraw the ERD to reflect any changes you suggest.

b. Identify any attributes in Figure 2-21 that might be multivalued attributes but are not shown that way. Justify your suggestions. Redraw the ERD to reflect any changes you suggest.
c. Is it possible for the same attribute to be both composite and multivalued? If no, justify your answer; if yes, give an example (Consider the CUSTOMER attributes in Figure 2-21).

EMPLOYEE Employee ID Employee Name(...) Payroll Address(.. .) Date Employed {Skill} [Years Employed] Multivalued Derived

SALESPERSON TERRITORY DOES BUSINESS IN PK Salesperson ID Serves PK Territory ID Salesperson Name Salesperson Telephone S


Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Essentials of Database Management

ISBN: 978-0133405682

1st edition

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

Question Posted: