2-2

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

1:1

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

1:M

The object-oriented model ________.

Adds semantic content

The network database models have ________.

An owner/member relationship that promotes database integrity

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

Conceptual

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

Conceptual

What is the name for the most current version of the ERD?

Crow's Foot Notation

The most widely used conceptual model is the ________ model.

ER

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

Easier Database Design

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

Entity

In response to the increasing complexity of applications, two new data models emerged: the object-oriented data model and the ________ relational data model.

Extended

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

External

A specific representation of an external view is known as a(n) ________.

External Schema

Which data model contains the least semantics?

Hierarchical

Classes are organized as a class ________.

Hierarchy

The ________ model adapts a conceptual model to a specific DBMS.

Internal

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

M:N

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

Method

What model requires the most detail in its internal model?

Network

In the object-oriented data model (OODM), both data and their relationships are contained in a single structure known as a(n) ________.

Object

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

How is an entity represented in an ERD?

Rectangle

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 Engines

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

Schema

A ________ is the equivalent of a file system's record type.

Segment

The hierarchical model depicts a(n) ________ of one-to-many relationships.

Set

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

Structured Query Language (SQL)

A relational database is a collection of ________.

Tables

What modern development gave the use of complex objects a boost?

The Internet

The hierarchical database model is based on a ________.

Tree sturcture

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

Unstructured

Which data model was developed most recently?

XML

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

abstraction

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

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

constraints

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

entity

Traditionally, database designers relied on ________ to help them develop a good design.

good judgment

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

implementation

A relation is a matrix consisting of a series of row and column ________.

insections

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

instance

What is the fastest and most direct source of business rules?

interview with end users

Data models were developed to ________.

model real-world objects or events

Which data model contains the most semantics?

object-oriented

The hierarchical database model depicts a set of ________ relationships.

one-to-many

The ERDM is primarily geared to business applications, while the OODM tends to focus on ________ applications.

very specialized engineering and scientific