Font size
WorksheetsIT Unit 2 (Databases) Part A
Total questions: 15
Worksheet time: 9mins
Which of the following are primary keys?
CostumeHireGroupID
CostumeID
RentalID
CustomerID
FirstName
What is a composite key?
A primary key made up of more than 1 field
A foreign key that is also a primary key
A primary key that does not uniquely identify a record
A foreign key that is used in more than one table
Does the database design shown have a composite key?
Yes
No
Which of the following data are atomic?
Mr Bob Bobson
TA1 9PO
Ford Capri
Bogtown High School
Which of these are requirements for 1st Normal Form?
Data must be atomic
No repeating groups of data
No repeated fields
Each record is unique (has a primary key)
It must look nice
How is a parameter created in a query to allow user input?
Use square brackets [ ] around a question in the criteria row
Tick the 'parameter' box in the field properties
Use curly brackets { } around a question in the totals row
Add a question in the criteria row using bold font
Which sort of check is used to ensure that data must be entered into a field?
Presence check
Length check
Format check
Range check
Table lookup
Which sort of check is used to ensure that a text field can't be too long?
Presence check
Length check
Format check
Range check
Table lookup
Which sort of check is used to ensure that a foreign key field can only be assigned to a valid record in another table?
Presence check
Length check
Format check
Range check
Table lookup
Which type of test is used for data that is expected to save correctly?
N (Normal)
R (Erroneous)
X (Extreme)
I (Incorrect)
Which type of test is used for data that is expected not to save correctly?
N (Normal)
R (Erroneous)
X (Extreme)
I (Incorrect)
Which type of test is used for data that is on the boundary of what is expected to save correctly?
N (Normal)
R (Erroneous)
X (Extreme)
I (Incorrect)
Which of these are likely to be one-to-many?
Owners and dogs
Students and Address
Movies and actors
Doctors and appointments
What needs to be done to allow a database to handle many-to-many relationships?
Include a 'link' table with one-to-many relationships
By ticking the 'allow many-to-many relationships' check box
Additional primary keys are introduced to the existing tables
Remove some existing fields
Which of the following are foreign keys?
CostumeHireGroupID
CostumeID
RentalID
CustomerID
FirstName
