Database Data Types

Database Structure -
Data Types

Some database programs have a lot of data types, some have less.

This table shows the common SQL ones.

​

Different Data - Different Type

Drag and Drop

What's SQL?​

Placeholder

​

Placeholder

​

Placeholder

​

Placeholder

Drag these tiles and drop them in the correct blank above

It's a coding language for databases

No idea!

It's a programming language for gaming

It means Structured Query Language

There's only one type of it

It's sort of like English

Instructions that tell a database what to do

Some database programs have a lot of data types, some have less.

This table shows the common SQL ones.

​

Different Data - Different Type

Multiple Choice

How do you think a telephone number should be stored? Before you choose, think carefully - telephone numbers all start with 0 - what will happen to the 0 if you choose Number?

• Text

• Number

• Date

• Time

Multiple Choice

Is there another reason why you would choose not to store it as a number? Would you ever be likely to perform a calculation on a telephone number?

• Yes

• No

Sample record from a Database

This shows the fieldname, a sample of the data stored, and data type of the field

​Fieldname	​Sample Data	​Data Type
​criminalID	​S38fn2j	​Text
​Forename	​Craig	​Text
​Surname	​Smith	​Text
​Date of Arrest	​08/05/1983	​Date
​Time of Arrest	​09:30	​Time
​Times Arrested	​2	​Number

Now go to Google Classroom and complete the questions on the Google Form there. Use the information on these slides to remind you which data types fit which type of data.

Classroom Tasks

Poll

I understand what a Text data type is for

• Not at all

• I think I do

• I definitely do

• I could explain it to someone else

Poll

I understand what a Number data type is for

• Not at all

• I think I do

• I definitely do

• I could explain it to someone else

Poll

I understand what a Date and / or Time data type is for

• Not at all

• I think I do

• I definitely do

• I could explain it to someone else

Poll

I understand what a Boolean data type is for

• Not at all

• I think I do

• I definitely do

• I could explain it to someone else