C1 (3 points)
https://knobit.org/id/task/ddl-review/C1
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/ddl-review/C1 |
| rdfs:label | C1 (3 points) en |
| schema:hasPart | ddl-review C1a and Q1b: fixes routed upstream, no hand edits |
| schema:hasPart | ddl-review C1b and C1c: objects in the SQL and not in the model |
| schema:identifier | C1 |
| schema:position | 1 |
| schema:text | The DDL is output, not source, 1 point each: (a) no finding's fix is an edit to the .sql - every one routes to the model, the config, a DQ rule or the deployment, and none says to change the SQL by hand; (b) ck_application_amount_positive is in the Postgres SQL and in no part of the model, so it is identified as an object regeneration would destroy and moved into the model; (c) ix_fct_application_status appears in both files and in no part of the model, so it is identified the same way - and the answer does not treat it as a design question about indexing. en |