1 Database Karteikarten am From ER to the relational model, erstellt von linneamd am 14/03/2016.
|
Erstellt von linneamd
vor mehr als 8 Jahre
|
|
Schließen
|
|
Erstellt von linneamd
vor mehr als 8 Jahre
|
|
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?
