Skip to main content
Ctrl+K
Logo image
  • Introduction

The course and its tools

  • Overview
    • Syllabus
    • Installation
    • Communication
    • Assessment

Networks

  • Networks
    • Network models
    • Network Components
    • Network Performance

Data management

  • Data Management
    • Database Management Systems
    • Data and information
    • Flat File vs Relational Database
    • Relational Database Management Systems
  • Core database concepts
    • Organisation
    • Datatypes
    • Hierarchy of Data
    • Relationships
    • Primary and foreign keys
    • Composite Keys
    • Data anomalies
  • Data modelling
    • Data dictionaries
    • Entity Relationship Diagrams
  • Data Integrity
    • Factors influencing integrity
    • Validity vs Accuracy
  • Normalisation
    • Purpose of Normalisation
    • Process of normalisation
    • Normalise to First Normal Form
    • Normalise to Second Normal Form
    • Normalise to Third Noraml Form
  • Database creation and manipulation
    • SELECT
    • INSERT
    • DELETE
    • UPDATE
    • ORDER BY
    • INNER JOIN
    • Aggregate Functions
  • Development Issues
    • Ethical Issues
    • Security Issues
    • Ethical Issues

Index

A | T

A

  • A second term

T

  • Term one

By Gavin Coombes

© Copyright 2022.