5. etapp: Loogilise andmemudeli tuletamine
Kompetentsi Andmete modelleerimine knobit · K-522 · Oskus
Recognises a polymorphic association
Mida see tähendab
One reference attribute pointing to different entities depending on the value of a type attribute. There is no single parent, so the relationship has no cardinality, no optionality and no rule, and the physical model cannot declare a foreign key. A specific form of row 6.
Kuidas seda hinnatakse
Flags the deficient case and passes the acceptable one. Deficient: Case Note with Owner Id and Owner Type (`ACCOUNT`, `PAYMENT`, `PARTY`) Acceptable: One relationship per parent (Case Note → Account, Case Note → Payment), each with its rule, plus a rule that exactly one is set; or a supertype the parents share, only if they pass row 27's test (`LOG-012` when Owner Id has the `foreign-key` role; review only otherwise)
Tugineb
- Explains relationship cardinality and optionalityK-567 · Teadmine
- Explains attribute domainsK-562 · Teadmine
Vajalik
- Puudub