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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) flat file
B) schema
C) relational system
D) user view

E) All of the above
F) A) and B)

Correct Answer

verified

Show Answer

Question 22

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 23

Multiple Choice

Review LaterAdd Note

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

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.

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

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

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

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

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

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

The relational database model is currently the most widely used.

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

Briefly describe the hierarchy of data.

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

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 subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making.

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

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 ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.