WhatsApp
Skip to content
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.