Database Software

Overview

Framework:
RQF
Level:
Level 3
Unit No:
T/502/4556
Credits:
6
Guided learning hours:
45 hours

For the full unit details, please download the latest version of the qualification specification. This is available for download on the relevant qualifications page.

Unit Learning Outcomes

To view the assessment criteria and any additional content, please expand the relevant learning outcome below.

1. — Plan, create and modify relational database tables to meet requirements.

Assessment Criteria

  • 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.

Assessment Criteria

  • 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.

Assessment Criteria

  • 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.
  • 3.5
    Check reports meet needs, using IT tools and making corrections as necessary.