Database Knowledge Check

​How much do you know about databases?

​Can you:

• Assign data types

• Choose appropriate primary keys

• Normalise data

• Use and apply validation

• Complete queries

• Use calculations

• Problem solve

Poll

How confident do you feel at assigning data types?

• Confident 😜

• Need more practice 🤨

• Clueless 🥴

Can you assign the correct data types to the data given?

​

Assign data types

Multiple Choice

What data type will you select for Flight_Number?

• Number

• Currency

• Text

• Date/Time

• Calculated

Multiple Choice

What data type will you select for Number_of_passengers?

• Number

• Currency

• Text

• Date/Time

• Calculated

Multiple Choice

What data type will you select for Ticket_Price?

• Number

• Currency

• Text

• Date/Time

• Calculated

Multiple Choice

Using the data given, what would be an appropriate field length to store the data for the Position field?

• 1

• 10

• 20

• 50

Poll

How confident do you feel at assigning a primary key?

• Confident 😜

• Need more practice 🤨

• Clueless 🥴

For each of the following slides pick out the most appropriate primary key

Poll

How confident do you feel at normalisation?

• Confident 😜

• Need more practice 🤨

• Clueless 🥴

Multiple Select

What other fields will belong in the Cake_Table?

• Order_Date

• Price

• Phone_Number

• Cake

• Quantity

Poll

How confident do you feel at validation?

• Confident 😜

• Need more practice 🤨

• Clueless 🥴

Multiple Choice

A Format check is a validation check that...

• Calculates a series of numbers and compares the answer to the check digit

• Checks pattern positions e.g. LL0 = IM1

• Checks data is in a specific format e.g. Text, Date/Time

• Compares data with data that has already been entered previously to see if it matches

• When a person compares data to the original source

Multiple Choice

A value lookup check is a validation check that...

• Restricts a user to select an option from a given list

• Checks pattern positions e.g. LL0 = IM1

• Restricts a number to be entered between two values

• Ensures that the field is completed before moving on

Multiple Choice

The Product Code CATsml is entered. Will this be accepted in this field?

• Yes

• No

Multiple Choice

The following data would be accepted in this field:

Christopher Sanderson

• True

• False

Multiple Choice

The Reorder Date 21/09/2026 is entered. Will this be accepted in this field?

• Yes

• No

Multiple Choice

There should be validation on the Gender field.

What should be entered into the validation rule?

• M OR F

• M, F

• M/F

• (M) (F)

• M AND F

Poll

How confident do you feel at using queries?

• Confident 😜

• Need more practice 🤨

• Clueless 🥴

Multiple Choice

What kind of query is being shown here?

• Dynamic parameter query

• Static parameter query

Multiple Choice

What type of query has been carried out here?

• Simple Query

• Complex Query

• Nested Query

• Summary Query

Poll

How confident do you feel at using calculations?

• Confident 😜

• Need more practice 🤨

• Clueless 🥴

​Problem solving...

Multiple Choice

I try to apply a primary key and get this error message. What is the problem?

• Student_ID should be set to autonumber

• The data type used for the PK is unsuitable in some way

• No records have been added to the table

• There are records without any data in the Student_ID field

Multiple Choice

I try to create a relationship between two fields, and get the error message shown on the right. What is the problem?

• The field names do not match, so a relationship can not be made

• The data types of each field are not the same e.g. one may be set as text and the other number

• No records have been added to one or both of the tables

• There are records in the table without completed data

Multiple Choice

Spot the error

• The foreign keys are unsuitable

• Student_ID should be set as a primary key

• The teacher table has an unsuitable primary key

• The 'Lesson_Date' field should be in the student table

Multiple Choice

What is wrong with this report?

• Spelling errors

• Not all information clearly is visible

• The header is not suitable

• The records do not make sense

• The fields are too spaced apart

Poll

How confident do you feel at using databases?

• Confident 😜

• Need more practice 🤨

• Clueless 🥴