/
Database Fundamentals and Management
Save to my account
Sign up
Database Fundamentals and Management
Database Fundamentals and Management
Study
1
Question
What distinguishes data from information in database contexts?
Page 4
Answer
Data are raw facts. Information is produced by processing raw data to reveal its meaning.
2
Question
What are the building blocks role of data in information creation?
Page 4
Answer
Data serves as building blocks of information through generation, storage, and retrieval.
3
Question
Why must information be accurate, relevant, and timely?
Page 4
Answer
To enable good decision making as the bedrock of knowledge.
4
Question
What is a database according to the shared structure definition?
Page 5
Answer
Shared, integrated computer structure storing end-user data and metadata.
5
Question
How does metadata support end-user data in a database?
Page 5
Answer
Describes data characteristics and relationships for integration and management.
6
Question
What is a DBMS in terms of programs and functions?
Page 5
Answer
Collection of programs managing database structure and controlling data access.
7
Question
What primary role does the DBMS serve between users and database?
Page 6
Answer
Acts as intermediary enabling data sharing and integrated views.
8
Question
How does DBMS handle application requests?
Page 6
Answer
Receives, translates into operations, and fulfills while hiding complexity.
9
Question
What does Figure 1.3 illustrate about DBMS function?
Page 7
Answer
Manages interaction: end users/applications send requests via DBMS to database structure with metadata, customers, invoices, products, end-user data.
10
Question
What is data inconsistency in DBMS context?
Page 8
Answer
Different versions of same data appearing in different places.
11
Question
Name four improved aspects from DBMS end-user productivity.
Page 8
Answer
Data sharing, data security, data access, decision making.
12
Question
How does DBMS improve data quality?
Page 8
Answer
Ensures accuracy, validity, and timeliness of data.
13
Question
What defines a single-user database?
Page 9
Answer
Supports one user at a time; desktop database runs on PC.
14
Question
How does multiuser database differ from single-user?
Page 9
Answer
Supports multiple users at the same time.
15
Question
What characterizes workgroup and enterprise databases?
Page 9
Answer
Workgroup: small users/specific department. Enterprise: many users across departments.
16
Question
Define centralized versus distributed databases by data location.
Page 10
Answer
Centralized: single site. Distributed: across different sites.
17
Question
What performance aspect defines cloud databases?
Page 10
Answer
Created and maintained using cloud services providing defined performance measures.
18
Question
Compare general-purpose and discipline-specific databases by data variety.
Page 11
Answer
General-purpose: wide variety across disciplines. Discipline-specific: focused on subject areas.
19
Question
What is an operational database designed for?
Page 11
Answer
Supports a company’s day-to-day operations.
20
Question
Describe analytical database purpose and exclusivity.
Page 12
Answer
Stores historical data and metrics exclusively for tactical or strategic decisions.
21
Question
What is a data warehouse and OLAP relation?
Page 12
Answer
Stores data optimized for decision support. OLAP tools retrieve, process, model data.
22
Question
Define business intelligence in database terms.
Page 12
Answer
Captures and processes business data to generate decision-supporting information.
23
Question
Differentiate unstructured, structured, and semistructured data.
Page 13
Answer
Unstructured: original state. Structured: formatted for processing. Semistructured: processed to some extent.
24
Question
What is XML's role in semistructured data?
Page 13
Answer
Extensible Markup Language represents data elements in textual format.
25
Question
Why focus on database design structure?
Page 14
Answer
Used to store and manage end-user data effectively.
26
Question
What benefits come from a well-designed database?
Page 14
Answer
Facilitates data management and generates accurate, valuable information.
27
Question
Outline the evolution stages of file system data processing.
Page 15
Answer
Manual file systems → Computerized file systems → File system redux with end-user tools.
28
Question
What characterizes computerized file systems in evolution?
Page 15
Answer
DP specialist created system to track data and produce reports.
29
Question
Define basic file terminology: data.
Page 16
Answer
Raw facts like telephone number, birth date, customer name, YTD sales value with little meaning until organized.
30
Question
What is a field in file terminology?
Page 16
Answer
Character or group (alphabetic/numeric) with specific meaning to define and store data.