Databases

Overview

Framework:
RQF
Level:
Level 2
Unit No:
Y/505/3323
Credits:
3
Guided learning hours:
24 hours

Assessment Guidance

Portfolio of Evidence

Unit Learning Outcomes

1

Know how to design a database.

Assessment Criteria

  • 1.1
    Outline the difference between relational and non-relational databases.
  • 1.2
    Identify the components of database design.
  • 1.3
    Identify the field characteristics for the data required.
  • 1.4
    Identify methods to maintain data integrity.
2

Be able to create non-relational databases.

Assessment Criteria

  • 2.1
    Create a simple non-relational database using specified design.
3

Be able to add to a database.

Assessment Criteria

  • 3.1
    Create forms to enter, edit and organise data.
  • 3.2
    Use tools to format data entry forms.
  • 3.3
    Check data entry meets requirements, making corrections as necessary.
4

Be able to use database software tools to run queries and produce reports.

Assessment Criteria

  • 4.1
    Create and run database queries using multiple criteria.
  • 4.2
    Amend criteria to display selected data.
  • 4.3
    Plan and produce database reports from a single table non-relational database.
  • 4.4
    Select and use appropriate tools and techniques to format database reports.
  • 4.5
    Check reports meet requirements using IT tools, making corrections as necessary.