The ICT Lounge
 
Section 5:
Data Types and Databases
 
The course syllabus states that you should be able to:
(a)
Identify different data types: logical/boolean, alphanumeric/text, numeric (real and integer), percentage and date/time
(b)
Select different data types for a given set of data: logical/boolean, alphanumeric/text, numeric, percentage and date/time
(c)
Describe what is meant by the terms file, record, field and key field
(d)
Describe different database structures such as flat files and relational databases including the use of relationships, primary keys and foreign keys
(e)
State the difference between analogue and digital data
(f)
Explain the need for conversion between analogue and digital data
This section is broken down into 5 parts. (Click links to visit each page)
Part 2:
Searching for Data
Part 3:
Database Structures
Part 4:
Types of Databases
Section Objectives
Section Notes
Section Starter Task 1
Section Objectives
Section Notes
Section Starter Task 2
Section Objectives
Section Notes
Section Starter Task 3
Section Objectives
Section Notes
Section Starter Task 4
Section Objectives
Section Notes
Section Starter Task 5
Revision Practice for Section 5:
This section contains lots of files that will help you with your revision.

The table to the right contains practice questions for this section and a range of mind maps which break the information down into small chunks.

The links just below this text will take you to a range of games that will help you digest the knowledge that you have gained from each of the 5 parts above.
Reinforcement Games
Reinforcement Game 1
Reinforcement Game 2
Reinforcement Game 3
Reinforcement Game 4
Reinforcement Game 5
Reinforcement Game 6