Data Management

ben goddard
Mind Map by ben goddard, updated more than 1 year ago
88
0
0

Description

higher ICT Mind Map on Data Management, created by ben goddard on 05/13/2013.
Tags

Resource summary

Data Management
1 Data types
1.1 Number Formats
1.1.1 Integer

Annotations:

  • Positive or negative whole numbers (no decimal places), eg 1, 2, 3
1.1.2 Currency

Annotations:

  • Usually displayed using two decimal places with currency symbol eg £150.00
1.1.3 Percentage

Annotations:

  • Displays the value as a percentage eg 20% 
1.1.4 Fraction

Annotations:

  • Displays the value as a fractions eg 1/4 
1.1.5 Decimals

Annotations:

  • Displays the value as a decimal place used can be set, eg 1.66
1.2 Text

Annotations:

  • Alphanumberic data which can contain letters and numbers, but not designed to be used for calculations e.g 48 Boston Road
1.3 Date

Annotations:

  • Displays data information using an appropriate format as defined by the user. the format can be customised in terms of detail and type, for example 1st December 2010 or shortened to 01/12/10 (UK), 12/01/10 (USA)
1.4 Time

Annotations:

  • Displays time information using an appropiate format as defined by the user. Like with Date, the format can be customised according to the type required, for example 14:30 (24 hour) or 2:30 (12 hour)
1.5 Limited-Choice Options

Annotations:

  • Drop-down lists, radio buttons and tick lists can be used to offer a limited choice of data values. these are validation methods and are particularly useful for data entries.
1.6 Boolean

Annotations:

  • Can only hold True/False (or Yes/No) value.
2 Encoding Data

Annotations:

  • During data entry, data may be encoded. A number of different codes are defined for the for the data. For example a gender field may be stored as codes (e.g. 'M' for male, 'F' for female)
2.1 The benefits
2.1.1 1

Annotations:

  • Speeds up data entry as the data is often a single letter.
2.1.2 2

Annotations:

  • Less data, requiring less storage space to save, resulting in faster retrieval of information.
2.1.3 3

Annotations:

  • Easy to validate, and prone to human error during data entry.
Show full summary Hide full summary

Similar

MICROSOFT WORD 2013 SKILLS FOR WORK
John O'Driscoll
Types and Components of Computer Systems
Jess Peason
Input Devices
Jess Peason
General ICT Quiz
leahshaw
ICT Revison Flash Cards
Arun Johal
Networks
Will8324
Output Devices
Jess Peason
FLAT FILE VS RELATIONAL DATABASE
rosiejones
Online World - Learning Aim A
andysedge
General ICT Quiz
Jade Fantom
Data Types
Jacob Sedore