null
US
Entrar
Registre-se gratuitamente
Registre-se
Detectamos que o JavaScript não está habilitado no teu navegador. Habilite o Javascript para o funcionamento correto do nosso site. Por favor, leia os
Termos e Condições
para mais informações.
Próximo
Copiar e Editar
Você deve estar logado para concluir esta ação!
Inscreva-se gratuitamente
771478
Data Handling
Descrição
Mapa Mental sobre Data Handling, criado por wmatthew em 20-04-2014.
Mapa Mental por
wmatthew
, atualizado more than 1 year ago
Mais
Menos
Criado por
wmatthew
aproximadamente 10 anos atrás
34
1
0
Resumo de Recurso
Data Handling
Data Validation: Checks that data entered is reasonable but cannot check it is correct.
Range check: It checks the length of the data entered is within a certain range.
Presence check: Makes sure data has been entered in a cell.
Format check: Makes sure data has been entered in the correct format e.g. date of birth.
Length check: It checks the data isn't to short or long.
Check Digit: It puts digits into a calculation to check they are valid commonly used on barcodes.
Lookup Check: It checks the data is correct from a table stored else where.
Data Types
Text: stores both letters and numbers.
Integer: Stores whole numbers that don't begin with zero.
Real Number: Stores only decimal numbers however they cant start with zero.
Date: Is used to store date in the correct format however their is a format choice. Short date e.g. 03/09/2020 or long date e.g. 3rd September 2020
Boolean: offers a choice of one or the other. Yes/no.
List: Offers a few select items on a list reducing mistake.
Databases
Relational database
It links several tables together saving on data duplication saving on mistakes but also time
Can be used to enforce rules by brining up error messages when certain rules are broken.
Easy to run a query.
Flat file database
One large database holding all the information means some data may be keyed twice
Difficult to read and use day to day
Difficult to run a query on a large table.
More prone to mistakes due to confusing layout.
Quer criar seus próprios
Mapas Mentais
gratuitos
com a GoConqr?
Saiba mais
.
Semelhante
S2A Chapter 1 Extra Exercise
Sin Kei Chan
Data Handling
Lavanya Jain
Data Handling
Jayasri Jeeva
Data Handling
AKANSH AGARWAL
Data Handling
Jayasri Jeeva
Data Handling
AKANSH AGARWAL
Lakshya's Stationary items !
lakshya badhan
Bar graphs
disha Manchanda
Data Handling Bar Graph Activity
Harshit Hemrajani
Data Handling
Manjari Sinha
Bar graphs
disha Manchanda
Explore a Biblioteca