APSU CSCI 4400 MIDTERM EXAM WITH COMPLETE
SOLUTIONS 100% VERIFIED
Data - ANSWER unprocessed raw facts that can be built up into information
information - ANSWER results from processing raw data to reveal meaning
end-user data - ANSWER raw facts of interest to the end user
metadata - ANSWER data that describes other data
Database Management System (DBMS) - ANSWER a program used to create, process,
and administer a database
single-user database - ANSWER A database that supports only one user at a time.
multiuser database - ANSWER A database that supports multiple concurrent users.
centralized database - ANSWER A database located at a single site.
distributed database - ANSWER data is distributed across different sites
cloud database - ANSWER A database that is created and maintained using cloud
services, such as Microsoft Azure or Amazon AWS.
general-purpose database - ANSWER A database that contains a wide variety of data
used in multiple disciplines.
, discipline-specific database - ANSWER A database that contains data focused on
specific subject areas.
operational database - ANSWER Designed to support a company's day-to-day
operations
analytical database - ANSWER Stores historical data and business metrics used
exclusively for tactical or strategic decision making
data warehouse - ANSWER Stores data in a format optimized for decision support
Online Analytical Processing (OLAP) - ANSWER Tools for retrieving, processing, and
modeling data from the data warehouse
Business Intelligence - ANSWER Captures and processes business data to generate
information that support decision making
File System Redux - ANSWER modern end user productivity tools-
includes spreadsheet programs such as excel
structural dependence - ANSWER - access to file is dependent on its structure
- all programs must conform to the structure
structural independence - ANSWER File structure is changed without affecting the
application's ability to access the data
data dependence - ANSWER data access changes when data storage characteristics
change
SOLUTIONS 100% VERIFIED
Data - ANSWER unprocessed raw facts that can be built up into information
information - ANSWER results from processing raw data to reveal meaning
end-user data - ANSWER raw facts of interest to the end user
metadata - ANSWER data that describes other data
Database Management System (DBMS) - ANSWER a program used to create, process,
and administer a database
single-user database - ANSWER A database that supports only one user at a time.
multiuser database - ANSWER A database that supports multiple concurrent users.
centralized database - ANSWER A database located at a single site.
distributed database - ANSWER data is distributed across different sites
cloud database - ANSWER A database that is created and maintained using cloud
services, such as Microsoft Azure or Amazon AWS.
general-purpose database - ANSWER A database that contains a wide variety of data
used in multiple disciplines.
, discipline-specific database - ANSWER A database that contains data focused on
specific subject areas.
operational database - ANSWER Designed to support a company's day-to-day
operations
analytical database - ANSWER Stores historical data and business metrics used
exclusively for tactical or strategic decision making
data warehouse - ANSWER Stores data in a format optimized for decision support
Online Analytical Processing (OLAP) - ANSWER Tools for retrieving, processing, and
modeling data from the data warehouse
Business Intelligence - ANSWER Captures and processes business data to generate
information that support decision making
File System Redux - ANSWER modern end user productivity tools-
includes spreadsheet programs such as excel
structural dependence - ANSWER - access to file is dependent on its structure
- all programs must conform to the structure
structural independence - ANSWER File structure is changed without affecting the
application's ability to access the data
data dependence - ANSWER data access changes when data storage characteristics
change
