GCSE Databases

A row in a database.

• Record
• Field
• Entity
• Table

A column in a database.

• Field
• Record
• Entity
• Validation

What is a database?

• A piece of software to do calculations

• A device to load information onto the computer.

• A structured collection of records

• A calculator

A sports club needs to store information about each member. All the information about each member is called a:

• Field

• File

• Table

• Record

A collection of records stored in a structured way about a common thing

• table

• file

• field

• attribute

Which of the following is an example of a record?

• 347

• ChannelType

• 351, Nature, Documentary, Bling, False

Which of the following is an example of a field?

• 347

• ChannelType

• 351, Nature, Documentary, Bling, False

The HD field is using the data type Boolean

• True

• False

Which of the following is an example of a field?

• TimesPlayed

• 004

• Holidays

A unique identifying field.

• Primary Key
• Integer
• Verification
• Boolean