Translate

Tuesday 15 October 2013

Databases

Databases


A database is a collection of data stored in an organised way. Databases can be computerised or paper based, an example of a paper based database is a notebook or the yellow pages. Computerised databases include, school records, hospital records and search engines. A computerised database is easier to store and you can search records quickly. A paper based database works even without electricity and is cheaper to make. A database is suitable for storing information as it can sort millions of records into fields so it is easier to find the information you need.
Table- A table displays all of the records in a database
Record- All of the information held in a database on a particular person or object
Field- All the information held in a specific category in a database

A flat-file database is where all the information is stored in one large table. A relational database is where all the data is split up into related groups. Data duplication is where data is needlessly typed in again when it is already on the database. A flat-file database is not suitable for all scenarios as you may not need all of the fields of certain tasks, it is sometimes better to just have a few specific ones. 

No comments:

Post a Comment