Introduction to Data Types used in Databases

Front

"Paris"

"Joe"

"21 Main Street, Omagh"

07587948753

Back

Data type: Strings

Stores letters, numbers, symbols and spaces

Used to Store descriptions, codes etc and numbers you don't need to do calculations on

Front

16

2500

-14

Back

INTEGER (INT)

Whole numbers, e.g., 16, 2500

Cannot store decimal numbers

Age, quantity

Use: Product Quantity in stock in a shop

Front

22.5,

69.478

0.24

Back

Floating Point Number

Numbers with decimals, e.g., 3.14, 9.99

include a whole part and fractional part with a decimal point

prices, weights, measurements

Front

05-09-2024

25/12/2024

Back

Stores just the date,

Useful for recording e.g. Date of Birth, Date registered

Front

Yes or No

True or False

Back

Boolean Data

Values are TRUE or FALSE

Yes or No

Represent logical states - only 2 possible conditions

Example: Does the student get the bus?

Front

"Belfast, London, Paris, New York"

Back

Arrays

special type of datatype

can store many related data in it

example a list of subjects: maths, English, Science, IT, French

useful when dealing with data that has to be repeated a lot.

Front

"B00123256"

"B00298465"

"Round 1"

"Round 2"

"Round 3"

Back

Character

individual letters, number or symbols

Example: 'A', '3' or '#'

Suitable when all the entries are of the same length e.g. a student number

"300123456"

"300875986"