WorksheetsCS IGCSE Unit 3. Databases
Total questions: 15
Worksheet time: 8mins
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 (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
When identical data has to be entered more than once into the same table or different tables is called ...
data inconsistency
data duplication
data repetition
data redundancy
________ databases are used to avoid data redundancy.
foreign
primary
relational
paper-based
In a query-by-example table, ______ row is used to write the fields that made up a database
field
table
criteria
show
In a query-by-example table, ______ row is used to write the name of the table which contains the fields
fields
table
record
criteria
A database can be made up of more than one table
True
False
