CSE 345 Exam 1

A way of classifying data models is by degree of ________.

Abstraction

The network database models have ________.

An owner/member relationship that promotes database integrity

A data ________ develops when all of the required changes in the redundant data are not made successfully.

Anomaly

A(n) ________ of the overall database design is required to overcome the fact that data are viewed in different ways by different people.

Blueprint

A(n) ________ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.

Business rule

A database that supports data located at a single site is called a ________ database.

Centralized

A(n) ________ model is independent of both hardware and software.

Conceptual

The ________ model presents a global view of the entire database.

Conceptual

The basic building blocks of all data models are entities, attributes, relationships, and ________.

Constraints

John is working in the customer table and needs to know what customers are located in Florida. To find the information he would ________.

Create a new query

The logical view of the relational database is facilitated by the ________.

Creation of data relationships based on a construct known as a table

The ________ receives all application requests and translates them into the complex operations required to fulfill requests.

DBMS

A raw fact such as a telephone number is known as ________.

Data

Because all data access programs are subject to change when any of a file's data storage characteristics change (that is, changing the data type), a file system is said to exhibit ________.

Data dependence

________ is a discipline that focuses on the proper generation, storage, and retrieval of raw facts needed by an information system.

Data management

The design of a ________ database recognizes the use of historical and aggregated data.

Data warehosue

The ________ is a specialized database that stores data in a format optimized for decision support.

Data warehouse

The ________ manages interaction between the end user and the database.

Data warehouse

________ are considered database architects.

Database designers

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

Distributed

One of the advantages of a relational data model is ________.

Easier database design

A CUSTOMER ________ would be described by attributes such as customer last name, customer first name, customer phone, customer address, and customer credit limit.

Entity

As a general rule, a noun in a business rule will translate into a(n) ________ in the model.

Entity

The most widely used conceptual model is the ________ model.

Entity relationship

Which model represents the end users' view of the data environment?

External

Database models can be grouped into two categories: conceptual models and ________ models.

Implementation

Where does the DBMS store the definitions of data elements and their relationships?

In a data dictionary

Which of the following would result in a data anomaly?

Inconsistent redundant data

Data ________ exists when it is possible to make changes in the data storage characteristics without affecting the application program's ability to access the data.

Independence

Each row in the relational table is known as an entity ________ in the ER model.

Instance

Wider access to well-managed data promotes a(n) ________ view of the organization's operations and a clearer view of the big picture.

Integrated

A(n) ________ model maps the conceptual model to the DBMS.

Internal

What is a benefit of using a DBMS?

It helps create an environment for end users to have access to more data

Which of the following products do not provide an enterprise database?

MS Access

What type of relationship is expressed with the phrase "Student takes Class"?

Many-to-many

What is the name for data about data?

Metadata

In the OO data model, a class ________ represents a real-world action such as finding a selected PERSON's name.

Method

Data models were developed to ________.

Model real-world objects or events

A(n) ________ allows the user to specify what must be done without specifying how it must be done.

Nonprocedural language

Which data model contains the most semantics?

Object-oriented

The hierarchical database model depicts a set of ________ relationships.

One-to-many

What type of relationship is expressed with the phrase "Painter paints Painting"?

One-to-many

What type of relationship is expressed with the phrase "Employee manages Store"?

One-to-one

Which model operates at the lowest level of abstraction?

Physical

When you can change the physical model without affecting the internal model, you have ________.

Physical independence

Each table must have a ________ key.

Primary

________ are the instructions and rules that govern the design and use of the database system.

Procedures

________ is the key to good decision making.

Production of accurate, relevant, and timely information

The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ________.

Query language

What is the name for an answer to a query that the DBMS sends back to the application?

Query result set

All fields for a specific entity can be grouped together as a ________.

Record

________ deals with fixing the database after a failure such as a disk or power failure.

Recovery

Data ________ exists when the same data are stored unnecessarily at different places.

Redundancy

From an end-user perspective, any SQL-based relational database application involves three parts: a user interface, a set of tables stored in the database, and the ________.

SQL Engine

Within the network model, the ________ is the conceptual organization of the entire database as viewed by the database administrator.

Schema

Database management systems, operating systems, applications and utilities are all examples of ________.

Software

________ independence exists when it is possible to make changes in the file architecture without affecting the application program's ability to access the data.

Structural

________ is the de facto query language and data access standard supported by the majority of DBMS vendors.

Structured Query Language

For most relational database software, the query language is ________.

Structured Query Language (SQL)

Data processing (DP) specialists are in existence because of ________.

The need to track data and produce required reports

Another name for a production database is a ________ database.

Transactional

Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ________.

Tuning

XML databases have emerged to address the need to manage ________ data within the native XML format.

Unstructured

A ________ database supports a relatively small number of users or a specific department within the organization.

Workgroup

A single-user database that runs on a personal computer is called a(n) ________ database.

Workgroup

An ad hoc query is a ________.

spur-of-the-moment-question