Exam 4: Ethics and Information Security

To manage and organize various tables within the ________, developers must identify primary keys and foreign keys and use them to create logical relationships.

Describe the role and purpose of a database management system.

Data warehousing is about extending the transformation of ____ into analytical information.

An entity class (often called a(n) __________) in the relational database model is a collection of similar entities.

The ______ is accurate and complete.

A(n) ___________ is the common term for the representation of multi-dimensional information.

Bill Inmon, known as the "Father of Data Warehousing" described a data warehouse as a collection of data that is:

Distinguish between information accuracy and completeness with examples.

Operational systems are designed to perform:

What is a forward integration?

______________ integrity constraints are rules that enforce business rules vital to an organization's success.

Which of the following is a data mining approach for decision making?

All of the following are relational integrity constraints, except

Which of the following determines which things go together?

A(n) ___________ key in the relational database model is a primary key of one table that appears as an attribute in another table.

Explain the relationship between business intelligence and a data warehouse.

A data __________ contains a subset of data warehouse information.

What is information redundancy?

The ___________ database model is a type of database that stores its information in the form of logically related two-dimensional tables.

Which of the following is a valid type of integrity constraint?