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

One of the data types is not correct. Which should be changed to a different data type?

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

PK from the Products Table

Fill in the Blanks

PK from the Orders Table

Fill in the Blanks

PK from the Staff Table

Fill in the Blanks

PK from the Contacts Table

Poll

How confident do you feel at normalisation?

• Confident 😜

• Need more practice 🤨

• Clueless 🥴

Fill in the Blanks

How many tables are there in a flat file database?

Fill in the Blanks

This data is unnormalised. How many tables will need to be created?

Fill in the Blanks

What will be a suitable PK for the Cake_Table?

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

What is the correct Data Type to use to store the following field data:

Phone_Number

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

A product code should follow the format Lju1

Write out the input mask that should be used

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

What operator would you use in a query, to search for results that are greater than or equal to

Fill in the Blanks

The image shows part of a database.

You create a query to search the field Position for all positions that contain the word clerk.

What criteria do you use?

Fill in the Blanks

The image shows part of a database.

You create a query to search the field manufacturerName and want to display all results that start with the letter R.

What criteria do you use?

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

You have been asked to do the following:

"Export the query results as a pdf"

Which icon would you select to do this?

Poll

How confident do you feel at using calculations?

• Confident 😜

• Need more practice 🤨

• Clueless 🥴

Fill in the Blanks

Complete the whole calculation in this query. The Total_Berths should be how many people it sleeps plus the number of crew

_{Do not use spaces in your structure}

Fill in the Blanks

Complete the calculation in this query. The weekly wage can be calculated by dividing the salary by 52

_{Do not use spaces in your structure}

Fill in the Blanks

Complete the calculation in this query. The discount will be 10% of the price. Display the 10% discount.

_{Do not use spaces in your structure}

Fill in the Blanks

Complete the calculation in this query for the total.

_{Do not use spaces in your structure}

Fill in the Blanks

Which calculation should be used: Display the highest price a yacht sold for

Fill in the Blanks

Which calculation should be used: Display the total number of yachts sold

Fill in the Blanks

Which calculation should be used: Display the overall total cost of all the seats

Fill in the Blanks

Which calculation should be used: Display the total amount of seats sold

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