Exam 3: Database Systems,data Centers,and Business Intelligence

A collection of fields about a specific object is a record.

A database installed on a personal computer is typically meant for a single user.

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

One of the primary advantages of a relational database is that it reduces data redundancy and allows data to be organized more logically.

_____ is a data visualization technique in which data is represented as networks where the vertices are the individual data points and the edges are the connections among them.

A(n)_____ is a detailed description of all data used in a database.

A data warehouse stores historical data that has been extracted from operational systems and external sources.

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

_____ is one aspect of business intelligence and encompasses information about competitors and the ways that knowledge affects strategy,tactics,and operations.

Briefly describe the hierarchy of data.

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

Small,midsize,and large businesses need _____ database management systems (DBMSs)to share information throughout the organization over a network.

The _____ is a specific language,provided with a database management system (DBMS),which allows users to access and modify the data,to make queries,and to generate reports.

A(n)_____ is a basic building block of most information,consisting of upper-case letters,lowercase letters,numeric digits,or special symbols.

Which of the following statements is true of a database?

The _____ is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.

_____ databases rely upon concurrency control by locking database records to ensure that other transactions do not modify the database until the first transaction succeeds or fails,and as a result,can suffer from slow performance.

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

Business intelligence is gained through industrial espionage and the gathering of this information often includes illegal or unethical means.

In a relational database,_____ is the ability to combine two or more tables through common data attributes to form a new table with only the unique data attributes.