Flashcards : Fundamentals of Database Management Systems — 20 cartes

Organized data storage system managed by software.

Data, metadata, DBMS, users, hardware.

Unnecessary data duplication causing inconsistency.

Ties applications to data structure, complicating changes.

Manual and file-based data management to DBMS.

Supports daily business transactions.

Improves access speed and fault tolerance.

Manages, controls, and facilitates data access.

Data is raw facts; information is processed, meaningful data.

DBMS allowing multiple users access.

Data warehouse for analysis and decision-making.

Handling redundancy, ensuring security, maintaining integrity.

Ensures efficiency, accuracy, and data integrity.

Processed data that provides meaning.

Describes data characteristics and structure.

Storage waste, inconsistency, anomalies.

Redundancy, inconsistency, data dependence.

Single-user, multiuser, distributed, data warehouse.

Poor design, redundancy, and improper updates.

Unprocessed raw facts or figures.