Module IT0203

- Organisation of data for effective retrieval examines the use of databases and how they can be constructed to ensure that the data is not duplicated and is secure.

A prerequistite part of this course is the KeySkills work in Access. If you haven't completed any of the exercises you must do so. You should also read the background sections again. The module is split into a number of sections which are intended to be used for reading prior to attempting the assessment questions provided. Additional items of research are provided to give background information from other sources such as books and related Internet sites.

Specification:

2.3 Organisation of data for effective retrieval

• Describe the nature and purpose of a database and how they work.
• Understand that data needs to be organised in a database to allow for effective updating and retrieval. Understand how data can be retrieved to produce meaningful information.
• Recall the relevant advantages of databases over flat file information storage and retrieval systems.
• Select and justify appropriate file and database structures for particular applications.

Module Content:

1. Organisation of data for effective retrieval
2. Databases
3. Data Entities and attributes
4. Normalisation of Data
5. Database security - Notes
6. Flat file of relational database?
7. Questions 1
8. Questions 2

Additional Information:

• GCSE Database Guide (don't assume you know this!)
• ICT in a Nutshell Site (Second Icon down on left tool bar.)

© LEV