Introduction to Database Management Systems

These flashcards cover key concepts related to Database Management Systems (DBMS) including definitions, advantages, and components of databases.

What does DBMS stand for?

Database Management System.

What is data?

Data are raw facts concerning objects and events that can be recorded and stored.

What is the difference between structured and unstructured data?

Structured data includes numbers, text, and dates, while unstructured data includes images, videos, and documents.

What is information?

Information is the result of processing raw data to reveal meaning.

Why is accurate, relevant, and timely information important?

It is key to good decision making.

What is a database?

An organized collection of structured information typically stored electronically.

What is metadata?

Data about data that describes the properties and context of user data.

List two advantages of using a DBMS.

Control of data redundancy and improved data integrity.

What is a file-based system?

A system where each application program defines and manages its own data.

What problem does data redundancy cause?

Inconsistencies in data and a waste of space.

What does the database approach solve?

It provides a central repository of shared data managed by a controlling agent.

Name one disadvantage of a DBMS.

Increased installation and management costs.

What are the components of the database environment?

Data modeling and design tools, repository, DBMS, database, application programs, user interface.

What type of database architecture is common in enterprise applications?

Multi-tiered Client/Server architecture.

What functions does an Enterprise Resource Planning (ERP) system integrate?

Manufacturing, finance, sales, marketing, inventory, accounting, and human resources.

What is the evolution of database technologies?

Flat files, hierarchical, network, relational, object-oriented, object-relational, and data warehousing.

What is the most popular database in 2024?

Oracle.