Scribd
Upload
5 views13 pages

ER Model Basics and Applications Guide

The document provides an overview of the Entity-Relationship (ER) model, including its basic elements such as entities, attributes, and relationships. It discusses various types of entities, attributes, and relationships, including weak and strong entity types, as well as cardinality and participation constraints. Additionally, it presents examples of ER modeling in the context of a restaurant and a company.

Uploaded by

Macska
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views13 pages

ER Model Basics and Applications Guide

The document provides an overview of the Entity-Relationship (ER) model, including its basic elements such as entities, attributes, and relationships. It discusses various types of entities, attributes, and relationships, including weak and strong entity types, as well as cardinality and participation constraints. Additionally, it presents examples of ER modeling in the context of a restaurant and a company.

Uploaded by

Macska
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Overview

The ER model
Database Systems and Applications
Basics of the ER Model

● Short introduction to the ER Model


● Conception of the ER Model
● Formal set theoretic definition
● Comparison with the relational model

Database Systems and Applications >> The ER model


Basics of the ER Model - Elements

● Elements of the ER Model


○ Entity
○ Attribute
○ Relationship
● Possible representation methods

Database Systems and Applications >> The ER model


Entities and their Types

● Entities, examples
● Weak and Strong entity types
● Meaning of Entity types and Entity sets

Database Systems and Applications >> The ER model


Weak Entity Type

● A closer look weak entity types


● Compare weak entity type to strong entity type
● Identifying weak entity type
● Definition of Partial key or discriminator
● Definition of existence dependency and cardinality
● Alternatives for representationReprezentációs
alternatívák

Database Systems and Applications >> The ER model


Attributes and their Types

● Attribute element
● Mathematical definition for
○ normal or simple attributes
○ composite attributes
○ multivalued attributes
○ derived attributes
○ complex attributes

Database Systems and Applications >> The ER model


Key attribute, value set and NULL

● Sequel of the attribute element


● Key attribute
○ Simple
○ Complex key attributes
● The case of multiple keys
● NULL value
● Value set of attributes

Database Systems and Applications >> The ER model


Relationship basics

● Relationship element
● Set theoretic definition
● Concept for degree of a relationship

Database Systems and Applications >> The ER model


Ternary versus binary relatioship

● Examining ternary relationship types


● Compare ternary relationship types to binary
relationship types
● Alternate ways to represent ternary relationship types

Database Systems and Applications >> The ER model


Constrains and Types of
relationships
● Definition of cardinality constraint
○ 1:1
○ 1:N
○ N:M
● Definition of participation contraint
○ Total relationships
○ Partial relationships
● Identifying relationships
Database Systems and Applications >> The ER model
Relationship attributes, roles and
recursion
● Definition of a Role
● Recursive relationships
● Cases of relationships with attributes:
○ 1:1
○ 1:N
○ N:M

Database Systems and Applications >> The ER model


Alternatives of Concept Appearance

● Difference between particular ER Models


● Different representation methods for concepts
○ Representation as entity or attribute
○ Representation as entity or relationship
○ Representation as attribute or relationship

Database Systems and Applications >> The ER model


ER model examples Restaurant,
Company
● Full representation of ER Modeling
● Preparing the ER Model of a Restaurant
● Preparing the ER Model of a Company

Database Systems and Applications >> The ER model

You might also like