Databases - created from Mind Map

Page 1

A database is a persistent, organised store of related data

Computerised database- a collection of related data stored in one or more computerised files in a manner that can be accessed by users or computer programs

Database maintenance

Database interrogation involves using the database management software to query (search) the database for information.

Database creation

A database is persistent because the data and structures are stored in secondary storage

Computerised databases have advantages over manual

Can be accessed by more than one person at the same time

Ability to query/interrogate data and view results

Changes to data made quickly and avaliable to all users

Processing accuracy of data handling software reduces errors in repetitive tasks

Data can be output in different formats to suit user (graphs, report)

adding (also referred to as inserting) new data records (for example, when a new member of staff joins a company or a new product is added to the stock in a warehouse)

deleting existing data records (for example, when a member of staff leaves a company or a product discontinued from the stock in a warehouse).

updating (editing) existing data items within existing data records (for example, when a member of staff changes their name or a product has a price change).