FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Database Systems and Applications

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Essay

Review LaterAdd Note

Review Later

Explain entity-relationship (ER) diagrams.

Correct Answer

verified

entity-relationship (ER) diagrams use ba...

View Answer

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

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

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

A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making.

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

Unstructured data comes from sources such as word-processing documents and scientific research.

Each attribute in a relational database model can be constrained to a range of allowable values called a _____.

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

Briefly describe the hierarchy of data.

Counterintelligence turns data into useful information that is kept closely guarded to avoid this information from falling into the hands of the wrong employees.

A collection of data fields all related to one object, activity, or individual is called a file.

A business intelligence _____ is a data visualization tool that displays the current status of the key performance indicators (KPIs) for an organization.

A(n) _____ is a database management system that stores the entire database in random access memory (RAM).

The relational database model is currently the most widely used.

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

Often, distinct yet related databases are linked to provide enterprise-wide databases.

Data modeling done at the level of an entire enterprise is called _____.

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