Database systems

Aim 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

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

Sometimes people want to see all of the fields of all of the records but in other cases, they may only want to
see some of the fields or maybe a limited set of records for a particular purpose. For example in a stock file,
someone might only want a list of products that are out of stock for when we want to re-order. Queries are
used to restrict the information seen and learners will understand how to create queries and use them as the
basis for forms or printed reports.

1 Understand the principles of database systems
2 Be able to create non-relational database systems
3 Be able to use database software tools.