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
