Font size
WorksheetsUnit 2 Creating Systems to Manage Information Quiz
Total questions: 41
Worksheet time: 21mins
Normalisation is:
Filling in empty fields so that all rows / tuples contain data.
Organising a database to remove duplication of data, and maintain the accuracy / integrity of the data.
Putting fields from different tables into one big database.
Creating a spreadsheet
Fields in database are similar to _________ in tables.
Rows
Columns
Cells
Values
What is an atomic field?
A field that contains multiple items of data
A field that is repeated
A field that contains only one item of data
A field containing data about atoms
What is a foreign key?
The primary key in one table used to link to another table
Two fields combined together to make one key
A unique identifier
None of these
Which of the following are primary keys?
CostumeHireGroupID
CostumeID
RentalID
CustomerID
FirstName
A composite key is a combination of two fields that together can uniquely identify a record.
True
False
What type of relationship should we not use in our database structure?
One to One
One to Many
Many to One
Many to Many
Referential Integrity is a rule states that every foreign key value must match the primary key value of a record in another table, or must be null.
True
False
The best data type to choose for a postcode would be
Number
Text
Date/Time
Currency
Which data type would be most suitable for the 'DateofBirth' field?
Currency
Number
Date/Time
Yes/No
Memo
Which datatype will be used to generate numbers automatically while inserting data?
Number
Auto number
Automatic Number
Integer
What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?
Form
Query
Report
Table
The Query button is located on the _______ tab.
Home
File
Create
Export
Click ___________ to show the results of a query
Execute
Show
Run
Results
Datasheet View
Design View
Layout view
Report view
Besides entering data directly into the table, you could use a
Field
Form
Query
Report
Reducing the size of a field length is an example of a (a) check
Test data which should be accepted is known as
Normal
Extreme
Erroneous
Invalid
Boundary
Test data way outside a range which should be rejected is known as
Normal
Extreme
Erroneous
Invalid
Boundary
Test data with the incorrect data type which should be rejected is known as
Normal
Extreme
Erroneous
Invalid
Boundary
A primary key field from one table appears in a second table. What is the field in the second table called?
A primary key
A foreign key
A relationship key
A linked key
The arithmetic operator for 'less than or equal to' is?
=
<=
>=
<>
What is a "Control source" in an Access control?
Where formatting is controlled
Where the data comes from / is calculated
Where data is duplicated
Where a primary key is defined
What is CustomerID acting as in (2)?
A foreign key
A primary key
A normal attribute
A record
What is the relationship between "books" and "loans"?
1:1
1:many
many:1
There is no relationship
What type of validation is shown here?
Length check
Format check
Value lookup
Range check
How will "Fullname" display?
FredBloggs
Fred Bloggs
Bloggs, Fred
BloggsFred
How many hours are allocated for the examination in Part A?
2 hours
3 hours
4 hours
5 hours
What is the total mark for Part A of the examination?
26 marks
40 marks
66 marks
80 marks
What is the total mark allocation for Activity 1?
6 marks
8 marks
10 marks
12 marks
What is the advised time to spend on Activity 1?
20 minutes
30 minutes
40 minutes
45 minutes
What is the mark allocation for Activity 3?
8 marks
10 marks
12 marks
14 marks
Which activity involves creating queries and a report?
Activity 2
Activity 3
Activity 4
Activity 5
What is the advised duration for completing Activity 4?
15 minutes
20 minutes
25 minutes
30 minutes
How many marks are allocated for Activity 4?
4 marks
5 marks
6 marks
7 marks
In Activity 5, what aspect of the database is primarily evaluated?
User interface design
Database structure and validation
Query efficiency
Report layout
