1 Database Flashcards on From ER to the relational model, created by linneamd on 14/03/2016.
|
Created by linneamd
over 8 years ago
|
|
Close
|
|
Created by linneamd
over 8 years ago
|
|
How would you change this to a relational schema?
Translate to a relational model
Translate to relational model
Translate using 3 relations
Translate using 3 relations
What should you do when you have:
Entity type -> Relation.
What should you do when you have:
Weak entity type -> Relation.
What should you do when you have:
One-to-many relationship
What should you do when you have:
Many-to-many relationship
ER to relational:
Entity type
ER to relational:
1:1 or 1:N relationship type
ER to relational:
M:N relationship type
ER to relational:
n-ary relationship type
ER to relational:
Simpel attribute
ER to relational:
Composite attribute
ER to relational:
Multivalued attribute
ER to relational:
Value set
ER to relational:
Key attribute
What 3 elements defines a trigger?
