An objective of this task is to denormalize a conceptual schema to speed up processing of a given class of applications. The following conceptual schema represents a database domain where the contract...

An objective of this task is to denormalize a conceptual schema to speed up processing of a given class of applications.

The following conceptual schema represents a database domain where the contract and permanent employees are assigned to the projects.
(see image below)

Requirements

Steps Involved:

- Elimination of generalization using Association, Subset or Superset method

- Simplifications:

•Elimination of association classes

•Elimination of link attributes

•Elimination of many-to-many associations

Perform simplification of the conceptual schema above and re-draw the simplified conceptual schema.

Extracted text: PROJECT EMPLOYEE code title ID1 ID2 Is assigned to 1..* e# full-name ID budget deadline[1..* ] assign-date (t,e) CONTRACT Has-contract CONTRACT-EMPLOYEE PERMANENT-EMPLOYEE 0..1 start-date when-joined when-left [0..1] end-date