Element 1

Plan a simple flatfile database to provide a solution to a problem

1.1

A working plan is developed to meet the requirements of a supplied brief

1.2

The plan identifies the purpose of the database

1.3

The plan includes a basic outline of the database specifications and/or features required to provide a solution

Element 2

Produce the database in accordance with the plan

2.1

Database fields are established

2.2

Records are entered

2.3

The database is saved to a file

Element 3

Use the database to provide a solution

3.1

The database file is located, opened, and updated

3.2

Database records are sorted alphabetically and numerically and printed out in hard copy

3.3

Queries are applied to database in order to find requested data occurrences and the results printed out in hard copy

3.4

Data integrity practices are demonstrated in terms of comparison with original information sources and audited formulae

Element 4

Evaluate the database and modify as required

4.1

The database is evaluated for compliance with the brief, accuracy, readability, legibility, presentation, and data integrity

4.2

The database is modified if required and compliance with the brief is confirmed