I2 (2 points)

https://knobit.org/id/task/dm-reverse-engineering/I2

dcterms:license	https://creativecommons.org/licenses/by/4.0/
owl:sameAs	https://bitbucket.org/reffa/ontology/id/task/dm-reverse-engineering/I2
rdfs:label	I2 (2 points) en
schema:hasPart	dm-reverse-engineering I2: declared and inferred relationships kept apart
schema:identifier	I2
schema:position	8
schema:text	Part B separates declared from inferred, 1 each: (a) the transaction-to-account relationship is marked declared (fk_txn_acct), and the holding's relationships to Account and to Customer, which no constraint declares, are RE- inferences with their match rates as evidence, a confidence and confirmed_by null; (b) the holding-to-customer inference, at 99.96% with 1,351 rows referencing no customer, gets a lower confidence than the 100% one, or its orphan rows are recorded as an open question or unknown. en

Used by

has question	Reverse engineering a banking schema, reviewed and done (reverse engineering skills)
schema:isPartOf	dm-reverse-engineering I2: declared and inferred relationships kept apart