NEW
Font size
Worksheets8525 AQA GCSE Computer Science 3.7.1 Relational databases
Total questions: 16
Worksheet time: 8mins
What is a database?
A type of data
A structured collection of data.
A field
A record
Select the correct label for this description.
An attribute in one table that is a primary key in another table.
Primary key
Record
Foreign key
Field
What is a record?
A collection of fields about the same person, item, or object in a database
One field about the same person, item, or object in a database
What is the purpose of the primary key?
To store all of the details of a record in a database.
To uniquely identify a record in a database.
What is a relational database?
A database with one table
A database with two or more tables
A collection of tables which can be linked together by means of primary and foreign keys.
All of the data in a database is stored in a
Field
Record
Table
A flat file database is
where data is stored in a single table
where data is stored in multiple linked tables.
What is an advantage of storing data in a flat file database
It it is easier to set up.
The same data is included multiple times, which can lead to inconsistencies in the data.
Primary keys cannot be duplicated whereas foreign keys can be stored multiple times in the same table.
True
False
....... Is a collection of related data
A field
A record
A table
Select the correct description for this data type:
INT(size)
A string with the number of characters specified by size
A string with any number of characters up to the number specified by size
A whole number stored using the number of bits specified by size
A number stored using the number of bits specified by size with digits after the decimal point up to the number specified by precision
A date in the format YYYY-MM-DD
Select the correct description for this data type:
CHAR(size)
A string with the number of characters specified by size
A string with any number of characters up to the number specified by size
A whole number stored using the number of bits specified by size
A number stored using the number of bits specified by size with digits after the decimal point up to the number specified by precision
A date in the format YYYY-MM-DD
Select the correct description for this data type:
VARCHAR(size)
A string with the number of characters specified by size
A string with any number of characters up to the number specified by size
A whole number stored using the number of bits specified by size
A number stored using the number of bits specified by size with digits after the decimal point up to the number specified by precision
A date in the format YYYY-MM-DD
Select the correct description for this data type:
DATE
A string with the number of characters specified by size
A string with any number of characters up to the number specified by size
A whole number stored using the number of bits specified by size
A number stored using the number of bits specified by size with digits after the decimal point up to the number specified by precision
A date in the format YYYY-MM-DD
Which of the following are Boolean operators in queries?
TRUE, FALSE
YES, NO
AND, NOT, OR
What is SQL?
A programming language used to build databases
A programming language used to search and query databases
A programming language used to debug databases
