Answered: An objective of this task is to…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

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

Expert Solution

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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