Option A: Databases

students, imagine your school needs to keep track of thousands of students, subjects, grades, and library books 📚. If all this information were stored on paper, finding one student’s record could take a long time, and mistakes would be easy to make. Databases solve this problem by storing data in a structured way so it can be searched, updated, and shared efficiently. In this lesson, you will learn the main ideas behind databases, the key terminology, and how to apply IB Computer Science SL reasoning to real situations.

Objectives:

• Explain the main ideas and terminology behind databases.
• Apply database reasoning to practical examples.
• Connect databases to the broader Option Topic Bank.
• Summarize why databases matter in computer systems.
• Use evidence and examples to support answers in IB-style contexts.

What a Database Is and Why It Matters

A database is an organized collection of related data. A database is designed so that data can be stored, retrieved, and managed efficiently. In real life, databases are used in banks, hospitals, schools, online shops, airline systems, and social media platforms 🌍.

For example, when students books a movie ticket online, the system may check a database for seat availability, reserve the seat, and store the booking. Without a database, that process would be slow and unreliable. Databases are especially useful when many users need access to the same data at the same time.

A common type of database in IB Computer Science is the relational database. In a relational database, data is stored in tables. Each table represents one type of object, such as students or books. Tables are connected through shared fields, which allows the database to combine information from multiple tables.

Key terminology

• Table: A collection of related data arranged in rows and columns.
• Record: One row in a table, representing one item or entity.
• Field: One column in a table, representing one attribute.
• Primary key: A field that uniquely identifies each record.
• Foreign key: A field that links one table to another.
• Query: A request to search, retrieve, insert, update, or delete data.
• Relationship: A connection between tables.

For example, a school database may have a Students table with fields like StudentID, Name, and YearGroup. Here, $\text{StudentID}$ could be the primary key because every student needs a unique identifier. Another table, Results, might include a StudentID field as a foreign key so each grade can be linked to the correct student.

Tables, Keys, and Relationships

To understand databases well, students, you need to see how tables work together. In a relational database, each table should store one main type of data. This reduces repetition and helps keep information accurate.

Suppose a school keeps all data in one giant table:

• student name
• subject name
• teacher name
• grade
• classroom

This may seem simple at first, but it creates repeated data. If one student takes five subjects, their name appears five times. If the teacher changes rooms, the same information must be updated in several places. This can cause errors.

Instead, the school can split data into separate tables:

• Students table
• Subjects table
• Teachers table
• Grades table

The Grades table can link to the others using foreign keys. This design is more efficient because each piece of information is stored once. It also makes updates easier.

Example of a relationship

Imagine these two tables:

Students

• $\text{StudentID}$
• $\text{Name}$
• $\text{Class}$

Results

• $\text{ResultID}$
• $\text{StudentID}$
• $\text{Subject}$
• $\text{Grade}$

The field $\text{StudentID}$ in Students is the primary key. The same field in Results is a foreign key. This creates a one-to-many relationship: one student can have many results.

This structure helps a database answer questions like:

• Which subjects does students take?
• What is students’s grade in Mathematics?
• How many students achieved a grade of $\text{7}$?

These questions are answered using queries.

Database Design: Avoiding Problems

Good database design improves speed, accuracy, and storage efficiency. A major idea in database design is normalization. Normalization is the process of organizing data to reduce redundancy and avoid update problems.

Why redundancy is a problem

Redundancy means the same data is stored more than once. This can cause:

• Update anomalies: A change must be made in many places.
• Insertion anomalies: New data cannot be added easily.
• Deletion anomalies: Deleting one record accidentally removes important information.

For example, if a teacher’s phone number is repeated in 200 student records, changing the number means editing 200 rows. If one row is missed, the database becomes inconsistent.

Normalization often involves separating data into related tables. In IB contexts, you are usually expected to understand the idea of normalization rather than perform advanced normalization steps in detail. The key point is that good design reduces duplication and makes data more reliable ✅.

Data types and validation

Each field should use an appropriate data type. A data type defines what kind of value a field can store.

Examples:

• $\text{INTEGER}$ for whole numbers
• $\text{TEXT}$ for names
• $\text{DATE}$ for dates
• $\text{BOOLEAN}$ for true/false values

Validation checks whether input data is sensible before it is stored. Common validation methods include:

• Range check: Ensures a value is within limits, such as $0 \leq \text{mark} \leq 100$.
• Length check: Ensures the number of characters is correct.
• Format check: Ensures data matches a pattern, such as an email address.
• Presence check: Ensures a field is not left blank.

Verification is different from validation. Validation checks whether data is reasonable; verification checks whether data has been entered correctly. For example, double entry helps verify that two typed versions match.

Queries, SQL, and Working with Data

A database is useful only if you can retrieve and manipulate its data efficiently. This is where queries and SQL are important. SQL stands for Structured Query Language, and it is the standard language used to interact with relational databases.

Common SQL actions

• SELECT: Retrieve data
• INSERT: Add new records
• UPDATE: Change existing records
• DELETE: Remove records

For example, a school may want to list all students in Year 12. The database might use a query such as:

$$\text{SELECT * FROM Students WHERE YearGroup = 12;}$$

This means: show all fields from the Students table where $\text{YearGroup} = 12$.

A more focused query could look for one student by ID:

$$\text{SELECT Name, Class FROM Students WHERE StudentID = 1045;}$$

This returns only the fields needed. Efficient queries matter because large databases may contain millions of records.

Why queries matter in real life

A hospital may use queries to find patients with a certain blood type. An online store may use them to show products in stock. A transport app may use them to check whether a bus is arriving soon. In each case, the database is not just storing information; it is helping people make decisions quickly 🚀.

students, IB exam questions may ask you to explain why a query is useful or to predict the result of a query. Always look carefully at the conditions in the WHERE clause, the fields selected, and whether the result is sorted or grouped.

Database Security, Integrity, and Control

Databases often contain sensitive data, so security is essential. Protecting data is part of good system design and also helps maintain trust.

Important security ideas

• Authentication: Checking who the user is, often with a password or biometrics.
• Authorization: Deciding what the user is allowed to do.
• Access control: Limiting who can read or change data.
• Encryption: Converting data into a form that cannot be understood without a key.
• Backup: Keeping a copy of the database in case data is lost.

For example, a school receptionist may be allowed to view student contact details but not health records. A teacher may be allowed to enter grades but not delete student accounts. This is authorization in action.

Data integrity means the data is accurate and consistent. Primary keys help integrity because they make each record unique. Foreign keys help because they keep table links valid. If a Results table contains a StudentID that does not exist in the Students table, the database has a referential integrity problem.

Databases in the Broader Option Topic Bank

Option Topic Bank gives schools flexibility to study one specialized extension topic in greater depth. Databases fit perfectly in this option because they show how data can be stored, organized, and used in practical systems. They connect to many other areas of computer science:

• Hardware and software: Databases run on servers and are managed by DBMS software.
• Networks: Many databases are accessed over networks, including cloud systems.
• Programming: Programs often read from and write to databases.
• Ethics and privacy: Databases may contain personal information, so responsible use matters.

A DBMS is a Database Management System. It is software that helps users create, manage, and control a database. Examples include MySQL, PostgreSQL, and Microsoft Access. The DBMS handles tasks like storing data, running queries, enforcing rules, and supporting multiple users.

This topic is important because real systems depend on reliable data. Whether students is using a phone app, a school portal, or an online bank account, a database is often working behind the scenes.

Conclusion

Databases are a core part of modern computing because they store related information in a structured, efficient, and reliable way. In Option A, students should understand tables, records, fields, keys, relationships, queries, validation, normalization, security, and data integrity. These ideas help explain how systems manage information in real life and why relational databases are so widely used. In IB Computer Science SL, strong database understanding supports both theory and application, especially when analyzing scenarios and choosing suitable data structures.

Study Notes

• A database is an organized collection of related data.
• In a relational database, data is stored in tables made of records and fields.
• A primary key uniquely identifies each record.
• A foreign key links one table to another.
• A one-to-many relationship means one record in one table can match many records in another table.
• Normalization reduces redundancy and helps prevent update, insertion, and deletion anomalies.
• Validation checks whether data is sensible; verification checks whether data was entered correctly.
• Common validation checks include range, length, format, and presence checks.
• SQL is used to query and manage data in relational databases.
• SELECT, INSERT, UPDATE, and DELETE are common SQL actions.
• Database security includes authentication, authorization, encryption, access control, and backups.
• Data integrity means the data remains accurate and consistent.
• DBMS software helps create, manage, and control databases.
• Databases are used in schools, banks, hospitals, transport systems, and online services.
• Option A connects to the broader Option Topic Bank because it shows how specialized computing systems solve real-world problems.