6. etapp: Füüsilise andmemudeli kujundamine
Kompetentsi Andmete modelleerimine knobit · K-653 · Teadmine
Explains referential integrity and referential actions
Mida see tähendab
Foreign keys, and what cascade, set-null and restrict do to children.
Kuidas seda hinnatakse
Chooses the referential action for sample relationships
Tugineb
- Explains relationship cardinality and optionalityK-567 · Teadmine
Vajalik
- Recognises an undeclared foreign keyK-612 · Oskus
- Recognises a referential action destroying what should surviveK-613 · Oskus
- Recognises a soft delete the constraints do not understandK-625 · Oskus
- Recognises a nullable foreign key on a reporting join pathK-628 · Oskus
- Recognises a foreign-key cycle taken as resolvedK-814 · Oskus