Relational Databases 1

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

• Database

• Program

• Webpage

• File

Choose the reasons for storing data in a computer database …

• Data can be quickly searched

• Data can be quickly sorted

• Data can be stored in an organised structure

• All of these reasons

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

• attribute

• field

• entity

• table

Every single row in a database about a new instance of an entity is called a _____________

• record

• field

• table

• key

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

• table

• file

• field

• attribute

The number of fields in this table is ____

• 1

• 5

• 8

• 9

The number of records in this table is _______

• 8

• 9

• 5

• 40

In a database table what is meant by the primary key?

• A field that must contain unique data for every record

• A record where every field must contain unique data

• The first field to be created in the table

• A field that is used to search the table for data

Identify the primary key in this database table.

• StudentId

• firstName

• lastName

• courseId

• There isn't one

A database is......

• A collection of files
• A persistent, organised store of data
• An unstructured collection of data
• A folder containing related files