FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Database Systems and Big Data

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

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

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.

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

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.

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 ____.

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

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

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

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 _____.

DBMSs are used primarily for modeling data.

A database must reflect the business processes of an organization.

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

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 ___________.

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

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 _____.

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 _____