CH 6 CIS

One-to-one

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?

Relational

_______________ databases are by far the most popular type of database on the market today.

byte

A ________ in a database represents a single character such as a letter or number

bit

A ________ is represented by a 0 or 1.

in-memory computing

A method that allows complex business calculations to be performed on very large data sets in seconds is termed __________.

with a crow's foot preceded by a short mark.

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:

in two short marks.

A one-to-one relationship between two entities is symbolized in a diagram by a line that ends:

primary

A(n) __________ key uniquely identifies a row or record in a table.

Microsoft SQL Server

If you need a DBMS for large commercial use on a mainframe, which of the following is a viable option?

tuple

In a relational database, a record is also called a(n):

entity

In a student database, a collection of related attributes such as LastName, FirstName, and Student# creates a(n) _______________.

attribute

In a student database, a column called LastName would be an example of a(n) _____________

record

In a student database, a row that describes the top student, including his or her LastName, FirstName, and StudentNumber, is an example of a(n) ______________

cloud

Microsoft Azure SQL is an example of a _________________ data

referential

Relational databases enforce ______________ integrity to ensure, for instance, that a teacher can't be assigned to a CLASS table unless the teacher already exists in the TEACHER table

normalized

Relational tables need to be ______________ to help avoid duplicate data.

velocity

The "3V's" used to characterize big data include volume, variety, and _______.

manipulation

The data _______________ language allows you to retrieve information from the database (i.e., using the SELECT, FROM, WHERE commands).

extremely large data sets

The most common use of non-relational database management systems is for managing ________.

normalization.

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

database administration

The special organizational function whose responsibilities include the technical and operational aspects of managing data, including physical database design and maintenance, is called ________.

Specify the information policy

What is the first step in effectively managing data for a firm?

Structured Query Language

What is the most popular data manipulation language and method to "question" a database?

What the relationships inside the data are

Which of the following does NOT need to be addressed in an organization's information policy?

Data Mining

Which of the following involves searching for patterns and relationships among data?

Filter data

Which of the following is NOT a function of a data warehouse

Entity-relationship diagram

Which of the following is a popular way to describe relationships (i.e., one-to-one, one-to-many) in a relational database?

Hadoop extracts data from multiple tables that have a relationship.

Which of the following statements about Hadoop is FALSE?

Big data can be processed with traditional techniques.

Which statement about big data is FALSE?

OLAP

Which tool enables users to view the same data in different ways using multiple dimensions?