entity relationship diagrams n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Entity Relationship Diagrams PowerPoint Presentation
Download Presentation
Entity Relationship Diagrams

Loading in 2 Seconds...

play fullscreen
1 / 12

Entity Relationship Diagrams - PowerPoint PPT Presentation


  • 174 Views
  • Uploaded on

Entity Relationship Diagrams. Basic Elements and Rules. Introduction to Entity-Relationship (E-R) Modeling. Notation uses three main constructs Data entities Relationships Attributes Entity-Relationship (E-R) Diagram

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

Entity Relationship Diagrams


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
entity relationship diagrams

Entity Relationship Diagrams

Basic Elements and Rules

introduction to entity relationship e r modeling
Introduction to Entity-Relationship (E-R) Modeling
  • Notation uses three main constructs
    • Data entities
    • Relationships
    • Attributes
  • Entity-Relationship (E-R) Diagram
    • A detailed, logical representation of the entities, associations and data elements for an organization or business

10.2

entity relationship e r modeling key terms
Entity-Relationship (E-R) ModelingKey Terms
  • Entity
    • A person, place, object, event or concept in the user environment about which the organization wishes to maintain data
    • Represented by a rectangle in E-R diagrams
  • Entity Type
    • A collection of entities that share common properties or characteristics
  • Attribute
    • A named property or characteristic of an entity that is of interest to an organization

10.3

entity relationship e r modeling key terms1
Entity-Relationship (E-R) ModelingKey Terms
  • Candidate keys and identifiers
    • Each entity type must have an attribute or set of attributes that distinguishes one instance from other instances of the same type
    • Candidate key
      • Attribute (or combination of attributes) that uniquely identifies each instance of an entity type
examples
Examples
  • Identify a few entity types, instances, attributes and candidate keys for:
    • DePaul Campus Connect Registration System
    • Illinois Bureau of Motor Vehicles System
    • Amazon.com Product Information System
depicting entities and attributes
Depicting Entities and Attributes
  • Draw a portion of the ERD for each of these systems:
    • DePaul Campus Connect Registration System
    • Illinois Bureau of Motor Vehicles System
    • Amazon.com Product Information System
conceptual data modeling and the e r diagram
Conceptual Data Modeling and the E-R Diagram
  • Goal
    • Capture as much of the meaning of the data as possible
      • If you know the rules of normalization, referential integrity, foreign keys, etc., this is good but not as important now. It is much more important to get the organizational data model correct, i.e. to understand the actual data requirements for the organization.
  • Result
    • A better design that is scalable and easier to maintain
entity relationship e r modeling key terms2
Entity-Relationship (E-R) ModelingKey Terms
  • Identifier
    • A candidate key that has been selected as the unique identifying characteristic for an entity type
    • Selection rules for an identifier
      • Choose a candidate key that will not change its value
      • Choose a candidate key that will never be null
      • Avoid using intelligent keys
      • Consider substituting single value surrogate keys for large composite keys
entity relationship e r modeling key terms3
Entity-Relationship (E-R) ModelingKey Terms
  • Relationship
    • An association between the instances of one or more entity types that is of interest to the organization
    • Association indicates that an event has occurred or that there is a natural link between entity types
    • Relationships are always labeled with verb phrases
cardinality
Cardinality
  • The number of instances of entity B that can be associated with each instance of entity A
  • Minimum Cardinality
    • The minimum number of instances of entity B that may be associated with each instance of entity A
    • This is also called “modality”.
  • Maximum Cardinality
    • The maximum number of instances of entity B that may be associated with each instance of entity A
naming and defining relationships
Naming and Defining Relationships
  • Relationship name is a verb phrase
  • Avoid vague names
  • Guidelines for defining relationships
    • Definition explains what action is being taken and why it is important
    • Give examples to clarify the action
    • Optional participation should be explained
    • Explain reasons for any explicit maximum cardinality
naming and defining relationships1
Naming and Defining Relationships
  • Guidelines for defining relationships
    • Explain any restrictions on participation in the relationship
    • Explain extent of the history that is kept in the relationship
    • Explain whether an entity instance involved in a relationship instance can transfer participation to another relationship instance

10.12