CIW database design

Overview

Framework:
RQF
Level:
Level 3
Unit No:
R/502/9005
Credits:
10
Guided learning hours:
60 hours

Assessment Guidance

To be assessed using the approved CIW examination

Unit Learning Outcomes

1

Understand Relational Database Fundamentals.

Assessment Criteria

  • 1.1

    Identify basic database types and management systems.

  • 1.2

    Evaluate common database languages and their purposes, and identify language subsets of Structured Query Language (SQL).

  • 1.3

    Identify relational data modelling schemas, characteristics and manipulation.

2

Understand Relational Database Design.

Assessment Criteria

  • 2.1

    Identify the steps of the database planning life cycle.

  • 2.2

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

3

Be able to normalize a database.

Assessment Criteria

  • 3.1

    Design a database using normalisation.

  • 3.2

    Describe logical database design steps and practices.

  • 3.3

    Apply normalization techniques and processes.

4

Be able to implement the Structured Query Language.

Assessment Criteria

  • 4.1

    Identify SQL commands and syntax.

  • 4.2

    Design and implement statements using Data Definition Language (DDL).

  • 4.3

    Implement Form commands using Data Manipulation Language.

  • 4.4

    Manage the use of Data Control Language statements.

5

Be able to implement Relational Algebra.

Assessment Criteria

  • 5.1

    Design relational algebra to improve database design.

  • 5.2

    Implement joins in a database.

6

Be able to manage database transactions and security.

Assessment Criteria

  • 6.1

    Develop transactions and currency control.

  • 6.2

    Manage database security elements.