CIS CHAPTER 6 HW
Microsoft's DBMS that includes built-in report generation and reporting is called ________.
Access
the structure of relational database tables
Each row is a unique record for one of the items in the table and each column is an attribute of the item.
An open source framework for parallel processing across inexpensive computers is called ________.
Hadoop
For handling unstructured and semi-structured data in vast quantities, as well as structured data, organizations are using _____________.
Hadoop
________ is the most popular NoSQL DBMS.
Hadoop
What makes a Blockchain system possible and attractive to business firms?
Its encryption and authentication processes make it highly secure for storing many kinds of data.
The SQL ________ statement allows you to combine two different tables.
JOIN
An emerging non-relational database management system is called ________.
NoSQL
________ use a more flexible data model and are designed for big data.
Non-relational database management systems
SQL stands for ________.
Structured Query Language
a database management system (DBMS) is a software program for creating, processing, and _____ a database.
administering
Another name for a database field is a(n) ________.
attribute
To describe datasets with volumes so huge that they are beyond the ability of typical DBMS to capture, store, andanalyze, the term __________ is used.
big data
A ________ is the smallest component in the computer system data hierarchy.
bit
A ________ is a component in the computer system data hierarchy that represents an ASCII character like a letter, a number, or another symbol.
byte
a spreadsheet is great to manage information about one thing(e.g., items for sale), but a _____ is preferred to manage information about more than one thing (e.g., items for sale and suppliers of items).
data base
The process of detecting and correcting errors in a database is called ________.
data cleansing
A(n) ________ is a collection of data organized to serve many applications efficiently.
database
The corporate function that is responsible for defining and organizing the content of the database as well as database maintenance is ________.
database administration
A(n) ________ enables an organization to centrally manage and organize data.
database management system
A ________ is software that enables an organization to centralize data, manage them efficiently, and provide access to the stored data by application programs.
database management system (dbms)
DBMS have a data________ capability that is used to specify the structure of the content of the database.
definition
metadata
describe characteristics of each field
A ________ provides the link from one table to another table's primary key.
foreign key
The term data ________ is used to describe the policies and processes for managing the availability, usability,integrity, and security of the data employed in an enterprise.
governance
Data is considered to be ________ when the same attribute has different values.
inconsistent
A(n) ________ is an important resource for an organization to create, illustrating rules on how data is organized and who has access to what data.
information policy
A(n) ________ specifies the rules of an organization for sharing and disseminating information.
information policy
a database is a collection of _____ records.
integrated
The formal process to remove data problems such as repeating groups is called ________.
normalization
Although "Big Data" doesn't refer to a specific amount of data, it usually does involve ________.
petabytes
Another term for a key field is a ________.
primary key
The field that uniquely identifies a row in a relational database table is called a ________.
primary key
The unique identifier for all data in a table is called the ________.
primary key
The coupling of files used to store information and the application program that updates and maintains those files is called ________.
program-data dependence
Another term for a database row is a(n) ________.
record
Microsoft SQL Server is a ________ for large mainframes and midrange computers
relational DBMS
Which of the following is a distributed database technology that enables firms and organizations to create and verify transactions on a peer-to-peer network nearly instantaneously without a central authority?
Blockchain
The sales, manufacturing, and inventory systems at a bicycle manufacturer use different codes to represent bicycle frame sizes. For example, in the sales system, a large bike frame is coded with "L", while the inventory system codes a large bike frame with "LG". This situation illustrates ________.
data inconsistency
A(n) ________ is a structured survey of the accuracy and level of completeness of data in an information system.
data quality audit
Data cleansing, also known as _________, consists of activities for detecting and correcting data in a database that are incorrect, incomplete, improperly formatted, or redundant.
data scrubbing
Data cleansing, working to identify and fix incorrect data, is also called ________.
data scrubbing
A(n) ________ is a database that stores historic and current data for the use of decision makers in the organization.
data warehouse
A(n) ________ database makes it possible to store information across millions of machines in hundreds of data centers around the globe, with special time-keeping tools to synchronize the data and ensure the data are always consistent.
distributed
A person, place, or thing which is stored in a database is called a(n) ________.
entity
A(n) ________ is the most popular method to model a database.
entity-relationship (ER) Model
A record describes a(n) ________ which is a person, place, thing, or event on which we store and maintain information. Each characteristic or quality describing a particular ________ is called a(n) ________.
entity; entity; attribute
A grouping of characters into a word or group of words is called a(n) ________.
field
A ________ is a component in the computer system data hierarchy that includes content such as Student ID 100, Course IS 101, and Grade A.
field
A ________ is a component in the computer system data hierarchy that consists of multiple records of the same type.
file
In relational databases, the ________ operation creates a subset of records in the file that meet stated criteria.
select
The most popular type of database today for PCs as well as for larger computers and mainframes is ___________ database.
the relational
All of the following are types of information obtained from data mining EXCEPT ________.
web beacons
________ is another way to facilitate big data analysis and remove bottlenecks normally found in a traditional database.
In-memory computing
