Review Questions Chapter 1 and 2

The ___________ database is a collection of records that is logically organized to conform with the upside-down tree.

hierarchical

The ___________ model was created to represent complex data relationships more effectively than the hierarchical model could and to impose a database standard.

network

A file system exhibits ________; that is, access to a file is dependent on its structure.

structural dependence

There are five types of relationships that exist between entities.

False

A DBMS performs several important functions that guarantee the ___________ and consistency of data in the database.

Integrity

A(n) ____________________ is a brief, concise, and unambiguous description of a policy.

Business Rule

A collection of programs that manages the database structure and controls access to the data stored in the database is called a(n) _______________.

DBMS- Database Management System

____________ exists when different versions of the same data appear in different places.

Data inconsistency

"Information" refers to raw facts.

False

A database that supports data distributed across several different sites is called a(n) centralized DBMS.

False

An operating system is part of the computer's hardware.

False

Because all data access programs are subject to change when any of the file's data storage characteristics change, the file system is said to exhibit structural dependence.

False

A logically connected or logically related set of one or more fields that describes a specific item is referred to as a(n) ____________.

Record

A set of one or more fields that describe a person, place, or thing is a(n)

Record

The query language for a relational database is _________________________.

SQL - Structured Query Language.

A data model represents data structures and their characteristics.

True

A(n) record is a logically connected set of one or more fields that describes a person, place, or thing.

True

Data inconsistency exists when different and conflicting versions of the same data appear in different place.

True

Metadata provide the description of the data characteristics but do not describe the set relationships that link the data found within the database.

True

There are three different types of anomalies: update, insertion, and deletion.

True