DB_Induction_Cluedo

• Computing
• Further Education (Key Stage 5)
• Higher Education (degree)

Crime Watch

Chief of Police Clancy Wiggum has asked for feedback on the latest crime reports for Sprucefield.  

Can you find the answers using the tables provided?

Purpose: to help understand the concept of relational tables in a database and how this can help with retrieving data to answer questions.

Explain there is  a timer for each question.

Finding answers from multiple tables

How did you find the answers to the questions even though the data was on different tables?

Was there something in common between the different tables?

Table structure

Look at the top row in each table - what would you call this?

Look at the data in each column - can you find a pattern?

students: headings/labels - purpose?  to indicate what is being held in that column.  

fields

pattern: same type of data - examples - dates in Date_solved field.

e.g. date format

What is the type of data held in Suspect# column?

numeric

Solving

How could you find out the department name for each detective?

What are the tables you need to look at?

Do both these have something in common?

Dept# 

Duplicates?

Are there any duplicates in the tblCrime?

Student: may identify Bank Robbery Omagh

Do you think this is an administraive error?

Look more closely - are the details about the bank robbery's the same?

Different Crime # is different

This is an example of a unique identifier - where other values may be the same they are actually relating to 2 different things/people/places - primary key

(instance of an entity)

Introduction to Databases: 

In your team come up with a question that requires you to reference 3 tables to get the answer.

Put your team name in brackets after the question.