Database

Aim and purpose

To give learners an understanding of database systems as well as the practical skills to translate that
understanding into the design and creation of databases.

Unit introduction

Database software is one of the most commonly used application packages in business. Therefore, it is important that all IT users have a working knowledge of this type of software and an understanding of the advantages and disadvantages so that they can identify appropriate situations in which to use a computerised
database. Learners will gain an understanding of the basic principles of database design and the structures and terminologies associated with databases as well as developing useful practical skills such as creating single table databases with associated forms, queries and reports.Documentation is necessary for every application and system so that they can be maintained and adapted over time. Learners will gain knowledge of the documentation needed to support the databases that they create, to show how it works and what features have been used. They will also learn how to check their databases to ensure that everything works correctly.