Databases

Databases

1. Stores data in a structured way

   • aids storage
   • aids retrieval

2. Keeps programmes separate from data

3. Relational database

   • uses tables containing data
   • tables are linked
   • comprehensive and flexible

4. Flat-file database

   • stores all data in one file
   • only used with very simple databases
   • very limited

5. Queries

   • used to extract information
   • uses certain criteria
   • usually displayed on screen

6. Reports

   • results printed out
   • users can control what appears

7. Import/export

   • export data to other packages
   • import data from other packages