FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Behind the Scenes: Databases and Information Systems

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Short Answer

Review LaterAdd Note

Review Later

In a relational database, a(n)________ relationship indicates that a record that appears only one time in a table, may appear multiple times in a related table.

Correct Answer

verified

one-to-man...

View Answer

Show Answer

Question 32

Matching

Review LaterAdd Note

Review Later

Match each of the following terms to its definition:

Premises

Responses

data mart

software that tries to replicate the decision making of human specialists

expert system

includes transforming data to fit into a data warehouse

artificial intelligence

attempts to create computers that think like humans

data mining

small slices of the data warehouse

data staging

process by which great amounts of data are analyzed and investigated

Premises

data mart

expert system

artificial intelligence

data mining

data staging

Responses

software that tries to replicate the decision making of human specialists

includes transforming data to fit into a data warehouse

attempts to create computers that think like humans

small slices of the data warehouse

process by which great amounts of data are analyzed and investigated

Show Answer

Correct Answer

Premises

Responses

data mart

expert system

artificial intelligence

data mining

data staging

Premises

data mart

expert system

artificial intelligence

data mining

data staging

Responses

Question 33

Short Answer

Review LaterAdd Note

A(n)________ provides a view of data fields to be filled in with appropriate labels to assist a user in entering data into the database.

You would use a ________ to temporarily display records of residents of the city of Boston.

Match the following data checks to their definition:

Which of the following is NOT a likely primary key?

________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table.

The information in a data mart spans an entire enterprise.

Data in a multidimensional database is organized in a ________ format.

________ is used to ensure that data is organized most efficiently.

A large data mart might require a database administrator to design, construct, and maintain it.

________ is the branch of computer science that attempts to create computers that think like humans.

The data in a data warehouse are ________, meaning they do not all pertain to one period in time.

________ is used to analyze large amounts of data and identify unseen patterns or trends.

________ involves putting data into an electronic file in a format that another application can recognize.

When creating a data warehouse, ________ is the process that extracts data from source databases, reformats the data, and stores them in the warehouse.

Most databases can import electronic data from other software applications.

A data dictionary is also referred to as a(n)________.

Data ________ helps to ensure data integrity by maintaining information in only one place.

Data staging consists of all of the following steps, EXCEPT ________.