Monday, June 13, 2011

Section 5: Data Types

a) identify different data types; logical/Boolean. alphanumeric/text, numeric (real and interger) and date
    remember acces task, e.g. logica/boolean = yes/no

b)select appropriate data types for a given set of a data: logical/Boolean, alphanumeric/text, numeric and date
   mostly number

c) describe what is mean by the terms file, record, field and key field
    primary key (key field) is a unique piece of information e.g. ID number at school
    file is a the whole grid
    record is a row
    field is the column
  
d)describe different database structures such as flat files and relational tables including the use of relationships, primary keys and foreign keys
     flat file is only one group of information
     foreign key is not unique
   

e) state the difference between analogue data and digital data 
    analogue (remember natural)
 modems and sound cards convert natural analogue waves into binary


f)explain the need for conversion between analogue and digital data
   because computers do not speak in analogue but in ones and zeros, we need to convert the natural analogue into ones and zeros,
does not speak and natural waves

1 comment: