Exam 3: Database Systems and Big Data

At Coast-to-Coast Moving and Van Lines, Ryan is responsible for managing the flow of the company's data, from initial acquisition of new data to deletion of old, outdated data. Ryan is involved in ___________.

Suppose a new tech startup wants to define the data model. They would then ____.

One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and allow data to be organized more logically.

DBMSs are used primarily for modeling data.

If an organization is taking a "store everything" approach to data, it will save all the data in its raw and unaltered form in a _____.

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

A(n) _____ is a detailed description of all data used in a database.

In the relational database model, each row of a table represents a(n) _____.

If "color" is an attribute, then "green" is a data item.

A major advantage of NoSQL databases is the ability to spread data over multiple servers so that each server contains only a subset of the total data, a characteristic that is known as _____

Data modeling usually involves setting a specific business goal and then analyzing the data and information needed to reach that goal.

While building a data warehouse, you are converting dates to months. This second step in the ETL process is known as ______.

A database is a collection of integrated and related _____.

A database must reflect the business processes of an organization.

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

The ____ model database makes it easy to develop queries that involve joining two tables.

A relational model splits the information up into many two dimensional data structures.

Most of the data that an organization must deal with is _____ data, meaning that it is not organized in any predefined manner.

Suppose we have a table that stores student data. In that table we have a field - Student ID - that uniquely identifies each student. This field is known as the ____.

The _____ is a specific language, provided with a database management system (DBMS) that allows users to access and modify the data, to make queries, and to generate reports.