Exam 3: Database Systems and Big Data

An enterprise data model is created only for documentation, but is otherwise inconsequential.

_____ is the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records that reside in a database.

A(n) _____ is a field or set of fields that uniquely identify a record.

In the context of the relational database model, projecting involves eliminating columns in a table.

Organizations can collect many types of data from a wide variety of sources, but typically they only collect structured data that fits neatly into traditional relational database management systems.

The _____ model has become the most popular database model.

Today, most organizations use the traditional approach to data management, where multiple information systems share a pool of related data.

_____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of handling.

Suppose a manager wishes to analyze historical trends in sales. He would use the online transaction processing (OLTP) system.

Suppose you wish to find what tables are in a database, what fields they have, and how they are related you would review the _____.

A(n) ______ is an individual responsible for defining and implementing consistent principles for a variety of data issues.

A collection of data fields that are all related to one object, activity, or individual is called a file.

Kyle works for National Sporting Goods, where he manages critical data elements, such as identifying and acquiring new data sources, creating consistent reference data, and analyzing data for quality. Kyle is a _______.

Some of the key factors in database design are content, access, structure, archiving, and security.

Starting from monthly sales data, if you wish to get weekly sales data, use the ___ feature.

mySQL is a popular ____________.

For the ____ operation, it is required that the the two tables have a common attribute.

A database management system (DBMS) serves as an interface between an application program and a database.

In the context of the relational database model, selecting involves combining two or more tables.

A database administrator (DBA) is an important nontechnical position responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization.