📚 IGCSE Computer Science: Database Essentials | IGCSE 计算机：数据库考点精讲
A database is a central topic in the IGCSE Computer Science syllabus, covering the theory of relational databases, key terminology, and practical SQL querying. This article walks you through every essential concept you need to master for your exam, from tables and keys to SELECT statements and aggregate functions. Whether you are studying for CAIE 0478, Edexcel, or Oxford AQA, these core ideas remain the same and form the foundation for further study in data management.
数据库是 IGCSE 计算机科学大纲的核心主题，涉及关系数据库理论、关键术语以及实用的 SQL 查询。本文带你逐一梳理考试必须掌握的所有重要概念，从表、键到 SELECT 语句和聚合函数。无论你备考的是 CAIE 0478、Edexcel 还是牛津 AQA，这些核心思想完全一致，并为后续的数据管理学习奠定基础。
1. What is a Database? | 什么是数据库？
A database is an organised collection of data stored electronically so that it can be easily accessed, searched, and updated. Instead of keeping information in separate files, a database brings all related data together under a structured system. In IGCSE we focus on relational databases, where data is stored in tables that can be linked through key fields.
数据库是以电子方式存储的有组织的数据集合，方便访问、搜索和更新。它不是把信息分散在各个文件中，而是将所有相关数据汇集到一个结构化的系统下。IGCSE 重点介绍关系型数据库，数据储存在可以通过关键字段链接起来的表中。
Every table represents a specific entity, such as ‘Student’ or ‘Order’. The power of a database lies in its ability to connect these tables, avoid duplication, and ensure data consistency. You will be expected to explain how real-world problems can be modelled using tables and relationships.
每张表代表一个具体的实体，例如 “学生” 或 “订单”。数据库的真正威力在于能够连接这些表、避免重复并确保数据一致性。你需要能够解释如何用表和关系来为现实世界的问题建模。
2. Key Terminology: Table, Record, Field | 关键术语：表、记录、字段
The three fundamental units of any database are:
任何数据库的三个基本单位是：
Table – a grid-like structure that holds data about one subject, made up of rows and columns. Record (or row, tuple) – a single entry in a table representing one specific instance, e.g. all information about one student. Field (or column, attribute) – a single category of data stored in a table, such as a student’s date of birth. Each field has a unique name within its table and a defined data type.
表 — 一种类似网格的结构，存放关于某一主题的数据，由行和列构成。记录（或行、元组）— 表中的一条独立条目，代表一个具体的实例，例如一名学生的全部信息。字段（或列、属性）— 表中存储的单一数据类别，如学生的出生日期。每个字段在表内有唯一的名称和明确的数据类型。
Exam boards expect you to identify these elements in a sample table and use the correct technical vocabulary. For example, in a ‘Products’ table, ‘ProductName’ is a field, while a complete row about product code P123 is a record.
考试要求你能在示例表中识别这些元素并正确使用专业术语。例如，在 “产品” 表中，“产品名称” 是一个字段，而产品代码 P123 的完整一行就是一条记录。
3. Database Management System (DBMS) | 数据库管理系统
A Database Management System (DBMS) is the software that allows users to create, manipulate, and control access to databases. Examples you might encounter include Microsoft Access, MySQL, and SQLite. The DBMS handles security, backup, concurrent access, and data integrity, acting as the interface between the user and the physical data.
数据库管理系统 是允许用户创建、操作和控制数据库访问的软件。你可能遇到的例子包括 Microsoft Access、MySQL 和 SQLite。DBMS 负责处理安全、备份、并发访问和数据完整性，它充当用户与物理数据之间的接口。
In the exam, you should be able to describe the role of a DBMS and contrast it with a simple file store. A key advantage is that the DBMS provides a data dictionary that stores metadata (data about data), such as field names, data types, and validation rules. This makes the database self-describing and much easier to maintain.
在考试中，你应该能够描述 DBMS 的作用并将其与简单的文件存储进行对比。一个关键优势是 DBMS 提供了一个数据字典，用于存储元数据（关于数据的数据），如字段名称、数据类型和验证规则。这使得数据库能够自我描述，并大大简化了维护工作。
4. Data Types and Field Properties | 数据类型与字段属性
Every field in a database is assigned a specific data type to enforce the kind of information it can hold. This is crucial for storage efficiency and data validation. Common data types tested at IGCSE include:
数据库中的每个字段都被赋予特定的数据类型，以限制其可容纳的信息种类。这对于存储效率和数据验证至关重要。IGCSE 常考的数据类型包括：
Integer – whole numbers, e.g. 25. Real / Float – numbers with decimal points, e.g. 3.14. Text / String – letters, numbers and symbols, e.g. ‘A28’. Date / Time – calendar dates or times. Boolean – only two possible values (TRUE/FALSE, Yes/No).
整型 — 整数，如 25。实型 / 浮点型 — 带小数点的数，如 3.14。文本 / 字符串 — 字母、数字和符号，如 “A28”。日期 / 时间 — 日历日期或时间。布尔型 — 仅两个可能的值（真/假，是/否）。
Additionally, fields can have properties like field size, format, or default value. For example, a field storing a phone number might be set as Text with a length limit of 15 characters, not as Integer, because leading zeros matter. Choosing the right data type reduces errors and improves accuracy.
此外，字段还可以拥有诸如字段大小、格式和默认值等属性。例如，存储电话号码的字段可能设置为长度限制为 15 个字符的文本型，而不是整型，因为前导零很重要。选择正确的数据类型能减少错误并提高准确性。
5. Primary Keys and Foreign Keys | 主键与外键
A primary key is a field (or combination of fields) that uniquely identifies each record in a table. No two records can have the same primary key value, and it must never be left blank. Typically, a numeric ID field such as ‘StudentID’ serves as the primary key. In exams, you may be asked to suggest a suitable primary key for a given table.
主键 是一个字段（或字段组合），用于唯一标识表中的每条记录。任何两条记录的主键值都不能相同，且主键绝不允许留空。通常，像 “学生ID” 这样的数字编号字段充当主键。考试中，你可能会被要求为给定的表建议一个合适的主键。
A foreign key is a field in one table that refers to the primary key in another table. It creates a relationship between the two tables. For instance, an ‘Orders’ table might contain ‘CustomerID’ as a foreign key, linking each order to the correct customer in the ‘Customers’ table. This link is the core of relational databases.
外键 是某个表中的一个字段，它引用了另一个表的主键。它在这两个表之间建立关系。例如，“订单” 表可能包含 “客户ID” 作为外键，将每笔订单与 “客户” 表中正确的客户关联起来。这种链接正是关系数据库的核心。
6. Data Redundancy and Integrity | 数据冗余与完整性
Data redundancy occurs when the same piece of data is stored in multiple places. This is a problem because it wastes storage space and can lead to inconsistency if one copy is updated but another is not. Well-designed databases use relationships and separate tables to minimise redundancy, a process called normalisation.
当同一数据项被存储在多个地方时，就会出现数据冗余。这会浪费存储空间，而且如果更新了其中一个副本而遗漏了另一个，就会导致数据不一致。设计良好的数据库利用关系与独立表来最大限度地减少冗余，这一过程称为规范化。
Data integrity means the data is accurate, consistent and valid. DBMS features such as primary keys (preventing duplicate records), foreign keys (ensuring valid links) and validation rules (restricting what can be entered) all help maintain integrity. For the exam, be ready to explain how a DBMS prevents invalid data entry and why integrity matters in applications like banking.
数据完整性 是指数据准确、一致且有效。主键（防止重复记录）、外键（确保有效的链接）和验证规则（限制可输入的内容）等 DBMS 特性都有助于维护完整性。为考试做好准备，要能够解释 DBMS 如何阻止无效数据输入以及为什么完整性在银行等应用中至关重要。
7. Introduction to SQL | SQL 简介
Structured Query Language (SQL) is the standard language for interacting with relational databases. At IGCSE level you are only required to write data retrieval statements using SELECT. SQL is declarative: you describe what data you want, and the DBMS works out how to get it. The basic structure of an SQL query is:
结构化查询语言 (SQL) 是与关系型数据库交互的标准语言。在 IGCSE 阶段，你只需要编写使用 SELECT 的数据检索语句。SQL 是声明式的：你只需描述想要什么数据，DBMS 会自行决定如何获取。SQL 查询的基本结构如下：
SELECT field1, field2 FROM TableName;
This statement selects the specified fields from the table. The semicolon marks the end of the command. You will not be tested on INSERT, UPDATE, or DELETE in most IGCSE specifications, but understanding the logical flow of a SELECT query is vital.
该语句从表中选取指定的字段。分号标志着命令的结束。大多数 IGCSE 大纲不会考查 INSERT、UPDATE 或 DELETE，但理解 SELECT 查询的逻辑流程至关重要。
8. Querying Data with SELECT and WHERE | 使用 SELECT 与 WHERE 查询数据
The real power of SQL comes from filtering records to display only those that meet certain criteria. The WHERE clause follows the FROM clause and introduces a condition. For example, to retrieve the names of all students with a grade higher than 80, you write:
SQL 的真正威力在于筛选记录，只显示满足特定条件的那些。 WHERE 子句紧跟在 FROM 子句之后，引出一个条件。例如，要检索所有分数高于 80 分的学生的姓名，编写如下：
SELECT StudentName FROM Students WHERE Grade > 80;
Conditions can use the operators =, <>, <, >, <=, >=, and logical operators AND, OR, NOT. For instance, WHERE Grade >= 90 AND Class = ’10A’ retrieves high-achieving students only in that class. Text values must be enclosed in single quotes ‘ ‘.
条件中可以使用 =、<>、<、>、<=、>= 等运算符以及逻辑运算符 AND、OR、NOT。例如， WHERE Grade >= 90 AND Class = ’10A’ 只检索该班级中成绩优异的学生。文本值必须放在单引号 ‘ ‘ 中。
When you write a WHERE clause, the DBMS checks each record against the condition; only records for which the condition is true are included in the result. You may also need to combine multiple tables in the exam, but the core skill is the single-table query with filtering.
当你编写 WHERE 子句时，DBMS 会针对条件检查每条记录；只有条件为真的记录才会被包含在结果中。考试中可能还需要组合多个表，但核心技能是带筛选的单表查询。
9. Sorting Data with ORDER BY | 使用 ORDER BY 排序数据
Often you need to present query results in a specific order. The ORDER BY clause enables you to sort the output by one or more fields. By default, sorting is ascending (ASC), but you can specify DESC for descending order. Example:
你经常需要按特定顺序呈现查询结果。ORDER BY 子句允许你按一个或多个字段对输出进行排序。默认排序为升序 (ASC)，但你可以用 DESC 指定降序。示例：
SELECT ProductName, Price FROM Products ORDER BY Price DESC;
This returns all product names and prices, listed from the most expensive to the cheapest. You can sort by more than one column: ORDER BY Category ASC, Price DESC would sort first by category alphabetically, and within the same category by price descending.
这会返回所有产品名称和价格，并按从最贵到最便宜的顺序排列。你可以按多列排序： ORDER BY Category ASC, Price DESC 会先按类别字母顺序排序，然后在同一类别内按价格降序排列。
When tackling exam questions, carefully check whether the question asks for alphabetical, numerical, or chronological order. Remember that ORDER BY must come after the WHERE clause if both are present.
在回答考题时，要仔细检查题目要求的是字母顺序、数值顺序还是时间顺序。请记住，如果 WHERE 子句和 ORDER BY 同时存在，ORDER BY 必须放在 WHERE 子句之后。
10. Aggregate Functions and GROUP BY | 聚合函数与分组
Aggregate functions perform a calculation on a set of values and return a single value. The IGCSE syllabus covers these functions:
聚合函数对一组值执行计算并返回单一值。IGCSE 大纲涵盖以下函数：
COUNT – returns the number of records. SUM – returns the total of a numeric column. AVG – returns the average of a numeric column. MAX – returns the highest value. MIN – returns the lowest value.
COUNT — 返回记录的数量。SUM — 返回数字列的总和。AVG — 返回数字列的平均值。MAX — 返回最高值。MIN — 返回最低值。
These are often used with GROUP BY to perform calculations on subgroups. For example, to find out how many students are in each class, you write:
它们经常与 GROUP BY 一起使用，以对子组执行计算。例如，要查明每个班级有多少学生，编写如下：
SELECT Class, COUNT(*) FROM Students GROUP BY Class;
Here, COUNT(*) counts all records in each group defined by Class. In the exam, you might see a table with sales data and be asked to write a query that calculates the total sales per region. The pattern is always SELECT Region, SUM(Amount) FROM Sales GROUP BY Region;
这里的 COUNT(*) 计算每个由 Class 定义的分组中的所有记录。考试中，你可能会看到一张销售数据表，并被要求编写一个查询，计算每个地区的销售总额。模式始终是 SELECT Region, SUM(Amount) FROM Sales GROUP BY Region;。
A common mistake is forgetting that any field not in the GROUP BY clause must be inside an aggregate function. Fix this, and your queries will be both syntactically correct and logically sound.
一个常见的错误是忘记：任何未出现在 GROUP BY 子句中的字段，都必须放在聚合函数里面。纠正这一点，你的查询就能既语法正确又逻辑合理。
11. Database vs File-Based Systems | 数据库与文件系统对比
Before databases, organisations stored data in flat files. IGCSE expects you to compare the two approaches. A file-based system stores data in separate, unrelated files, often leading to data duplication and inconsistency. If a customer’s address changes, it must be updated in every file that contains the address, or it becomes unreliable.
在数据库出现之前，组织通常将数据存储在平面文件中。IGCSE 要求你对这两种方式进行对比。文件系统将数据存储在互不关联的独立文件中，往往导致数据重复和不一致。如果客户的地址发生变化，就必须在每个包含该地址的文件中都进行更新，否则数据就变得不可靠。
Databases offer centralised control, reduced redundancy, improved data integrity, and better security through user permissions. Queries can combine data from multiple tables instantly, whereas a file system would require complex programming. On the downside, databases can be more complex and expensive to set up, but for most modern applications the advantages far outweigh the costs.
数据库提供集中控制、更少的冗余、更好的数据完整性，以及通过用户权限实现的更高安全性。查询可以即时组合来自多个表的数据，而文件系统则需要复杂的编程。缺点方面，数据库的搭建可能更加复杂且代价更高，但对大多数现代应用而言，其优势远远超过成本。
Published by TutorHao | Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导