Exam 5: Database Systems, Data Centres, and Business Intelligence

In the relational model, each row of a table represents a data entity or record and each column of the table represents an attribute or field.

Business intelligence turns data into useful information that is then kept closely guarded to prevent it falling into the hands of the wrong employees.

What is the term for the steps an organization takes to protect information sought by unauthorized parties?

Reader's Digest Canada's use of data in order to gain a better understanding of its major market segments is an example of data mining.

Public clouds are accessible to the ____________________ over the Internet.

In order to generate a report, Jane identifies the name of the database as well as the attributes.She then uses a set of commands and writes out a sentence to be executed.What is the term for this method of data manipulation?

The ____________________ is a collection of instructions and commands used to describe the logical and physical structure of the data and the relationships among the data for each user.

The database administrator decides the contents of the database with little or no input from the users of the database.

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

Competitive intelligence is gained through industrial espionage; the gathering of this information often includes illegal or unethical means.

What type of database systems have companies such as IBM developed to allow different databases to work together as a unified system?

There are rules in Canada that require companies to report serious incidents related to their DBMS product once it is installed and used.Where would such a report, be sent?

One of the rules at the university is that students are given an ID card bearing their names.The card is not transferable and if the student loses the card, it can be replaced for a fee.In data modelling, what is the relationship between student and ID card?

Today, most organizations use the database approach to data management, where multiple information systems share a pool of related data.

Without a well-designed, accurate database, executives, managers, and others do not have access to the ____________________ they need to make good decisions.

Which of the following processes uses a database to store and access data according to the locations it describes, and permits related queries and analysis?

A(n) ____________________ is typically a name, number, or combination of characters that describes an aspect of a business object.

What tool do database designers use to show the logical mapping among data?

Which of the following terms refers to the manipulation of data to gain increasing levels of detail about business conditions?

A(n) ____________________ is a field or set of fields that uniquely identifies a record.