Exam 5: Database Systems and Applications

Social graph analysis is a(n) _____ technique in which data is represented as networks where the vertices are the individual data points (social network users) and the edges are the connections among them.

As long as the tables in a relational database share one common _____, the tables can be linked to provide useful information and reports.

A database is a collection of integrated and related _____.

A data model is a diagram of data attributes and their relationships.

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

A description that tells the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user is called a(n) _____.

In the relational model, each row in a table represents an entity, and each column represents an attribute of that entity.

A collection of related records is called a(n) _____.

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.

A database must reflect the business processes of an organization.

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

Which of the following statements is true of a database?

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

_____ are quantifiable measurements that assess progress toward organizational goals and reflect the critical success factors of an organization.

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

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

______ is a form of database processing that supports top-down, query-driven data analysis.

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

In a relational database model, _____ involves combining two or more tables.

A(n) _____ is designed to store and retrieve data in a manner that does not rigidly enforce the atomic conditions associated with the relational database model in order to provide faster performance and greater scalability.