Download Database Systems Design, Implementation, and Management 11e - Chapter 1 - Database System and more Exams Nursing in PDF only on Docsity!
Database Systems Design, Implementation, and
Management 11e - Chapter 1 - Database Systems Exam
with Well Detailed Question & Answers Perfectly A+
Grade (New Updated Version)
data ANSWER>>>> raw facts
information ANSWER>>>> result of processing raw data to reveal its meaning
knowledge ANSWER>>>> body of information and facts about a specific subject
data management ANSWER>>>> discipline that focuses on the proper generation,
storage, and retrieval of data
database ANSWER>>>> shared, integrated computer structure that stores a collection of
end-user data and metadata; a collection of self-describing data; resembles a very well- organized electronic filing cabinet in which powerful software (the dbms) helps manage the cabinet's contents
end-user data ANSWER>>>> raw facts of interest to the end user
metadata ANSWER>>>> data about data, through which the end-user data are integrated
and managed
database management system (DBMS) ANSWER>>>> a collection of programs that
manages the database structure and controls access to the data stored in the database; intermediary between the user and the database
data inconsistency ANSWER>>>> exists when different versions of the same data appear
in different places
query ANSWER>>>> a specific request issued to the DBMS for data manipulation; simply
put it is a question
ad hoc query ANSWER>>>> is a spur-of-the-moment question
query result set ANSWER>>>> answer to a query sent back by the DBMS to the
application
data quality ANSWER>>>> comprehensive approach to promoting the accuracy, validity,
and timeliness of the data
single-user database ANSWER>>>> supports only one user at a time
desktop database ANSWER>>>> a single-user database that runs on a personal computer
data processing (DP) specialist ANSWER>>>> hired to create computer-based system that
would
structural dependence ANSWER>>>> means that access to a file is dependent on its
structure
structural independence ANSWER>>>> exists when you can change the file structure
without affecting the application's ability to access the data
islands of information ANSWER>>>> when the structure supports scattering the data into
several location, each location is an island; often causes data to be in several different versions because the locations aren't updated consistently
analytical database ANSWER>>>> focuses primarily on storing historical data and
business metrics used exclusively for tactical or strategic decision making
business intelligence ANSWER>>>> describes a comprehensive approach to capture and
process business data with the purpose of generating information to support business decision making
data anomaly ANSWER>>>> develops when not all of the required changes in the
redundant data are made successfully
data dependence ANSWER>>>> when change to any of the file's data storage
characteristics change all data access programs
data independence ANSWER>>>> when you can change the data storage characteristics
without affecting the program's ability to access the data
data dictionary ANSWER>>>> used by the dbms to look up the required data component
structures and relationship
data integrity ANSWER>>>> the condition in which all of the data in the database are
consistent with the real-world events and conditions
data quality ANSWER>>>> a comprehensive approach to promoting the accuracy, validity,
and timeliness of the data
data warehouse ANSWER>>>> a specialized database that stores data in a format
optimized for decision support; contains historical data obtained from the operational databases as well as data from external sources
data redundancy ANSWER>>>> exists when the same data are stored unnecessarily at
different places
database system ANSWER>>>> an organization of components that defines and regulates
the collection, storage, management, and use of data in a database environment
discipline-specific database ANSWER>>>> a database that contains data focused on
specific subject areas
Extensible Markup Language (XML) ANSWER>>>> A metalanguage used to represent and
manipulate data elements. Unlike other markup languages, XML, permits the manipulation of a
physical data format ANSWER>>>> the way a computer "sees" (stores) data
production database ANSWER>>>> main database designed to keep track of the day-to-
day operations of a company; also known as transactional databases
query language ANSWER>>>> a nonprocedural language that is used by a DBMS to
manipulate its data
semistructured data ANSWER>>>> data that have already been processed to some extent
single-user database ANSWER>>>> a database that supports only one user at a time
social media ANSWER>>>> web and mobile technologies that enable "anywhere,
anytime, always on" human interaction
structured data ANSWER>>>> unstructured data that have been formatted to facilitate
storage, use, and information.
Structured Query Language (SQL) ANSWER>>>> a powerful and flexible relational
database language composed of commands that enable users to create database and table structures, perform various types of data manipulation and data administration, and query the database to extract useful information
unstructured data ANSWER>>>> data that exist in their original, raw state; that is, in the
format in which they were collected
XML database ANSWER>>>> a database system that stores and manages semistructured
XML data
