Study guides / ISC: Information Systems & Controls / Data management
Data management
ISC: Information Systems & Controls · quick review
Covers how data is structured, stored, moved and queried, and the controls that keep it complete, accurate and usable for reporting and analytics.
The rules
- Relational databases: tables with primary keys (unique rows) and foreign keys (links to other tables). Normalization reduces redundancy and update anomalies.
- Integrity: entity integrity (every row has a unique, non-null key), referential integrity (no orphan foreign keys), and domain constraints (valid values).
- ETL: extract from sources, transform (clean, standardize, validate), load into the warehouse. Reconcile record counts and totals at each step.
- Data types: structured (tables), semi-structured (JSON, XML), unstructured (documents, images, audio).
- SQL: SELECT fields FROM tables WHERE conditions (AND, OR, IS NULL), with JOINs across tables and GROUP BY with aggregate functions.
Common traps
- A data lake stores raw data in native formats. A data warehouse stores cleaned, structured data for reporting.
- An INNER JOIN drops rows without a match in both tables, which can make an analysis silently incomplete.
- Data governance assigns ownership and stewardship. It isn't just an IT function.
How it's tested
Read simple SQL, identify keys and integrity controls, and explain ETL and data types. Expect document review simulations on data dictionaries or queries.
Practise it
The full lesson, worked examples and practice questions are in Tickmark, where every answer choice is explained.
Open the full lesson