Conceptual
Modeling
Basics: Review and
Practice
Orlando Karam
[email protected]
W hat weve covered
2
Practice: Person
Produce an ER diagram for the following
situation:
We have only one entity, called
Databases, okaram
ER Modeling Examples and Exercises
1 of 4
ER Modeling - Examples and Exercises
Here we will present several example situations for you to model as ER diagrams. To
save on space, we a
Databases, okaram
ER Examples
1 of 1
More ER Examples
Produce ER diagrams for the following situations:
1. We want to model information about Cars and their Owners (the people who
own them).
For each
Databases, okaram
ER Modeling
1 of 13
Entity-Relationship (ER) Modeling
The first step to develop any application is to understand what is the problem the
application is supposed to solve and what fun
5013-Databases
ER Modeling
1/14
Entity-Relationship (ER) Modeling
The first step to develop any application is to understand what is the problem the
application is supposed to solve and what functiona
Databases, okaram
Advanced ER Modeling
1 of 10
Advanced ER Modeling
1 Weak Entities
We expect all entities to have an identifier, that is a set of attributes that is guaranteed to
distinguish that ent
Advanced ER Models
Orlando Karam
SPSU
Topics
Recursive relationships
Weak entities
Associative entities
Ternary Relationships
Recursive Relationships
Two or more of the entities in the
relationsh
Conceptual
Modeling
Entity Relationship
Diagrams
Orlando Karam
[email protected]
Business Rules
Business Rule: Statement that constrains
certain aspects of the business
Assert business structure or
C
Conceptual
Modeling
More practice
Orlando Karam
[email protected]
W hat weve covered
2
Practice: CD 1
We want to model a CD as an entity. The only entity
is the CD and everything else is modeled as
att
Databases, okaram
ER Modeling Examples and Exercises
1 of 1
ER Modeling - Examples and Exercises
To save on space, we assume the convention that every field named id is the identifier
of an entity.
1.
Database Normalization
What is Normalization
Normalization is part of successful database
design. Without normalization, database
systems can be inaccurate, slow, and
inefficient and they might not p