Question
Give two advantages of storing data in a relational database instead of a flat file.
Mark scheme — two of:
- Reduces data redundancy — data stored once in one table, referenced by foreign keys (B1)
- Avoids update anomalies — change data in one place and it is consistent everywhere (B1)
- Easier to query related data across multiple tables using SQL joins (B1)
- Better data integrity — constraints prevent invalid data being stored (B1)
2 marks · take your time before peeking.
Sign up to try the next 30 problems
Save your streak, mark answers against the spec, and build a daily revision habit. Free during public beta — no card, no auto-renew.
Generated by TopMyGrade AI · cross-check official sources before relying on the mark-scheme phrasing.