Relational Database

This unit is expiring
The expiry date of this unit is 31/07/2026.

Overview

Framework:
Access to HE
Level:
Level 3
Unit No:
QU029031
Credits:
3
Guided learning hours:
Not available

Qualification Grading Type

Ungraded

Grade Descriptors

  • Ungraded

Unit Learning Outcomes

1

Understand basic database structures and conventions.

Assessment Criteria

  • 1.1

    Understand the structure of a database including: record structure, fields, data types, tables, and the primary key.

  • 1.2

    Identify the steps of the database planning life cycle.

  • 1.3

    Explain the activities in the conceptual design phase of a database.

2

Be able to identify the data structure to hold information in a database.

Assessment Criteria

  • 2.1
    Create tables and establish relationships between them.
  • 2.2

    Design a data entry form.

3

Be able to process information in a database.

Assessment Criteria

  • 3.1

    Create queries to combine data from multiple tables

  • 3.2

    Perform calculations based on information in queries.

  • 3.3

    Display information from tables on a form.

4

Be able to present database information in reports.

Assessment Criteria

  • 4.1

    Create menu and sub-menu reports for a database and attach actions to them.