Exam 3: Database Systems,Data Warehouses,and Data Marts

Describe the tasks performed in the first normal form (1NF)stage of normalization.

Describe how data stored in a relational model is retrieved from tables.

In large organizations,database design and management is handled by the database _________.

_____,a component of a data model,defines the boundaries of a database,such as maximum and minimum values allowed for a field.

The _____ view of a database involves how data is stored on and retrieved from storage media.

In a(n)_________ file structure,records in files are organized and processed in numerical order.

In a relational database model,a(n)_____ operation pares down a table by eliminating columns according to certain criteria.

What is the function of the data definition component of a database management system?

Business analytics uses _____ to support decision-making activities.

Explain the transformation processes used in data warehouses.

The _____ component of a database management system (DBMS)is responsible for data storage,manipulation,and retrieval.

Identify a file structure that is similar to a book index that lists page numbers where certain topics can be found.

Describe the features and benefits of an object-oriented database.

In a(n)_________ file structure,records can be accessed in any order,regardless of their physical location in storage media.

List the responsibilities of a database administrator (DBA).

A(n)_____ is not limited by the data's physical location.

In the context of data administration component,the acronym CRUD stands for _____.

An e-commerce site that needs frequent updates would benefit from the use of a static Web site.

Which of the following factors has made big data analytics accessible to nearly all types of organizations?

In a(n)_____ model,nodes with the same parents are called siblings.