A company database contains an entity called EMPLOYEE. Among other information, the company records information about any

Question:

A company database contains an entity called EMPLOYEE. Among other information, the company records information about any degrees each employee has earned, along with the graduation date for the degree.
a. Represent the EMPLOYEE entity and its degree attributes using the notation for multivalued attributes.
b. Represent the EMPLOYEE entity and its degree attributes using two entity types.
c. Finally, assume the company decides to also keep data about the institution from which the employees’ degrees were earned, including name of the institution, city, and state where the institution is located. Augment your answer to part b to accommodate this new entity type.

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

Step by Step Answer:

Related Book For  book-img-for-question

Essentials Of Systems Analysis And Design

ISBN: 9780133469530

5th Edition

Authors: Joseph Valacich, Joey F George

Question Posted: