Showing posts with label 5 Data Types. Show all posts
Showing posts with label 5 Data Types. Show all posts

Tuesday, June 14, 2011

Analogue and Digital

An ADC is an Analogue to Digital Converter. These are necessary because computers can't read or process Analogue data as it requires natural things e,g Electricity. Computers can only read binary code which is digital so requires a converter(ADC) to change from Analogue to Digital enabling the computer to read the Data.

I 'm not sure if it's only to read the info so can somebody check and comment for me. Cheers

Monday, June 13, 2011

Relational Tables

1 table = Flat File
2 tables = Relational Database (One group of info linked to another group of info using ID Primary to Foreign Key)
E.g. Dave's ONE account is selling TWO products
John's ONE account is selling ONE product

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