GCSE OCR Computer Science: Database Concepts Explained | GCSE OCR 计算机：数据库考点精讲

📚 GCSE OCR Computer Science: Database Concepts Explained | GCSE OCR 计算机：数据库考点精讲

Databases are the backbone of almost every modern software application, from online shops to school record systems. For the OCR GCSE Computer Science specification, you need to understand how databases are structured, how to retrieve and manipulate data using SQL, and why data integrity is so important. This revision guide breaks down every key concept with clear definitions and practical examples, helping you to feel confident in the exam hall.

数据库是几乎所有现代软件应用的基础，从网上商店到学校记录系统都是如此。在 OCR GCSE 计算机科学考试大纲中，你需要理解数据库的结构方式，如何使用 SQL 检索和操作数据，以及为什么数据完整性如此重要。这份复习指南以清晰的定义和实用的例子拆解每一个关键概念，帮助你在考场上胸有成竹。

1. What is a Database? | 什么是数据库？

A database is a structured collection of data organised so that it can be easily accessed, managed, and updated. Instead of storing information in isolated files, a database allows multiple users and applications to interact with the data consistently. The software that manages the database is called a Database Management System (DBMS), such as MySQL, PostgreSQL, or Microsoft SQL Server.

数据库是一个有组织的数据集合，经过结构化处理以便于访问、管理和更新。与将信息存储在孤立的文件中不同，数据库允许多个用户和应用程序一致地与数据交互。管理数据库的软件称为数据库管理系统（DBMS），例如 MySQL、PostgreSQL 或 Microsoft SQL Server。

2. Flat-file vs Relational Databases | 平面文件数据库与关系数据库

A flat-file database stores all data in a single table, which often leads to data duplication and inconsistencies. For example, a flat-file store of student records might repeat the same form tutor name many times. A relational database, on the other hand, splits data into multiple linked tables to reduce redundancy. Each table represents an entity, and tables are connected through shared fields, which is far more efficient and maintains data consistency.

平面文件数据库将所有数据存储在一个单独的表中，这往往导致数据重复和不一致。例如，一个存储学生记录的平面文件可能会多次重复同一位班主任的名字。而关系数据库将数据拆分到多个相互链接的表中以减少冗余。每个表代表一个实体，表之间通过共享字段进行连接，这样效率高得多，并且能够保持数据一致性。

3. Tables, Records, and Fields | 表、记录和字段

In a relational database, data is organised into tables. Each table consists of records (rows) and fields (columns). A field is a single piece of information, such as a student’s name or date of birth. A record is a complete set of fields relating to one item, such as all the data about one particular student. The structure of the table is defined in a design view where you specify the field names and their data types.

在关系数据库中，数据被组织成表。每个表由记录（行）和字段（列）组成。字段是一个单独的信息项，例如学生姓名或出生日期。记录是与一个项目相关的一整套字段，例如关于某一特定学生的所有数据。表的结构在设计视图中定义，你需要在那里指定字段名称及其数据类型。

4. Primary Keys | 主键

A primary key is a field that uniquely identifies each record in a table. No two records can have the same primary key value, and it must never be empty. Typical choices for a primary key are an automatically generated ID number or a unique username. Without a primary key, it would be impossible to guarantee which record you are referring to when updating or deleting data.

主键是唯一标识表中每条记录的字段。没有两条记录可以拥有相同的主键值，并且主键绝不能为空。主键的常见选择是自动生成的 ID 编号或独一无二的用户名。如果没有主键，在更新或删除数据时就无法保证你所指的是哪一条记录。

5. Foreign Keys and Relationships | 外键与关系

A foreign key is a field in one table that refers to the primary key of another table. This creates a relationship between the two tables. For instance, a ‘Class’ table might have a foreign key ‘TeacherID’ that matches the primary key of the ‘Teacher’ table. This link ensures referential integrity—you cannot assign a class to a teacher that does not exist in the database.

外键是一个表中的字段，它引用另一个表的主键。这样就在两个表之间建立了关系。例如，‘班级’表可能有一个外键‘教师编号’，它与‘教师’表的主键相匹配。这种链接确保了参照完整性——你不能将班级分配给数据库中不存在的教师。

6. Introduction to SQL | SQL 简介

SQL (Structured Query Language) is the standard language for interacting with relational databases. It allows you to create tables, insert records, retrieve data, update values, and delete entries. For the OCR GCSE exam, you need to be able to read, understand, and write simple SQL statements. The most common commands you will use are SELECT, FROM, WHERE, ORDER BY, INSERT INTO, UPDATE, and DELETE.

SQL（结构化查询语言）是与关系数据库交互的标准语言。它允许你创建表、插入记录、检索数据、更新值和删除条目。在 OCR GCSE 考试中，你需要能够阅读、理解和编写简单的 SQL 语句。你将使用的最常见命令包括 SELECT、FROM、WHERE、ORDER BY、INSERT INTO、UPDATE 和 DELETE。

7. Retrieving Data with SELECT | 使用 SELECT 检索数据

The SELECT statement is used to retrieve specific fields from a table. You can select all fields using the asterisk (*) wildcard, or specify the exact columns you need. For example, SELECT FirstName, LastName FROM Students; returns only the first and last names. Always think about which fields the question is asking for—do not return unnecessary data.

SELECT 语句用于从表中检索特定字段。你可以使用星号（*）通配符选择所有字段，或者指定你需要的具体列。例如，SELECT FirstName, LastName FROM Students; 只返回名字和姓氏。始终要考虑题目要求哪些字段——不要返回不必要的数据。

8. Filtering with WHERE and Sorting with ORDER BY | 使用 WHERE 筛选与 ORDER BY 排序

The WHERE clause filters records based on one or more conditions. You can use operators such as =, >, <, >=, <=, and <>, as well as AND, OR, and NOT. For instance, SELECT * FROM Products WHERE Price > 10 AND Category = ‘Electronics’;. The ORDER BY clause sorts the results; ORDER BY Price DESC would display the most expensive products first. Remember that text values must be enclosed in single quotes.

WHERE 子句根据一个或多个条件筛选记录。你可以使用 =、>、<、>=、<= 和 <> 等运算符，以及 AND、OR 和 NOT。例如，SELECT * FROM Products WHERE Price > 10 AND Category = ‘Electronics’;。ORDER BY 子句对结果进行排序；ORDER BY Price DESC 会首先显示最贵的产品。请记住，文本值必须用单引号括起来。

9. Inserting, Updating, and Deleting Data | 插入、更新与删除数据

To add a new record, use INSERT INTO. The syntax is INSERT INTO TableName (Field1, Field2) VALUES (Value1, Value2);. To modify existing records, use UPDATE with SET and WHERE: UPDATE Students SET YearGroup = 11 WHERE StudentID = 105;. To remove records, use DELETE FROM with a WHERE condition: DELETE FROM Orders WHERE OrderDate < '2023-01-01';. Always be careful with UPDATE and DELETE—without a WHERE clause, all records are affected.

要添加新记录，使用 INSERT INTO。语法是 INSERT INTO TableName (Field1, Field2) VALUES (Value1, Value2);。要修改现有记录，使用 UPDATE 配合 SET 和 WHERE：UPDATE Students SET YearGroup = 11 WHERE StudentID = 105;。要删除记录，使用 DELETE FROM 并带有 WHERE 条件：DELETE FROM Orders WHERE OrderDate < '2023-01-01';。使用 UPDATE 和 DELETE 时要格外小心——如果没有 WHERE 子句，所有记录都会受到影响。

10. Data Integrity and Validation | 数据完整性与验证

Data integrity means that the data in the database is accurate, consistent, and reliable. It is maintained through several methods: field validation rules (e.g., range checks, format checks, presence checks), referential integrity enforced by foreign keys, and transaction processing that ensures all steps complete or none happen. In exams, you might be asked to suggest validation techniques for a given field, such as a length check for a postcode or a type check for a numeric age.

数据完整性意味着数据库中的数据是准确、一致和可靠的。它通过多种方法来维护：字段验证规则（例如范围检查、格式检查、存在性检查），通过外键实施的参照完整性，以及确保所有步骤都完成或全都不发生的事务处理。在考试中，你可能需要针对给定的字段建议验证技术，例如对邮政编码进行长度检查，或者对数字年龄进行类型检查。

11. Indexes and Performance | 索引与性能

An index works like the index of a book: it allows the DBMS to find records much faster without scanning the entire table. A primary key is automatically indexed. You can add indexes to other fields that are frequently searched, such as a customer’s surname. However, indexes take up extra storage space and slow down insert and update operations, so they must be used thoughtfully. This trade-off is sometimes covered in higher-tier GCSE questions.

索引就像一本书的索引：它使数据库管理系统能够更快地找到记录，而无需扫描整个表。主键会自动被索引。你可以为其他经常被搜索的字段添加索引，例如客户的姓氏。然而，索引会占用额外的存储空间，并减慢插入和更新的操作，因此必须谨慎使用。这种权衡有时会在 GCSE 高阶的题目中出现。

12. Exam Tips and Common Pitfalls | 考试技巧与常见错误

When writing SQL in the exam, make sure you spell commands correctly and end with a semicolon. Use single quotes for text, not double quotes. In database design questions, always identify the most suitable primary key and explain why it must be unique. Avoid confusing a flat-file database with a relational one: flat-file means one table, relational means multiple linked tables. Finally, practice questions that ask you to produce the result of a query given a small table—these are common and test your logical thinking.

在考试中编写 SQL 时，确保正确拼写命令并以分号结尾。对文本使用单引号，而不是双引号。在数据库设计题目中，总是要确定最合适的主键，并解释为什么它必须唯一。避免将平面文件数据库与关系数据库混淆：平面文件意味着一个表，关系数据库意味着多个相互链接的表。最后，多做那种给你一个小表，要求你写出查询结果的题目——这类题目很常见，并且考查你的逻辑思维。

Published by TutorHao | Computer Science Revision Series | aleveler.com

更多咨询请联系16621398022（同微信）

GCSE OCR Computer Science: Database Concepts Explained | GCSE OCR 计算机：数据库 考点精讲