Database and SQL

Data in a database is stored in a .......... .

• Tables

• Fields

• single flat file

Each table has a number of key elements: ................. and ............... .

• single flat file

• field names/attributes

• records

A ..................... is a field that is unique for each record within a table.

• record

• foreign key

• primary key

• integer

A ......................... is

an attribute in one table that contains the value of a primary key in another table.

• database

• record

• primary key

• foreign key

SQL stands for .................................

• structured query language

• standard query language

A ................. is a number of related pieces of information grouped together, e.g. all the information that a school holds about a particular student.

• record

• field

• primary key

• foreign key

........................ are used to refer to pieces of information within a record in a table. Every record in a particular table will have the same ................ within it.

• Field names, fields

• Field names, records

• Records, field names

• Foreign keys, fields

The .................... statement is the simplest of SQL statements and is used to find information within a database.

• SELECT

• BETWEEN

• FROM

• WHERE

A SELECT statement comes in four main parts:

• SELECT

• FROM

• WHERE

• INPUT

• ORDER BY

SELECT specifies ...................................

• the information you want to find within the database

• the table(s) that contain(s) the information

• the criteria you need to find the information

• how the data is organized (sorted) when it is retrieved.