Fundamental Concepts

25 flashcardsby —Griffith—
Study these flashcardsFree · spaced repetition · iPhone, Android, Mac & web

All cards

1
What is data?
Raw facts that are unprocessed and serve as the building blocks of information
2
What is information?
Data that has been processed to have meaning
3
Why is accurate, relevant, and timely information important?
It supports good decision making, which is essential for survival in a global environment
4
What is a database?
A shared, integrated computer structure that stores end-user data and metadata
5
What is a DBMS?
A collection of programs that manages the database structure and controls access to the data
6
One advantage of a DBMS
It allows data sharing among multiple applications or users
7
What is a single-user database?
A database that supports only one user at a time
8
What is a multi-user database?
A database that supports multiple users simultaneously
9
What is a desktop database?
A single-user database running on a personal computer
10
What is a workgroup database?
A multi-user database supporting a small group or department
11
What is an enterprise database?
A multi-user database supporting a large group or entire organization
12
What is a centralized database?
A database with data stored at a single site
13
What is a distributed database?
A database with data stored across several sites
14
What is a transactional database?
A database that supports a company’s day-to-day operations
15
What is a data warehouse?
A database that stores data for tactical or strategic decision-making, often containing historical data
16
Name the five components of a database system
Hardware, software, people, procedures, data
17
What is data dictionary management?
A DBMS function that defines data elements and their relationships (metadata)
18
What is data storage management?
A DBMS function that stores data, forms, report definitions, and related structures
19
What is data transformation and presentation?
A DBMS function that translates logical requests into commands to find and retrieve data
20
What is security management in a DBMS?
A function that enforces user security and data privacy
21
What is multiuser access control?
A DBMS function ensuring concurrent access without compromising data integrity
22
What is backup and recovery management?
A DBMS function providing procedures for data backup and recovery
23
What is data integrity management?
A DBMS function promoting and enforcing integrity rules
24
What is a database access language?
A query language provided by the DBMS for data access
25
What are database communication interfaces?
Tools that allow the database to accept end-user requests through various network environments
Study all 25 cards for free