Database Environment & Development Process

Flashcards for review of key concepts related to database environments and systems.

What is a Database?

An organized collection of logically related data.

What is the difference between Data and Information?

Data is a collection of facts, while Information is data processed to increase knowledge in the person using the data.

What are the components of a database environment?

Data and database administrators, system developers, end users, user interface, application programs, DBMS, and repositories.

What is Metadata?

Data that describes the properties and context of user data.

What are the advantages of the Database Approach?

Program-data independence, reduced program maintenance, improved data quality, increased application development productivity, and improved decision support.

What are the limitations of File-Based Processing Systems?

Difficulty of getting quick answers, complex system administration, lack of security and limited data sharing, lengthy development times, and extensive program maintenance.

What is a Multi-Tiered Client/Server Database Architecture?

An architecture where client applications interact with a server that manages the database, often across multiple tiers.

What is the role of a Database Management System (DBMS)?

To manage data resources, create, maintain, and provide controlled access to user databases.

List two types of databases.

Single-user database and Multi-user database.

What is Data Warehousing?

Integrates data from multiple sources to maintain historical data and identify patterns and trends.