CIE Computer Science IGCSE - Unit 2. Databases

The second unit of the course contains a PDF document you can use directly in your lessons. Includes a 27-page document divided into three sections:

• 1. Introduction to databases
• 2. Data validation
• 3. Structured Query Language, SQL

This unit contains the following contents:

• explanations of the basic concepts regarding databases: flat-file databases, table, record, field, key, data types, primary key, … etcetera.
• introduction to the need of databases and the disadvantages of flat-file databases
• definition of data validation and their importance in databases
• explanation of the most used validation checks in databases, such as length check, range check and format check
• introduction to Structured Query Language, SQL and its syntax
• explanation of how produce queries using the command SELECT
• use of the most common commands and functions in SQL such as SUM and COUNT.

Syllabus objectives, schemes and graphics are provided for better understanding.