the enhanced er eer model
play

THE ENHANCED ER (EER) MODEL CHAPTER 8 (6/E) CHAPTER 4 (5/E) CHAPTER 8 OUTLINE Extending the ER model Created to design more accurate database schemas Reflect the data properties and constraints more precisely Address more

0 downloads 2 Views 265 KB Size Report
  1. THE ENHANCED ER (EER) MODEL CHAPTER 8 (6/E) CHAPTER 4 (5/E)

  2. CHAPTER 8 OUTLINE  Extending the ER model • Created to design more accurate database schemas • Reflect the data properties and constraints more precisely • Address more complex requirements • Subclasses, Superclasses, and Inheritance • Specialization and Generalization • Modeling of UNION Types Using Categories 2

  3. SPECIALIZATION AND INHERITANCE  Specialization • Process of defining a set of subclasses of an entity type • Defined on the basis of some distinguishing characteristic of the entities in the superclass  Describing the relationship • Superclass/subclass or Class/subclass • Supertype/subtype or Type/subtype  Subclass can define: • Specific attributes • Specific relationship types  Subclass can be a subclass wrt more than one superclass  Type inheritance • Subclass entity has all attributes and participates in all relationships of superclass • Multiple inheritance if more than one superclass 3

  4. GENERALIZATION  Generalization • Process of defining a more general entity type from given entity types  Reverse process of specialization  Generalize into a single superclass • Original entity types are specialized subclasses • Entities in generalization must all come from subclasses 4

  5. SPECIALIZED ENTITIES  Every technician/secretary/engineer is EMPLOYEE an employee. SECRETARY  Not every employee of superclass  e 8 must be in a subclass (unless specified  e 7  e 2 as generalization ).  e 1  All properties of employee (attributes and relationships) are inherited by MANAGER  e 5  e 3 specialized subclasses. TECHNICIAN  e 6  Specialized entities might have  e 4  e 10 additional attributes and be involved in  e 9 additional relationships. ENGINEER  Subclasses may be disjoint or overlapping . 5

  6. CONSTRAINTS ON SUBCLASSES  Disjointness constraint • Specifies that the subclasses of the specialization must be disjoint  Completeness constraint • Specifies that every superclass entity must be in a subclass • Required of generalization  Disjointness and completeness constraints are independent constraints 6

  7. EER DIAGRAM WITH SUBCLASSES 7

  8. REFINING CONCEPTUAL SCHEMAS  Using specialization • Starting with entity type, define subclasses by successive specialization • Top-down conceptual refinement  Using generalization • Starting with entity type, define superclasses by successive generalization • Bottom-up conceptual synthesis 9

  9. MODELING WITH UNION TYPES • Union type or category • Represents a single superclass/subclass relationship with more than one superclass • Subclass represents a collection of objects that is a subset of the UNION of distinct entity types • Attribute inheritance works more selectively • Category can be total or partial  Some modeling methodologies do not have union types • Usually (always?) clearer to use specification/generalization 10

  10. UNION TYPES 11

  11. REWRITING UNION AS SPECIALIZATION BANK BANK PERSON COMPANY PERSON COMPANY ⋃ ⋃ ⋃ oBANK oPERSON oCOMPANY ⋃ d ⋂ ⋃ OWNER OWNER OWNS OWNS REGISTERED VEHICLE REGISTERED VEHICLE ⋂ ⋃ ⋃ CAR TRUCK d ⋃ ⋃ CAR TRUCK rCAR rTRUCK 12

  12. 13

  13. DESIGN CHOICES  Many specializations/generalizations can be defined to make the conceptual model accurate • Constrain as disjoint/overlapping or total/partial as needed • Driven by rules in miniworld being modeled  If all the subclasses of a specialization/generalization have few specific attributes and no specific relationships • Can be merged into the superclass C • Include in C one or more “type” attributes that specify the (virtual) subclasses to which each entity belongs  Union types should generally be avoided 14

  14. SUMMARY  Enhanced ER or EER model • Extensions to ER model that improve its representational capabilities • Subclass and its superclass • Category or union type • EER diagrams 17

Recommend Documents


strategies to provide primary care in an enhanced medical
Strategies to Provide Primary Care in

Strategies to Provide Primary Care in an Enhanced Medical Home Model to

enhanced approach to model air quality impacts of aircra8
Enhanced Approach to Model Air

Enhanced Approach to Model Air Quality Impacts of Aircra8 Opera:ons

75
75% Location profiler 85% Flow

T HESIS OBJECTIVES Static Canopy Model (SCM); Dynamic Canopy Model (DCM);

enhanced flatbed tow truck model for stable and safe
Enhanced flatbed tow truck model for

Enhanced flatbed tow truck model for stable and safe platooning in presences

model based development of the enhanced multi mission
Model Based Development of The Enhanced

Model Based Development of The Enhanced Multi-Mission Radioisotope

an enhanced ride sharing model based on human
An Enhanced Ride Sharing Model Based on

An Enhanced Ride Sharing Model Based on Human Characteristics and Machine

use of prior knowledge to establish flexible enhanced
Use of Prior Knowledge to Establish

EMA /US FDA Workshop on support to quality development in early access

what is enhanced oil recovery
What is Enhanced Oil Recovery?

Presentation1\09 JAN 2015\3:34 PM\2 What is Enhanced Oil Recovery? Enhanced

fy 2018 enhanced collaborative model task force to combat
FY 2018 Enhanced Collaborative Model

FY 2018 Enhanced Collaborative Model Task Force To Combat Human Trafficking

cmmi enhanced medication therapy management model
CMMI Enhanced Medication Therapy

CMMI Enhanced Medication Therapy Management Model Presentation to

compiler construction
Compiler Construction Lecture 2:

Compiler Construction Lecture 2: Lexical Analysis I (Introduction) Thomas

word tutorial 3 creating a multiple page report
Word Tutorial 3 Creating a Multiple-

Word Tutorial 3 Creating a Multiple- Page Report COMPREHENSIVE Objectives

6 strings and lists
#6: Strings and Lists SAMS SENIOR CS

#6: Strings and Lists SAMS SENIOR CS TRACK Last Time Used control flow to

some new scripts for the wrapper
Some New Scripts for the Wrapper

Introduction XML Structures More XML Structures <html>/pdfT EX Some

program synthesis for character level language modelling
Program Synthesis for Character Level

Program Synthesis for Character Level Language Modelling Pavol Bielik

an approach to modeling short messages in spatio temporal
An approach to modeling short

An approach to modeling short messages in spatio- temporal networks Amosse

carnegie mellon univ dept of computer science 15 415 615
Carnegie Mellon Univ. Dept. of

Faloutsos CMU SCS 15-415/615 CMU SCS Carnegie Mellon Univ. Dept. of Computer

9 generalization and leibniz rules
9- Generalization and Leibniz Rules

SC/MATH 1090 9- Generalization and Leibniz Rules Ref: G. Tourlakis,

inductive logic programming part 2
Inductive Logic Programming. Part 2

Inductive Logic Programming. Part 2 Based partially on Luc De Raedts slides

the committee machine computational to statistical gaps
The committee machine: Computational

The committee machine: Computational to statistical gaps in learning a

query reformulation model and patterns
Query reformulation model and patterns

Query reformulation model and patterns from dango to japanese cakes M

the generalization of the conjunctive rule for
The Generalization of the Conjunctive

The Generalization of the Conjunctive Rule for Aggregating Contradictory