Chapter 9 - Databases (IGCSE Computer Science)

An SQL command that counts the number of records (rows) in which the field (column) matches a specified condition; used with SELECT (a)  

• ORDER BY
• COUNT
• SUM
• WHERE

A classification of how data is stored and displayed, and of which operations that can be performed on the stored value

• data type

• data value

• data

• data packet

A persistent structured collection of data that allows people to extract information in a way that meets their needs

• record

• table

• database

• basedata

The values associated with each record in a database table

• table

• record

• primary key

• field

An SQL command that identifies the table to use

• SELECT

• FROM

• WHERE

• ORDER BY

An SQL command that sorts the results from a query by a given column either alphabetically or numerically

• SUM

• WHERE

• COUNT

• ORDER BY

A field in a database that uniquely identifies a record

• public key

• private key

• primary key

• secondary key

A collection of fields that describe one item

• table

• record

• field

• database

An SQL command that fetches specified fields (columns) from a table

• SELECT

• FROM

• WHERE

• ORDER BY

A database that contains only one table

• object database

• graph database

• relational database

• single-table database