Databases

The Database Concept

Candidates should be able to:
  • describe a database as a persistent organised store of data
  • explain the use of data handling software to create, maintain and interrogate a database.

The DBMS

Candidates should be able to:
  • describe how a DBMS allows the separation of data from applications and why this is desirable
  • describe the principal features of a DBMS and how they can be used to create customised data handling applications.

Relational Databases

Candidates should be able to:
  • understand the relationship between entities and tables
  • understand the components of a relational database, such as tables, forms, queries, reports and modules
  • understand the use of logical operators in framing database queries
  • explain the use of key fields to connect tables and avoid data redundancy
  • describe methods of validating data as it is input.

Revision Extras