Database Data Types
Presentation
•
Computers
•
9th - 12th Grade
•
Practice Problem
•
Medium
E Leigh
Used 3+ times
FREE Resource
5 Slides • 7 Questions
1
Database Structure -
Data Types
2
Some database programs have a lot of data types, some have less.
This table shows the common SQL ones.
Different Data - Different Type
3
Drag and Drop
4
Some database programs have a lot of data types, some have less.
This table shows the common SQL ones.
Different Data - Different Type
5
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
6
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
7
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 |
8
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
9
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
10
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
11
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
12
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
Database Structure -
Data Types
Show answer
Auto Play
Slide 1 / 12
SLIDE
Similar Resources on Wayground
11 questions
Computer Forensics .
Presentation
•
9th - 12th Grade
9 questions
Domain 1 - Lesson 3: Configure Drive Encryption
Presentation
•
9th - 12th Grade
10 questions
PR1 QUALITATIVE RESEARCH INTRODUCTION & BACKGROUND OF THE STUDY
Presentation
•
9th - 12th Grade
6 questions
MAC 2 | Lesson 5-7 | Wrap it Up
Presentation
•
KG
10 questions
CS2 Conditionals
Presentation
•
9th - 12th Grade
11 questions
PASSIVE VOICE
Presentation
•
9th - 12th Grade
8 questions
{Exit Ticket} Types of Studies
Presentation
•
9th - 12th Grade
10 questions
Problem Solution (Text Structure)
Presentation
•
9th - 12th Grade
Popular Resources on Wayground
24 questions
PBIS-HGMS Day 10
Quiz
•
6th - 8th Grade
10 questions
HCS SCI 03 Summer School Review 3
Quiz
•
3rd Grade
11 questions
Home Scope
Quiz
•
7th - 8th Grade
15 questions
HCS SCI 05 Summer School Assessment 3 Review
Quiz
•
5th Grade
35 questions
Lufkin Road Middle School Student Handbook & Policies Assessment
Quiz
•
7th Grade
18 questions
Geo 11.3 Area of Circles and Sectors
Quiz
•
9th - 11th Grade