7+database+6

= Databases Lesson 6 =

REMEMBER TO LOGON TO GOOGLE CLASSROOM!

Lesson 1 Lesson 2 Lesson 3 Lesson 4 Lesson 5 Lesson 6 Lesson 7

Lesson Objectives

 * Understand data types
 * Be able to change data types in a database

Success Criteria
(5-6) Change data types in a database (5-6) |Define data types (4-5) Describe a data type

Starter (10 mins)
Data Types Game.......

Homework
See Google Classroom for homework due this week and set this week.

Keywords (10 mins)
Add todays keywords to your keywords sheet in Google Drive

Activity (5 mins)
Open the table in your database and add one additional record (you can make it up but NO rude names!)

It will let you add records BUT it will let you add incorrect data. Your fields need to have their data types change in order for the data to be validated

Task (20 mins)
We will change the data types to add validation

Add a screenshot to your classwork document

Plenary (5 mins)
Discuss how YOU have seen data types working in a database..