Karteikarten: Fundamentals of Database Management Systems — 20 Karten

Database — definition?

Organized data storage system managed by software.

Database environment — includes?

Data, metadata, DBMS, users, hardware.

Data redundancy — issue?

Unnecessary data duplication causing inconsistency.

Data dependence — problem?

Ties applications to data structure, complicating changes.

Database evolution — from what?

Manual and file-based data management to DBMS.

Operational database — purpose?

Supports daily business transactions.

Distributed database — advantage?

Improves access speed and fault tolerance.

DBMS — purpose?

Manages, controls, and facilitates data access.

Data vs. information — difference?

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

Data sharing — supported by?

DBMS allowing multiple users access.

Analytical database — also?

Data warehouse for analysis and decision-making.

Database management challenges?

Handling redundancy, ensuring security, maintaining integrity.

Database design — importance?

Ensures efficiency, accuracy, and data integrity.

Information — role?

Processed data that provides meaning.

Metadata — function?

Describes data characteristics and structure.

Data redundancy issues?

Storage waste, inconsistency, anomalies.

File system — limitations?

Redundancy, inconsistency, data dependence.

Types of databases — examples?

Single-user, multiuser, distributed, data warehouse.

Data anomalies — caused by?

Poor design, redundancy, and improper updates.

Data — definition?

Unprocessed raw facts or figures.