IS 3003 Chapter 6 Databases and information management

What is the purpose of data dictionary?

an automated or manual file that stores definitions of data elements and their characteristics.

In a student database, a column called Lastname would be an example of a

attribute

A _______ is represented by a 0 or 1

bit

A ___________ in a databases represents a single character such as a letter or number

byte

Microsoft Azure SQL is an example of a​ _________________ database.

cloud

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

database administration

In a student database, a collection of related attributes such as Lastname, Firstname, and studentnumber creates a

entity

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

extremely large data sets

The data ___________ language allows you to retrieve information form the database

manipulation

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

normalized

A ___________ key uniquely identifies a row or record in a table

primary

In a student database, a row that describes the top student, including his or her Lastname, firstname, and studentnumber, is an example of a

record

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

referential

__________ database are by far the most popular type of database on the market today

relational

The "3Vs" used to characterize big data include volume, variety, and

velocity

Which statement about big data is False?

Big data can processed with traditional techniques

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

Data mining

Which of the following is a popular way to describe relationships in a relational database

Entity-relationship diagram

Which of the following is not a function of a data warehouse?

Filter data

Which of the following statements about Hadoop is False?

Hadoop extracts data from multiple tables that have a relationship.

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

In-memory computing

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

Microsoft SQL Server

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

OLAP

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

Specify the information policy

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

Structured Query Language

In memory computing

Technology for very rapid analysis and processing of large quantities of data by storing the data in the computer's main memory rather than in secondary storage.

What is normalization?

The process of creating small, stable data structures from complex groups of data when designing a relational database.

Why the primary key is important?

This key field is the unique identifier for all the information in any row of the table, and this primary key cannot be duplicated.

Which of the following does not need to be addressed in an organizations information policy

What the relationships inside the data are