1 Database: is a collection of data or information
which is held together in an organised or
logical way. (Paper based or computerised)
1.1 Paper Based
1.1.1 i.e notebook with addresses sorted by
surname or the Yellow Pages directory
which is organised by businesses.
1.2.1 i.e. search engines (Google),
school electronic registers
2 Why use a database?
2.1 Vast amounts of information can
2.1.1 Banks: millions of customers, who might have more than one account
(current, savings, mortgage). Many transactions will take place so the
bank will need to store details of every single transaction that takes
place, what time, how much, who was paid etc.
2.2 Queries can be run to search for
specific records or groups of records
2.2.1 Bank: A customer may complain about a withdrawal of
money that they do not recognise. Bank will need to search
its database very quickly and find the customers account,
transaction and details - can be done in seconds.
2.3 Reports can be produced from the
data stored or queries run
2.3.1 Data can be sorted into a logical order or extracted as
part of a query, but the output doesn't look very
professional. If you are showing the information to a
customer, producing a database report may be required.
2.4 Information can be extracted from the
database and exported into a word
processing package for mail merging
2.4.1 Spam can be sent be running queries on a database and
then finding a set of records which match a set criteria.
2.5 Validation can be used to
2.5.1 Validation can't stop errors, but can reduce them. Databases
enable you to use a variety of validation techniques to ensure
that data is 'reasonable, allowable, sensible and within
3.1 Allows you to see all of the records stored in the database
3.2 Can store many records
3.3 A database can contain many tables
4.1 Is all of the data or information
about one person or one thing
4.1.1 Each table can contain anything from
a few up to millions or records/rows
4.1.2 Is made up of lots of
individual pieces of
4.1.3 Each piece of info in
a record is called a