International Baccalaureate IB Computer Science

Explain the features, benefits and limitations of a relational database.
- Features: composite keys, foreign keys, primary keys, relationships, tables
- Benefits: community support, concurrency control, data consistency, data integrity, data retrieval, reduced data duplication, reduced redundancy, reliable transaction processing, scalability, security features
- Limitations: “big data” scalability issues, design complexity, hierarchical data handling, rigid schema, object‑relational impedance mismatch, unstructured data handling.