Exam 13: Designing Databases

Which order is correct in the retrieval and presentation of data? I. Select rows from the relation. II. Derive new attributes. III. Join two relations together. IV. Present data. V. Choose a relation from the database. VI. Project columns from the relation. VII. Calculate totals and performance measures. VIII. Index or sort rows.

Which order is correct for the analyst to normalize a data structure? I. Remove all repeating groups and identify the primary key. II. Remove any transitive dependencies. III. All partial dependencies are removed and placed in another relation.

The symbol used to represent additional attributes of another entity that may not be present on every record of the first entity is called an:

What is denormalization?

Business analytics (BA)is a term that covers the ideas of using big data along with a variety of quantitatively based analytical tools (such as statistics and predictive modeling)to answer management questions about trends and what-if questions.

Entity integrity constraints are rules that govern the composition of primary keys.

Online analytic processing is meant to answer decision makers' complex questions.

________ is a process to eliminate repeating groups found in variable-length records.

Each separate data entity should create its own master database table .

Which is incorrect about reality, data, and metadata?

Any object or event about which someone chooses to collect data is an attribute.

Which of the following is not one of the four anomalies that may occur when creating database tables?

In database literature, the views are referred to as schema.

What is defined as any data item in a record that is used to identify the record?

An associative entity is used for repeating groups.

________ is the transformation of complex user views and data stores to a set of smaller, stable data structures.

A master file contains information used to update master files and produce reports.

Indexing is the logical ordering of rows in a relation according to some key.

An alternative to building conventional files is building a ________.

Which of the following is not a difference between a data warehouse and a traditional database?