Exercise
Three questions about your data
Ask the chatbot to use your idea and three fictional records to explain the terms.
Prompt to start
Use my chosen idea to explain data model, unique identifier and source of truth with three fictional records. What does each row or item represent? How do we recognise the same record across sources and distinguish similar records? Which source supplies a detail when files disagree, and which exceptions need a person? Ask me to correct your assumptions. Then help me write input, transformation, output and independent check in one line each. My idea: [describe it].
Steps
- Ask what each row or item represents and which details it needs. That is part of the data model.
- Ask which unique identifier keeps similar records apart or matches one record across files.
- Ask which source supplies each detail when files disagree, and who resolves exceptions.
- Correct the assumptions, then write one line each for input, transformation, output and independent check.
For a page that has no rows of data, describe its inputs and rules. For a checklist, an item ID is a starting point. For a form, name the fields and the rule for accepting each entry.
Check your result
- Two similarly named records can be kept apart using their IDs.
- Your plan states the rule for a disagreement and a result you can check yourself.