Database Management — Mind Map

Database Management

People · process · data · technology

  • Purpose

    Database management organizes and protects structured data so that it can be stored, retrieved and maintained reliably.

  • System components

    table · record · primary key

  • Data and process

    foreign key · normalization · query

  • Decision cycle

    Need → design → implement → operate → measure → improve

  • Application

    A customer table can connect to orders through a key, reducing repeated data and enabling consistent reports.

  • Governance

    Poor design creates duplication and update anomalies; use access controls, integrity rules, backup and recovery.