Ch 5: Database Systems and Big Data

An Enterprise Resource (ER) diagram helps designers analyze data and information needs of an organization.

Traditional data management hardware, software, and analysis are capable of dealing with Big Data.

Relational Database Model places data in two-dimensional tables that are linked by at least one common attribute.

Data Marts are small slices of the data warehouse that contains greater detailed data.

Data Warehouse is a very large database that collects business information from many sources.

Business Intelligence tools can help managers relate information in innovative ways to make better decisions.

DBMS Concurrency Control enables access to the same record at the same time by two applications.

Which of the following is NOT true about a NoSQL database?

Which of the following is NOT in the hierarchy of data in a relational database?

An organization-wide approach to managing data and information is called

Which of the following is an important function in the management of Big Data?

Which of the following is NOT true about a relational database model?

Which of the following is NOT true of a Data Lake.

The Foreign key is a field or set of fields that uniquely identifies the record.

Which of the following is NOT a characteristic of Big Data?

The DBMS approach to data management is based on discrete files dedicated to each system.

The DBMS uses the schema to find where to access requested data in relation to another piece of data.

Things to consider when building a database include

________ describe the entire structure of the database, including tables, fields, and relationships.

An In-Memory database stores the entire database in RAM, providing much faster access to data. 

Data Warehouse follow an ETL process, which stands for

Which of the following is a challenge in managing and processing Big Data?

___ is a special-purpose programming language for accessing data stored in a relational database.

The performance of NoSQL databases drops off as the volume of data increases.

Which of the following is NOT an advantage of a NoSQL database?

NoSQL databases conform to ACID properties, namely Atomicity, Consistency, Isolation, and Durability.

An ER Diagram helps designers organize related data in a meaningful way to transform it into useful information.

Combining two or more tables via common data attributes is called:

A person, place, or thing for which data is collected, stored, and maintained is called

Which of the following is a NOT a typical generator of Big Data?

In a relational database, the Foreign key in one table points to the Primary key in another table.

________ is the process of identifying bad data and rejecting it at time of data entry.

The DBMS provides applications with a logical access path to data within a shared database.

Which of the following should you try to minimize when designing a database?

Extremely large and complex data collections are often referred to as ______.