Databases (Cambridge (CIE) IGCSE Computer Science)

Give the name of the field that would be used for the primary key.

State the reason for choosing this field for the primary key

A database table, PERFORMANCE, is used to keep a record of the performances at a local theatre.

State the number of fields and records in the table.

A computer game shop records its stock levels in a database table called GAMES. The fields used in the stock table are shown.

State the number of fields that are in the table GAMES.

State one important fact that must be true for a field to be a primary key.

A database table, NURSE, is used to keep a record of disposable items worn by veterinary nurses.

This is part of the table:

Give a reason why the field SingleUse is not required in the table NURSE.

A database table called TVRange shows the main features and prices of a range of televisions.

Give the name of the field that is most suitable to be the primary key.

State the reason for this choice.

The database uses the data types:

• text

• character

• Boolean

• integer

• real

• date/time

Complete the table to show the most appropriate data type for each field. Each data type must be different.

A music streaming service has a new database table named Songs to store details of songs available for streaming. The table contains the fields:

• SongNumber – the catalogue number, for example AG123

• Title – the title of the song

• Author – the name of the song writer(s)

• Singer – the name of the singer(s)

• Genre – the type of music, for example rock

• Minutes – the length of the song in minutes, for example 3.75

• Recorded – the date the song was recorded.

Identify the field that will be the most appropriate primary key for this table.

Complete the table to identify the most appropriate data type for the fields in Songs

Describe what a field is in a database.

Provide an example of a field in a student database