Employability and Enterprise

Agriculture, Environment & Animal Care

Vocational Qualifications

Catering, Hospitality & Leisure

Vocational Qualifications

Childcare & Education

Access to HE
Apprenticeships
Pre-Access to HE
Vocational Qualifications

Construction, Engineering & Manufacturing

Access to HE
Vocational Qualifications

Creative, Design & Digital

Access to HE
Vocational Qualifications

Education & Training

Professional Development

Hair & Beauty

Vocational Qualifications

Health, Science & Social Care

Access to HE
Apprenticeships
Pre-Access to HE
Vocational Qualifications

Life Skills & Progression

Personal & Social Development

Personal and Professional Development

Personal & Social Development
Professional Development
Vocational Qualifications

Public & Protective Services

Access to HE
Vocational Qualifications

Safeguarding & Wellbeing

Supporting SEND

Personal & Social Development
Professional Development

Transport & Logistics

Access to HE
Vocational Qualifications

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.

Offer this Unit

If you would like to offer this unit, you can book a meeting with us to discuss the best options.