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

EBK JAVA PROGRAMMING
9th Edition
ISBN:9781337671385
Author:FARRELL
Publisher:FARRELL
Chapter11: Advanced Inheritance Concepts
Section: Chapter Questions
Problem 3PE
icon
Related questions
Question

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.

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
Transcribed Image 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
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Dataset
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT