Create a database implementation

URN: TECHDUDB3
Business Sectors (Suites): IT Users
Developed by: e-skills
Approved on: 30 Mar 2022

Overview

This standard is about creating multi-table relational database implementations to store, process and retrieve data using database software.

This involves planning, designing and deploying multi-table database implementations. This includes creating forms and database queries to submit, extract and report on data. It also includes data migration and population of data into databases.

This standard is for those who need to create multi-table database implementations to store, process and retrieve data using database software to meet their own needs or as part of their duties.


Performance criteria

You must be able to:

  1. Identify database requirements with stakeholders
  2. Plan a database implementation with multiple tables to meet requirements

  3. Construct a multi-table database with appropriate fields and properties using approved tools and techniques

  4. Create relationships between database tables

  5. Develop forms to access, enter, edit and organise data in a database in line with requirements

  6. Create and run database queries to correctly retrieve, update and delete selected data

  7. Produce database reports from a multi-table database in line with organisational requirements

  8. Migrate data into database records accurately


Knowledge and Understanding

You need to know and understand:

  1. What types of information are stored in a multiple-table database
  2. How a database design enables data to be organised across multiple tables
  3. How to design a multi-table database implementation
  4. How to create multi-table database queries
  5. How to maintain data integrity in database table structures
  6. How to create reports from multiple-table databases
  7. The use of indexes and key fields to organise data in multi-table databases
  8. How relationships are established in a multi-table database,
  9. How data is structured in a multi-table database
  10. The main field characteristics of a data record including data type, field name, field size, field format
  11. How to check for data integrity
  12. What is meant by data migration
  13. The main problems that can arise with database tables including redundant data and duplication
  14. The different relationships that can be made between database tables, including one to one; one to many; many to many

Scope/range


Scope Performance


Scope Knowledge


Values


Behaviours


Skills


Glossary


Links To Other NOS


External Links


Version Number

1

Indicative Review Date

30 Mar 2025

Validity

Current

Status

Original

Originating Organisation

ODAG Consultants Ltd

Original URN

TECHDUDB3

Relevant Occupations

ICT for Users

SOC Code

4159

Keywords

database