Agriculture, Environment & Animal Care
Qualifications
Vocational Qualifications
Catering, Hospitality & Leisure
Qualifications
Vocational Qualifications
Childcare & Education
Qualifications
Access to HE
Apprenticeships
Vocational Qualifications
Construction, Engineering & Manufacturing
Creative, Design & Digital
Education & Training
Qualifications
Professional Development
English & Maths
Qualifications
English & Maths
Essential Digital Skills
Qualifications
Digital Qualifications
Hair & Beauty
Qualifications
Vocational Qualifications
Health, Science & Social Care
Qualifications
Access to HE
Apprenticeships
Vocational Qualifications
Life Skills & Progression
Qualifications
Digital Qualifications
Personal & Social Development
Personal and Professional Development
Qualifications
Digital Qualifications
Personal & Social Development
Professional Development
Vocational Qualifications
Public & Protective Services
Qualifications
Access to HE
Vocational Qualifications
Safeguarding & Wellbeing
Qualifications
Sales, Marketing & Retail
Supporting SEND
Qualifications
Personal & Social Development
Professional Development
Transport & Logistics
Qualifications
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 our Qualifications

If you would like to teach our qualifications to your learners, submit an enquiry to discuss the best options.

Learners and students

Your questions answered

Learner Info