____is the result of revealing the meaning of raw facts.

Information

End_user data is____.

raw facts of interest to the end user

______provide a description of the data characteristics and the set of relationships that link the data found within the database.

Metadata

______exists when different versions of the same data appear in different places.

Data Incnsistency

The response of the DBMS to a query is the _____.

Query result set.

Data Warehouse contains historical data obtained from the______.

operational databases

_____data exist in the format in which they were collected.

unstructured

_______data exist in a format that does not lend itself to processing that yields information.

Unstructured

______is defined as the condition in which all the data in the database are consistent with the real-world events and conditions.

Data Integrity

The term_____ refers to an organization of components that define and regulate the collection,storage, management and use of data within a database environment.

Database system.

Business rules are derived from____.

A detailed description of an organization's operations

A noun in a business rule translates to a(n)___ in the data model.

Entity

A verb associating two nouns in a business rule translates to a(n)___in the data model.

Relationship.

A(n)___ represents a particular type of object in the real world.

Entity

The___model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.

entity relationship

A(n)___ is anything about which data are to be collected and stored.

Entity

A(n)___is the equivalent of a field in a file system.

attribute

A(n)__ is bidirectional.

Relationship

____are important because they help to ensure data integrity.

Constraints

Students and classes have a ____relationship.

Many-to-many

The logical view of the relational database is facilitated by the creation of data relationships based on a logical construct knows as a(n)___.

Relation

In a relational table, each column has a specific range of values knows as the ____domain

Attribute

In the relational model,___are important because they are used to ensure that each row in a table is uniquely identifiable.

Keys

Attribute A determines attribute B(that is, B is functionally _____ on A) if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

Dependent

A(n)____key can be described as a superkey without unnecessary attributes.

candidate

If the foreign key contains either matching values or nulls, the table that makes use of that foreign key is said to exhibit ___integrity.

referential

To avoid nulls, some designers use special codes, known as____, to indicated the absence of some value.

Flags

The relational operators have the property of ____; that is, the use of relational algebra operators on existing relations(tables)produce new relations.

Closure

PRODUCT yields all possible pairs of rows from two tables--also known as the ____product.

Cartesian

The___ is the real power behind the relational database, allowing the use of independent tables linked by common attributes

JOIN

A(n)___links tables on the basis of an equality condition that compares specified columns of each table.

equijoin

The___joins are especially useful when you are trying to determine what value(s) in related tables cause(s) referential problems.

Outer

A(n)____provides a detailed description of all tables found with the user/designer-created database

data dictionary

The___relationship is the relational database norm.

1:M

If one department chair--a professor--can chair only one department and one department can hae only one department chair, the the entities PROFESSOR and DEPARTMENT exhibit a(n)___relationship.

1:1

The ___relationships can be implemented by creating a new entity in 1:M relationships with the original entities.

M:N

The proper use of ___keys is crucial to controlling data redundacy

Foreign

A(n)___is an orderly arrangement used to logically access rows in a table.

Index

The index Key can have multiple attributes, this is call a(n)____index

composite

Codd's rule of ____states that every value in a table is guaranteed to be accessible through a combination of table name, primary key value, and column name.

Guaranteed Access.

The Chen model is especially useful to illustrate the database from a(n)___perspective.

Conceptual

Successful database design is, first and foremost, based on ___requirements.

End-user.

A derived attribute____.

need not be physically stored within the database.

Cardinality expresses___ number of entity occurrences associated with one occurrence of the related entity

the specific.

A____attribute can be further subdivided to yield additional attributes.

composite

If an entity can exist apart from one or more related entities, it is said to be ___-independent

existence

A___relationship exists when two entities are associated.

binary

The set of possible values for an attribute is a ___.

domain

What type of attribute cannot be created in a DBMS?

Multivalued

A relationship name should be a(n)___.

verb

From a Structural point of view, 2NF is better than this

1NF

It produces a lower normal form

denormalization

it cause data redundancies of data on every row entry

duplication

Any attribute whose value determines other values within a row

determinant

A process to help reduce the likelihood of data anomalies

normalization

it derives its name from the face that a group of multiple entries of the same type can exist for any single key attribute occurrence.

repeating group

Any attribute that is at least part of a key

prime attribute

a diagram that depicts all dependencies found within a given table structure.

dependency diagram

a dependency bases on only a part of a composite primary key.

partial dependency

Refers to the level of detail represented by the values stored in a table's row.

granularity

Relational models view the data as part of a table or collection of tables in which all key values must be idenified

True

Repeating groups must be eliminated by making sure that each row defines a single entity

True

Converting a database format to 1NF to 2NF is a complex process.

False

A table is in 2NF if it is in 1NF and it includes no partial dependecies

True

It is possible for a table in 2NF to exhibit transitive dependency, where one or more attributes may be functionally dependent on non-key attributes.

True

Denormalization is a process for assigning attributes to entities

False

Dependencies that are based on only a part of a composite primary key are called transitive dependencies

False

Repeating groups must be eliminated by making sure that each column defines a single entity.

False

All relational tables satisfy the 1NF requirements.

True

Atomic attributes are attributes that can be further divided.

False