question

Information

answer

It is the result of revealing the meaning of raw facts

question

It is raw facts of interest to the end user

answer

End-user data

question

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

answer

Metadata

question

It exists when different versions of the same data appear in different places

answer

Data inconsistency

question

It is the response of the DBMS to a query

answer

query result set

question

Data warehouse contains historical data obtained from the

answer

operational databases

question

Data that exists in the format in which they were collected

answer

Unstructured Data

question

Defined as the condition in which all of the data in the database are consistent with the real-world events and conditions

answer

Data integrity

question

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

answer

Database system

question

End of Chapter One

answer

Next Chapter 2

question

A brief, precise, and unambiguous description of a policy, procedure or principle in an organization

answer

Business rule

question

Business rules are derived from a detailed description of an

answer

organization's operations

question

A noun in a business rule translates to an entity in the

answer

data model

question

A verb associating two nouns in a business rule translates to

answer

relationship in the data model

question

An entity represents

answer

a particular type of object in the real world.

question

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

answer

entity relationship (diagram)

question

An entity is

answer

anything about which data are to be collected and stored

question

An attribute

answer

is the equivalent of a field in a file system

question

A relationship

answer

is bi-directional ()

question

Constraints

answer

are important because they help to ensure data integrity

question

many-to-many

answer

Students and classes have a M:N relationship

question

End of Ch 2. Quiz

answer

Next Chapter 3

question

The logical view of the _____ database is facilitated by the creation of data relationships based on a logical construct

answer

relational

question

attribute domain

answer

In a relational table, each column has a specific range of values known as

question

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

answer

keys

question

dependent

answer

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

question

A candidate key

answer

can be described as a superkey without unnecessary attributes

question

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

answer

referential integrity

question

flags

answer

To avoid nulls, some designers use special codes, known as FLAGS, to indicate the absence of some value.

question

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

answer

closure

question

cartesian

answer

PRODUCT yields all possible pairs of rows from two tables—also known as the CARTESIAN product.

question

join

answer

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

question

equijoin

answer

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

question

outer join

answer

The OUTER joins are especially useful when you are trying to determine what value(s) in related tables cause(s) referential integrity problems

question

data dictionary

answer

A DATA DICTIONARY provides a detailed description of all tables found within the user/designer-created database

question

1:M

answer

The 1:M(one to many) relationship is the relational database norm

question

1:1

answer

If one department chair—a professor—can chair only one department and one department can have only one department chair, then the entities PROFESSOR and DEPARTMENT exhibit a(n) 1:1 relationship

question

M:N

answer

The M:N (many to many)relationships can be implemented by creating a new entity in 1:M relationships with the original entities.

question

foreign

answer

The proper use of FOREIGN keys is crucial to controlling data redundancy

question

index

answer

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

question

composite

answer

The index key can have multiple attributes, this is called a(n) COMPOSITE index

question

Guaranteed Access

answer

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

question

End of Ch 3

answer

Next Ch. 4

question

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

answer

conceptual

question

Successful database design is, first and foremost, based on ____ requirements.

answer

end-user

question

A derived attribute ____

answer

need not be physically stored within the database

question

Cardinality expresses ____ number of entity occurrences associated with one occurrence of the related entity

answer

the specific

question

A ____ attribute can be further subdivided to yield additional attributes

answer

composite

question

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

answer

existence

question

A ____ relationship exists when two entities are associated

answer

binary

question

The set of possible values for an attribute is a ____

answer

domain

question

What type of attribute cannot be created in a DBMS?

answer

multivalued

question

A relationship name should be a(n) ____

answer

verb

question

End of Ch. 4

answer

Next Ch. 6

question

From a structural point of view, 2NF is better than this_____

answer

1NF

question

It produces a lower normal form

answer

denormalization

question

It causes data redundancies of data on every row entry

answer

duplication

question

Any attribute whose value determines other values within a row

answer

determinant

question

A process to help reduce the likelihood of data anomalies

answer

normalization

question

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

answer

repeating group

question

Any attribute that is at least part of a key

answer

prime attribute

question

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

answer

dependency diagram

question

A dependency based on only a part of a composite primary key

answer

partial dependency

question

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

answer

granularity

question

True and false

answer

Start

question

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

answer

True

question

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

answer

True

question

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

answer

False

question

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

answer

True

question

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?

answer

True

question

Denormalization is a process for assigning attributes to entities

answer

False

question

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

answer

False

question

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

answer

False

question

All relational tables satisfy the 1NF requirements

answer

True

question

Atomic attributes are attributes that can be further divided

answer

False

CIS 3060 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards