notes about databases

remove duplicate data makes thing quicker and faster ruduces storage space

key feild

also called primary key. a feild in a table which uniquely identifie each record in tht table

definition

a data base is a structured collection of info stored on a computer system

data processing

RAW facts and figures in a disorganised state are called DATA

when data is organised to make it more useful it is called information

relational database

a datbase containinh two or more tables that are linked to each other. this overcomes problems problems of data redundancy, resting in fewer entry errors and reduce storage space

three ways you can organise data a.k.a data processing

r

data typesautonumber = numbers that are automatically generated for each record. autonumber is normally used for key feilds to make sureeach is deiffrent.number = numeric values these can be intergers (whole numbers) or decimals.Alphanumeric/text = short valuescontaining numbers and letterscurrency = monetary valuesdate/time = dates and timeobject/image = files such as digial photoslogical/boolean = yes/no valueslimited choice = where values are limtied to those in a drop-down list

organise facts into a simple order like words in a dictoinary or names in a phone book

work out new facts from the ones you alresdy have.for example work out an average from a lonf list of number s

present the facts in a interesting way. for example print a report or a graph