In short
A relational database stores data in tables of rows (records) and columns (fields). Tables are linked by keys: a primary key identifies each row, and a foreign key refers to the primary key of another table.
Key takeaways
- Data is queried with Structured Query Language (SQL).
- Normalization organizes tables to reduce duplicate data and update errors.
- Referential integrity prevents records that point to rows that don't exist, such as an invoice for a missing customer.
Where it's tested
ISC: Data Management & Governance — study notes, a five-minute revision sheet and practice questions.
Practise: 3 questions
Question 1 of 3 · 0 answered
Who is normally accountable for approving which users may access a particular set of financial data?