Relational Database

Overview

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

Qualification Grading Type

Ungraded

Unit Learning Outcomes

1.

Understand database design.

Assessment Criteria

  • 1.1.

    Explain the normalisation process in the design 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.