MIS CH6

Pre-configured hardware-software systems that use both relational and nonrelational technology optimized for analyzing large data sets are referred to as:

analytic platforms.

Relational databases organize data into two-dimensional tables, called ________ with columns and rows.

relations

Businesses use ________ tools to search and analyze unstructured data sets, such as emails and memos.

text mining

We call the "CUSTID" (customer ID) in the Customer table as___ and in the Appointment Table as__. A) attribute, foreign key B) primary key, foreign key C) foreign key, primary key D) primary key, attribute

B) primary key, foreign key

Which of the following best illustrates the relationship between entities and attributes? A) The entity ADDRESS with the attribute CUSTOMER B) The entity PRODUCT with the attribute CUSTOMER C) The entity CUSTOMER with the attribute ADDRESS D) The entity PRODUCT with the attribute PURCHASE E) The entity CUSTOMER with the attribute PRODUCT

C) The entity CUSTOMER with the attribute ADDRESS

All of the following are elements of a data governance policy except identifying: A) who is responsible for updating and maintaining information. B) which users and organizational units can share information. C) how data resources should be secured. D) where information can be distributed. E) the structure of the company's database.

E) the structure of the company's database.

A characteristic or quality describing an entity is called a(n):

attribute.

Capabilities and tools to manage and analyze large quantities and different types of data from multiple sources are collectively known as:

business intelligence infrastructure.

Big data refers to any database that:

has a large volume and variety of data.

A one-to-one relationship between two entities is symbolized in a diagram by a line that ends:

in two short marks.

The logical view of a database:

presents data as they would be perceived by end users.

Which of the following allows users to add, change, delete, or retrieve data in a database? A) Data dictionary B) Attribute generation C) Report generation tools D) Data manipulation language E) Query wizard tool

D) Data manipulation language

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security? A) Data definition diagram B) Referential integrity module C) Entity-relationship diagram D) Relationship dictionary E) Data dictionary

E) Data dictionary

Which one is most likely an attribute? A) Customer B) Employee C) Appointment D) Product E) First_Name

E) First_Name

As described in the chapter case, all of the following are benefits of Domino's new data management platform except the ability to: A) assess the buying patterns of each customer as an individual. B) cleanse data from different data sources. C) assess the performance of individual stores and franchise groups. D) enrich data with data from third-party sources. E) keep the data more secure.

E) keep the data more secure.