CIS 3060 DBMS Ch 1,2,3,4,6

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) _______ relationship. ch 3

1:1

The _______ relationship is the relational database norm. ch 3

1:M

From a structural point of view, 2NF is better than this. ch 6

1NF

Successful database design is, first and foremost, based on ____ requirements. ch 4 A) designer B) programmer C) end-user D) business

End-user

The _______ is the real power behind the relational database, allowing the use of independent tables linked by common attributes. ch 3

JOIN

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

M:N

Business rules are derived from ____. ch 2 A) managers' recommendation B) a detailed description of an orgs operations C) standards and practices developed over the years D) governmental oversight organization standards

a detailed description of an orgs operations

A(n) ____ is the equivalent of a field in a file system. ch 2 A) constraint B) relationship C) entity D) attribute

attribute

In a relational table, each column has a specific range of values known as the _______ domain. ch 3

attribute

A ____ relationship exists when two entities are associated. ch 4 A) unary B) biary C) ternary D) weak

binary

A(n) _______ key can be described as a superkey without unnecessary attributes. ch 3

candidate

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

cartesian

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

closure

A ____ attribute can be further subdivided to yield additional attributes. ch 4 A) composite B) simple C) single-valued D) multivalued

composite

The index key can have multiple attributes, this is called a(n) _______ index. ch 3

composite

The Chen model is especially useful to illustrate the database from a(n) ____ perspective. ch 4 A) developmental B) conceptual C) actual D) specific

conceptual

____ are important because they help to ensure data integrity. ch 2 A) entities B) constraints C) relationships D) attributes

constraints

A(n) _______ provides a detailed description of all tables found within the user/designer-created database. ch 3

data dictionary

___ exists when different versions of the same data appear in different places. ch 1 A) data inconsistency B) poor data security C) structural dependence D) conceptual dependence

data inconsistency

___ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions. ch 1 A) data integrity B) data anomaly C) data ubiquity D) data quality

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. ch 1 A) query analysis B) transaction C) management systems D) database system

database system

It produces a lower normal form. ch 6

denormalization

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

dependency diagram

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. ch 3

dependent

Any attribute whose value determines other values within a row. ch 6

determinate

The set of possible values for an attribute is a ____. ch 4 A) domain B) range C) set D) key

domain

It causes data redundancies of data on every row entry. ch 6

duplication

A noun in a business rule translates to a(n) ____ in the data model. ch 2 A) entity B) constraint C) attribute D) relationship

entity

A(n) ____ is anything about which data are to be collected and stored. ch 2 A) constraint B) attribute C) relationship D) entity

entity

A(n) ____ represents a particular type of object in the real world. ch 2 A) entity B) attribute C) constraint D) relationship

entity

The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text. ch 2 A) object-oriented B) hierarchical C) entity relationship D) network

entity relationship

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

equijoin

If an entity can exist apart from one or more related entities, it is said to be ____-independent. ch 4 A) existence B) relationship C) business D) weak

existence

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

flags

The proper use of _______ keys is crucial to controlling data redundancy. ch 3

foreign

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

granularity

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. ch 3

guaranteed access

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

index

___ is the result of revealing the meaning of raw facts. ch 1 A) end user data B) an encoded sample C) an encrypted bit D) information

information

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

keys

Students and classes have a ____ relationship. ch 2 A) many-to-many B) many-to-one C) one-to-one D) one-to-many

many-to-many

___ provide a description of the data characteristics and the set of relationships that link the data found within the database. ch 1 A) queries B) end-user data C) metadata D) schemas

metadata

What type of attribute cannot be created in a DBMS? ch 4 A) derived B) multivalued C) simple D) composite

multivalued

A derived attribute ____. ch 4 A) must be store physically within a database B) need not be physically stored within the database C) has many values D) must be based one the value of three or more attributes

need not be physically stored within the database

A process to help reduce the likelihood of data anomalies. ch 6

normalization

Data warehouse contains historical data obtained from the ___. ch 1 A) operational databases B) desktop database C) enterprise database D) workgroup database

operational database

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

outer

A dependency based on only a part of a composite primary key. ch 6

partial dependency

Any attribute that is at least part of a key. ch 6

prime attribute

The response of the DBMS to a query is the ___. ch 1 A) ad hoc query B) ad has response C) query result set D) integrated view of the data

query result set

End-user data is ___. ch 1 A) knowledge about end users B) raw facts of interest to the end user C) information about a specified subject D) accurate, relevant and timely information

raw facts of interest to the end user

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

referential

The logical view of the relational database is facilitated by the creation of data relationships based on a logical construct known as a(n) _______. ch 3

relation

A verb associating two nouns in a business rule translates to a(n) ____ in the data model. ch 2 A) entity B) attribute C) constraint D) relationship

relationship

A(n) ____ is bidirectional. ch 2 A) attribute B) relationship C) constraint D) entity

relationship

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. ch 6

repeating group

Cardinality expresses ____ number of entity occurrences associated with one occurrence of the related entity. ch 4 A) an undetermined B) the specific C) pre- determined D) programmed

the specific

___ data exist in a format that does not lend itself to processing that yields information. ch 1 A) B) C) D)

unstructured

___ data exist in the format in which they were collected. ch 1 A) structured B) semistructured C) unstructured D) historical

unstructured

A relationship name should be a(n) ____. ch 4 A) verb B) noun C) adjective D) number

verb