Pages in this set

Page 1

Preview of page 1
AO2.5 Data types
A. identify different data types: logical/Boolean, alphanumeric/text, numeric (real and integer) and date

B. select appropriate data types for a given set of data: logical/Boolean, alphanumeric/text, numeric
and date

C. describe what is meant by the terms file, record, field and key field

D. describe different database…

Page 2

Preview of page 2
Analogue Digital

Analogue is used to describe something that Digital means having only discrete values, as
changes value smoothly. It is the opposite of opposed to analogue which has continuously
digital which describes something that changing values.
changes in steps.

For example, there are two kinds of clock, an The…

Page 3

Preview of page 3
file



Currency/Numeric
(real)
Numeric
Alphanumeric/
Alphanumeric/ Alphanumeric/
(integer) text
text text
Alphanumeric/
Alphanumeric/ Alphanumeric/ Alphanumeric/
text
text text text
Key field Logical/Boolean




Field

record

Page 4

Preview of page 4
Describe different database structures such as flat files and relational tables
including the use of relationships, primary keys and foreign keys


What is a flat file database?
Definition Example
A flat file database describes any of various
means to encode a database model (most
commonly a table) as a single…

Page 5

Preview of page 5
What are relationships?
Definition Example
We need to link the table you would get a relationship in Microsoft
together so that we can Access (database).
connect a student to a
specific tutor and room.

The common field in both
tables is the Class field.

We use this field to create…

Page 6

Preview of page 6
What are primary key fields?
Definition Example
It is very important that every record in a you would only find primary key fields in a
database can be individually identified. We relational database, not a flat file.
need to be sure that when we access a record,
we are accessing…

Page 7

Preview of page 7
Relational and flat file databases:
Flat file databases are databases which are stored as a single table and can be created in
software such as Microsoft Excel or a Spreadsheet. In comparison, a relational database is
harder to create and maintain this is because they are usually made in a…

Page 8

Preview of page 8
Which data type would you use?
1.





Field Data type
VIN alphanumeric
Model text
Power text
Engine Size alphanumeric
Price currency
Colour text
Location text
Sold boolean

Which would you choose to be the primary key field? VIN
2.





Field Data type
Make text
Model text
Size integer
Price currency…

Page 9

Preview of page 9


Data types vocab list
1. Sort the list by confidence. Put the most confident at the bottom of the list and the least confident at
the top.
2. Add an example then a brief definition.


Term Definition Example
Most confident
text Letters Make, model
alphanumeric Letters or numbers Chd6jugkd
Date…

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »