CS IGCSE Unit 3. Databases

A structured collection of data on a computer system is called a...

• website

• database

• program

• file

Choose all the reasons for storing data in a computer database:

• data can be easily stored and retrieved

• is saves paper and time

• data can be quicly sorted

• is less safe than storing data in a paper-based database

The object about which data is being stored is called the...

• file

• field

• entity

• data

Select all data types that can be used in a database

• date

• alphanumeric

• float

• boolean

What two different words can be used to describe a single item of data stored in each database record?

• record

• attribute

• table

• field

A __ is an every single row in a database which stores data about a new instance of an entity

A collection of records in a database about a new instance of an entity is called a...

• field

• primary key

• record

• table

A ______ is the field that uniquely identifies each record stored in a database

• key

• primary key

• field

• attribute

A database is made up of four different fields: LastName, FirstName, CSMark and StudentID. Select the field that you would use as a primary key

• CSMark

• FirstName

• LastName

• StudentID

A ______ is a field in one table that uniquely identifies records in another table

• foreign key

• primary key

• field

• record