Unit 21:
Database Software
Unit code: T/502/4556
QCF level: 3
Credit value: 6
Guided learning hours: 45
Unit aim
The aim of this unit is to enable learners to understand the features of relational databases and to develop the skills necessary to design, create and populate a relational database, as well as utilising software tools to manipulate data.
Unit introduction
Database software is one of the most commonly used application packages in business. Many jobs involve the use of databases and for this reason employees with database skills are valued. The advantages of using a relational database are extensive, including significantly reduced data storage requirements, improved record manipulation and faster access to records. As with spreadsheets, data mining software can make use of database files to interrogate records and look for trends or unusual events.
Most organisations use databases in some way to store records, for example customer information, supplier information, employee details and financial information. These records can be searched, sorted, ordered, and cross- referenced using relational databases. Using a simplified chart tool, graphs and charts can also be created and embedded in reports.
To ensure that relational databases have integrity, validity and efficiency, planning the database prior to implementation is important. Failure to do this may result in a poor product. Efficient relational database design is managed through the process of normalisation and it is important learners understand the importance this brings to developing efficient and effective databases.
In this unit learners will develop understanding of database software and principles, in order to set up an effective and efficient database. Furthermore, learners will be able to use features and functions to manipulate data to yield the desired result.
Learning outcomes and assessment criteria
In order to pass this unit, the evidence that the learner presents for assessment needs to demonstrate that they can meet all the learning outcomes for the unit. The assessment criteria determine the standard required to achieve the unit.
On completion of this unit a learner should:
|
Learning outcomes
|
Assessment criteria
|
|
1 Plan,
create and modify relational
database tables to meet requirements
|
1.1
Explain how a relational database
design enables data to be organised
and queried
1.2
Plan and create multiple tables for data
entry with appropriate fields
and properties
1.3
Set up
and modify relationships between database tables
1.4
Explain why and how
to maintain data integrity
1.5
Respond appropriately to problems with database tables
1.6
Use database tools and techniques to
ensure data integrity is maintained
|
|
2 Enter,
edit and organise structured information
in a database
|
2.1 Design and
create forms to access, enter, edit and organise data
in a database
2.2 Select and use appropriate tools
and techniques to format data entry forms
2.3 Check data entry meets needs, using
IT tools and making corrections as necessary
2.4 Respond appropriately to data entry
errors
|
|
3 Use database
software tools to create, edit and run data queries
and produce reports
|
3.1 Explain how to select, generate and output information
from queries according to requirements
3.2 Create and run database queries to display, amend or calculate selected data
3.3 Plan and produce database
reports from a multiple-table relational
database
3.4 Select and use appropriate tools
and techniques to format database reports
|
|
Learning outcomes
|
Assessment criteria
|
|
|
3.5 Check
reports meet needs, using
IT tools and making corrections as necessary
|
