Database Software

Overview

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

Unit Learning Outcomes

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.