Database Systems: Design, Implementation, & Management: Database System Quizzes Flashcards

____is the result of revealing the meaning of raw facts.

End_user data is____.

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

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

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

Data Warehouse contains historical data obtained from the______.

_____data exist in the format in which they were collected.

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

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

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

Business rules are derived from____.

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

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

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

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

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

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

A(n)__ is bidirectional.

____are important because they help to ensure data integrity.

Students and classes have a ____relationship.

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

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

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

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.

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

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

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

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

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

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

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

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

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

The___relationship is the relational database norm.

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.

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

The proper use of ___keys is crucial to controlling data redundacy

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

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

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.

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

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

A derived attribute____.

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

A____attribute can be further subdivided to yield additional attributes.

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

A___relationship exists when two entities are associated.

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

What type of attribute cannot be created in a DBMS?

A relationship name should be a(n)___.

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

It produces a lower normal form

it cause data redundancies of data on every row entry

Any attribute whose value determines other values within a row

A process to help reduce the likelihood of data anomalies

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.

Any attribute that is at least part of a key

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

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

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

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

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

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

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

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.

Denormalization is a process for assigning attributes to entities

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

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

All relational tables satisfy the 1NF requirements.

Atomic attributes are attributes that can be further divided.