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

Fill in the Blanks

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

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Poll

How confident do you feel at normalisation?

• Confident 😜

• Need more practice 🤨

• Clueless 🥴

Fill in the Blanks

Fill in the Blanks

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

Fill in the Blanks

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

Fill in the Blanks

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 🥴

Fill in the Blanks

Fill in the Blanks

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

Fill in the Blanks

Poll

How confident do you feel at using calculations?

• Confident 😜

• Need more practice 🤨

• Clueless 🥴

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

​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 🥴