I4 (1 points)
https://knobit.org/id/task/dm-physical-postgres/I4
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/dm-physical-postgres/I4 |
| rdfs:label | I4 (1 points) en |
| schema:hasPart | dm-physical-postgres I4: customer subtypes rolled down with no supertype |
| schema:identifier | I4 |
| schema:position | 8 |
| schema:text | Subtypes rolled down: person_customer and organisation_customer with no customer table, so account_holder.customer_id cannot have a foreign key (a polymorphic reference by customer_type), and the two identity sequences can hand out the same customer_id, which collides in account_holder's primary key. A customer table with the shared key is added; the subtype tables are keyed by customer_id with a foreign key to it; account_holder references customer; exclusivity is enforced by carrying the discriminator into the subtype keys or by a DQ rule. en |
Used by
| has question | Retail banking servicing schema on PostgreSQL (transactional physical design anomaly skills) |
|---|---|
| schema:isPartOf | dm-physical-postgres I4: customer subtypes rolled down with no supertype |