Exam 3: Database Systems and Big Data

A(n) _____ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Briefly describe the hierarchy of data.

Two sets of fields can have a common primary key.

Sometimes a database can contain "bad data," meaning incomplete, incorrect, inaccurate, or irrelevant records, which can be corrected or deleted through data cleansing.

A collection of fields all related to a single object, activity, or individual is a(n) _____.

_______ is an open-source software framework that includes several software modules that provide a means for storing and processing extremely large data sets.

With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet.

The database approach to managing data is superior to the file-based approach.

If you wish to develop expertise in database management, you must learn popular language known as ______.

______ use basic graphical symbols to show an organization of and relationships between data.

A _____ provides a means to store and retrieve data that is modeled using some means other than the simple two-dimensional tabular relations used in relational databases.

A database, a database management system, and the application programs that use the data, make up a database environment.

A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

A field is typically a name, number, or combination of characters that describes an aspect of a business object.

The position of a _____ is a non-technical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization.

In a relational database model, the range of allowable values for a data attribute is called its _____.

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

A database administrator (DBA) must have a clear understanding of the fundamental business of an organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

In the context of a database management system (DBMS), a(n) _____ interacts with other programs or applications and only indirectly interacts with people or users.

The smallest piece of data used by a computer is a(n) _____.