Module 4
DBMS for midrange computers include all of the following except
Microsoft Access.
The tool that enables users to view the same data in different ways using multiple dimensions is
OLAP.
________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships.
Text mining
When you design the new contracts database for the publishing house mentioned above, what fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?
a) Author first name/last name, author address, title of book, book ISBN, date of publication, b) Amount of money payments and other finances cost
You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of
classification.
All of the following are technologies used to analyze and manage big data except
cloud computing.
The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.
data redundancy
The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database?
establishing a good data model, determining which data is key, beyond looking up contract information, and determining how end users will use the data,
Data mining is a tool for allowing users to
find hidden relationships in data.
A data warehouse is composed of
historic and current internal data.
You work for a retail clothing chain whose primary outlets are in shopping malls, and you are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable of
identifying sequences.
Which of the following non-digital data storage items is most similar to a database
library card catalog
A DBMS reduces data redundancy and inconsistency by
minimizing isolated files with repeated data.
In terms of data relationships, associations refers to
occurrences linked to a single event.
A DBMS makes the
physical database available for different logical views
The logical view
presents data as they would be perceived by end users.
A field identified in a table as holding the unique identifier of the table's records is called the
primary key.
Which of the following is not one of the main problems with a traditional file environment?
program-data independence
Duplicate data in multiple data files is called data ________.
redundancy
The type of logical database model that treats data as if they were stored in two-dimensional tables is the
relational DBMS.
) In a table for customers, the information about a single customer would reside in a single
row.
A nationwide magazine publisher has hired you to help analyze their social media datasets to determine which of their news publications are seen as the most trustworthy. Which of the following tools would you use to analyze this data?
sentiment analysis software
Which of the following best illustrates the relationship between entities and attributes?
the entity CUSTOMER with the attribute PURCHASE
In a relational database, a record is referred to in technical terms as a(n)
tuple.
OLAP is a tool for enabling
users to obtain online answers to ad-hoc questions in a rapid amount of time.
