Chapter 1 Review

A user view is:

A logical description of some portion of the database.

Database management involves all of the following EXCEPT:

Design web pages.

Metatdata typically describes all of the following EXCEPT:

Location on disk.

Legacy systems often contain data of ________ quality and are generally hosted on ________.

Poor; mainframes

All of the following are primary purposes of a database management system (DBMS) EXCEPT:

Providing an integrated development environment.

________ are established between entities in a well-structured database so that the desired information can be retrieved.

Relationships

A major difference between data warehouses and transactional systems as compared to big data is:

The data is unstructured in big data systems.

A database is an organized collection of ________ related data.

Logically

A graphical system used to capture the nature and relationships among data is called a(n):

Data model.

Which organizational function should set database standards?

Database Administration

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):

Entity.

Program-data dependence is caused by:

File descriptions being stored in each database application.

Data that describe the properties of other data are:

Metadata.

According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored more than:

More than 7 billion exabytes of data.

Which of the following is NOT an advantage of database systems?

Redundant data

Relational databases establish the relationships between entities by means of common fields included in a file is called a(n):

Relation.

With the database approach, data descriptions are stored in a central location known as a:

Repository.

________ is a tool even non-programmers can use to access information from a database.

Structured query language

Because applications are often developed independently in file processing systems:

Unplanned duplicate data files are the rule rather than the exception.

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

User view