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
Solid thanks for listening in class. ;)
ReplyDelete