Database concepts
CIE A-Level Computer Science· Unit 8: Databases, Topic 1· 10 min read
1. Core Database Terminology★★☆☆☆⏱ 3 min
Entity
A distinct, identifiable object or concept that we want to store data about in a database
Example:
Common examples include students, books, orders and products
All entities have characteristics that we record, called attributes. Each attribute holds a single piece of data about an entity. A relationship describes how two or more entities are connected to each other.
Identify the entities, attributes, and one relationship for a library database storing data about books and borrowers
- 1
First, identify distinct objects the database stores data about:
- 2
Two clear entities are: 1. Book 2. Borrower
- 3
Next, list attributes for each entity:
- 4
Attributes for Book:
book_id, title, author, publication year, availability. Attributes for Borrower:borrower_id, name, contact number, join date. - 5
Finally, identify a relationship between the entities:
- 6
One relationship is: A borrower can borrow many books, and one book can be borrowed by one borrower at a time.
Exam tip:
Always name entities as nouns (not verbs) in exam answers to avoid losing marks
2. Flat-file vs Relational Databases★★☆☆☆⏱ 4 min
Two core database structures tested in CIE 9618 are flat-file and relational databases. A flat-file database stores all data in a single table or file, while a relational database splits data across multiple linked tables, one per major entity.
Flat-file Database
A database structure that stores all data in a single table or unstructured file, with no separation of related data entities
Example:
A single CSV file storing both student details and course enrollment data is a flat-file
Explain one major problem with storing all student and course data in a single flat-file table
- 1
First, notice that the same course details (e.g. course name, teacher name) will be repeated for every student enrolled in the course.
- 2
This creates redundant data: the same information is stored multiple times, which wastes storage space.
- 3
It also risks data inconsistency: if the course name changes, you have to update it in every row, and it’s easy to miss some rows, leading to conflicting data.
- 4
A relational database fixes this by splitting data into two linked tables: one for students and one for courses.
3. Data Redundancy and Consistency★★★☆☆⏱ 3 min
Two of the most frequently tested concepts in CIE database questions are redundancy and consistency. Poor database design almost always leads to issues with both, and they are regularly asked for definition questions.
Data Redundancy
The unnecessary repetition of the same data across multiple locations in a database
Example:
Storing the same customer address for every order a customer places
Data consistency means all copies of the same data in a database match each other. When data is updated, all instances must be updated to maintain consistency. Redundancy makes maintaining consistency much harder, as multiple updates are required instead of one.
A retail store stores customer order data in a flat-file where each row includes the full customer address. A customer changes their address after moving. Explain how redundancy leads to inconsistency here.
- 1
The customer’s address is stored once for every order they have placed, so it is redundantly repeated.
- 2
If the team updating the address only changes it in the most recent order row, all older order rows will still hold the old address.
- 3
This creates inconsistency: the database stores two different addresses for the same customer.
- 4
In a well-designed relational database, the address is stored once in a customer table, so only one update is needed, eliminating the risk of inconsistency.
Exam tip:
When asked to distinguish the two terms: redundancy is repeated data, inconsistency is conflicting data. Redundancy causes inconsistency
4. Role of a Database Management System (DBMS)★★☆☆☆⏱ 4 min
A DBMS is the software that manages access, organization, and security of a database. It acts as an interface between end-users, applications, and the underlying database files.
Database Management System (DBMS)
Software that provides tools for creating, modifying, querying, and securing a database, while managing interactions between users and stored data
Example:
Common examples include MySQL, PostgreSQL, Microsoft Access and Oracle
Providing a data definition language (DDL) to create and modify database structure
Providing a data manipulation language (DML) for querying and updating data
Managing concurrent access by multiple users to prevent conflicting changes
Enforcing access controls and security rules for sensitive data
Creating backups and recovering data after system failure
Enforcing data integrity constraints to ensure stored data is valid
Describe one way a DBMS improves security for a hospital patient database
- 1
A DBMS allows administrators to set granular access permissions for different user groups.
- 2
For example, a receptionist can access a patient’s contact details but not their full confidential medical history.
- 3
A treating doctor can access all of a patient’s data, while administrative billing staff can only access payment related details.
- 4
This enforced access control prevents unauthorized access to sensitive data, which is impossible to implement reliably with unmanaged flat files.
5. Common Pitfalls
Wrong move:
Confusing entities and attributes: calling 'student name' an entity instead of an attribute
Why:
Entities are the objects we store data about, while attributes are the properties of those objects
Correct move:
Check: if it is a thing you store multiple entries for, it is an entity. If it is a property of that thing, it is an attribute
Wrong move:
Claiming all flat-file databases are bad for all use cases
Why:
CIE examiners test that flat-files are appropriate for small, simple datasets
Correct move:
Acknowledge flat-files are simple and low-overhead for small use cases, but have critical issues for large, multi-user datasets
Wrong move:
Mixing up data redundancy and data inconsistency
Why:
The concepts are related but distinct, and exam questions regularly ask for separate definitions
Correct move:
Remember: Redundancy = unnecessary repeated data. Inconsistency = conflicting versions of the same data. Redundancy causes inconsistency
Wrong move:
Confusing the DBMS with the database itself
Why:
Many candidates mix up the software and the stored data
Correct move:
The database is the collection of stored data. The DBMS is the software that manages the database
Wrong move:
Drawing relationships between attributes instead of entities in schemas
Why:
Relationships are associations between whole entities, not individual attributes
Correct move:
Always connect entities, not individual attributes, in entity relationship diagrams
6. Quick Reference Cheatsheet
Concept | Core Definition |
|---|---|
Entity | Distinct object/concept to store data about |
Attribute | Property of an entity storing a single data item |
Relationship | Association between two or more entities |
Flat-file Database | All data stored in one single table/file |
Relational Database | Data split across linked tables of entities |
Data Redundancy | Unnecessary repetition of data |
Data Inconsistency | Conflicting versions of the same data |
DBMS | Software that manages database access and structure |
When this came up on past exams
AI-estimated based on syllabus patterns — cross-check with official past papers for accuracy. Use only as revision-focus signals.
- 2022 · 1
Key terminology question
- 2023 · 1
Flat-file vs relational comparison
- 2024 · 1
Role of DBMS question
Going deeper
What's Next
Now that you understand the core foundational concepts of databases, you’re ready to build on this knowledge to learn more advanced database design and management topics. Understanding these fundamentals is critical for all subsequent database work, from entity relationship diagrams to SQL query writing. Almost all CIE 9618 database exam questions build on these core terms and concepts, and you will use these ideas when identifying design problems, normalizing databases, and writing queries to extract meaningful information from structured data.