Font size
WorksheetsA2 Computer Science 4.10 Databases
Total questions: 16
Worksheet time: 8mins
A collection of fields and records in a specific category
Record
Table
Field
The best data type to choose for date of birth would be
Number
Date/Time
Text
Currency
The best data type to choose for a memberID would be
Number
Date/Time
Text
Currency
Which of the following would be used to uniquely identify a record?
Validation
Data type
Primary key
Field size
For A Relational Database, which of these statements defines an " attribute" ?
A structure where all the data in a database is stored
A value defined to hold a specific type of data, such as dates, numeric, or textual data.
A request for data or information from a database.
A value that uniquely identifies each record in the table.
A value relating to an entity that we wish to store.
For A Relational Database, which of these statements defines a "primary key" ?
A structure where all the data in a database is stored
A value defined to hold a specific type of data, such as dates, numeric, or textual data.
A request for data or information from a database.
A value that uniquely identifies each record in the table.
A value relating to an entity that we wish to store.
For A Relational Database, which of these statements defines a "Table" ?
A structure where all the data in a database is stored
A value defined to hold a specific type of data, such as dates, numeric, or textual data.
A request for data or information from a database.
A value that uniquely identifies each record in the table.
A value relating to an entity that we wish to store.
An entity...
A thing about which data is to be stored
a characteristics or other information
Values used to communicate data
Used to sort results of a query
What is the name of this relationship?
many to many
one to one
one to many
many to one
Which of these relationships should not be present following normalisation?
What is required for a database scheme to be in 1st normal form?
must not contain any repeating attribute, no repeating groups
have no partial key dependencies
have no non-key dependencies
What is required for a database scheme to be in 2nd normal form?
must not contain any repeating attribute, no repeating groups
have no partial key dependencies
have no non-key dependencies
What is required for a database scheme to be in 3nd normal form?
must not contain any repeating attribute, no repeating groups
have no partial key dependencies
have no non-key dependencies
