Database Management — Short Notes

Purpose and scope

  • Database management organizes and protects structured data so that it can be stored, retrieved and maintained reliably.
  • Define the business need, users and outcomes before selecting an information system for database management.

Information system elements

  • table, record, primary key, foreign key, normalization, query.
  • Connect people, process, data and technology; specify who creates, uses and owns important information.

Process and decisions

  • Map data and work from input through processing to output; include approvals, exceptions and feedback.
  • Identify the decision supported, required information, timing and control responsibilities.

Application

  • A customer table can connect to orders through a key, reducing repeated data and enabling consistent reports.
  • Describe both the workflow and the information exchanged at each handoff.

Controls and limits

  • Poor design creates duplication and update anomalies; use access controls, integrity rules, backup and recovery.
  • Check data quality, security, privacy, access, continuity and user adoption as part of system design and operation.