Test Bank For Essentials of Database Management 1st Edition
By Jeffrey A. Hoffer; Heikki Topi; Ramesh Venkataraman
9780133405682 Chapter 1-9 Complete Guide .
_______ is the result of revealing the meaning of raw facts. - ANSWER: information
End-user data is_____? - ANSWER: 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. - ANSWER: metadata
__ __ exists when different versions of the same data appear in different places. - ANSWER: data
inconsistency
The response of the DBMS to a query is the . - ANSWER: query result set
Data warehouse contains historical data obtained from the . - ANSWER: operational database
data exist in the format in which they were collected. - ANSWER: unstructured data
___ data exist in a format that does not lend itself to processing that yields information. - ANSWER:
unstructured
______ is 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
The term 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
Business rules are derived from ____. - ANSWER: a detailed description of an organization's
operations
A noun in a business rule translates to a(n) ____ in the data model. - ANSWER: entity
A verb associating two nouns in a business rule translates to a(n) ____ in the data model. - ANSWER:
relationship
A(n) ____ represents a particular type of object in the real world. - ANSWER: entity
The ____ model was developed to allow designers to use a graphical tool to examine structures
rather than describing them with text. - ANSWER: entity relationship
A(n) ____ is anything about which data are to be collected and stored. - ANSWER: entity
A(n) ____ is the equivalent of a field in a file system. - ANSWER: attribute
A(n) ____ is bidirectional. - ANSWER: relationship
____ are important because they help to ensure data integrity. - ANSWER: constraints
Students and classes have a ____ relationship. - ANSWER: many-to many
The logical view of the relational database is facilitated by the creation of data relationships based on
a logical construct known as a(n) _______. - ANSWER: relation
By Jeffrey A. Hoffer; Heikki Topi; Ramesh Venkataraman
9780133405682 Chapter 1-9 Complete Guide .
_______ is the result of revealing the meaning of raw facts. - ANSWER: information
End-user data is_____? - ANSWER: 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. - ANSWER: metadata
__ __ exists when different versions of the same data appear in different places. - ANSWER: data
inconsistency
The response of the DBMS to a query is the . - ANSWER: query result set
Data warehouse contains historical data obtained from the . - ANSWER: operational database
data exist in the format in which they were collected. - ANSWER: unstructured data
___ data exist in a format that does not lend itself to processing that yields information. - ANSWER:
unstructured
______ is 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
The term 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
Business rules are derived from ____. - ANSWER: a detailed description of an organization's
operations
A noun in a business rule translates to a(n) ____ in the data model. - ANSWER: entity
A verb associating two nouns in a business rule translates to a(n) ____ in the data model. - ANSWER:
relationship
A(n) ____ represents a particular type of object in the real world. - ANSWER: entity
The ____ model was developed to allow designers to use a graphical tool to examine structures
rather than describing them with text. - ANSWER: entity relationship
A(n) ____ is anything about which data are to be collected and stored. - ANSWER: entity
A(n) ____ is the equivalent of a field in a file system. - ANSWER: attribute
A(n) ____ is bidirectional. - ANSWER: relationship
____ are important because they help to ensure data integrity. - ANSWER: constraints
Students and classes have a ____ relationship. - ANSWER: many-to many
The logical view of the relational database is facilitated by the creation of data relationships based on
a logical construct known as a(n) _______. - ANSWER: relation
