Exam 3: Database Systems,data Centers,and Business Intelligence

Explain entity-relationship (ER)diagrams.

One of the most effective competitive intelligence measures is to define "trade secret" information relevant to a company and control its dissemination.

Data warehouses allow managers to _____ to get increasing levels of detail about business conditions.

A(n)______ is an individual responsible for defining and implementing consistent principles for a variety of data issues.

_____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.

One of the final steps in installing and using a large database involves "telling" the database management system (DBMS)the logical and physical structure of the data and the relationships among the data for each user.

_____ is the process of detecting and then correcting or deleting incomplete,incorrect,inaccurate,irrelevant records that reside in a database. ​

A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Describe business intelligence (BI).

In the relational model,each column in the table represents an entity,and each row represents an attribute of that entity.

A(n)_____ is a characteristic of an entity.

Online analytical processing (OLAP)and data mining are essentially the same thing.

In-memory databases (IMDBs )perform best on multiple multicore central processing units (CPUs)that can process parallel requests to the data.

A(n)_____ is a simple database program whose records have no relationship to one another.

A NoSQL database is highly scalable,meaning that a large database may be distributed across hundreds,thousands,or even tens of thousands of servers running the same NoSQL database management system.

Basic data manipulations include _____ that involves eliminating rows in a relational database according to certain criteria.

A business intelligence dashboard cannot be tailored to display metrics targeted for a single point or department.

The specific value of an attribute,called a(n)_____,can be found in the fields of a record describing an entity.

_____ is an approach that starts by investigating the general data and information needs of the organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.

By separating descriptions of the characteristics of an object,activity,or individual,a record can provide a complete description of it.