Database Management Midterm (Ch. 1 - 6) ||All correctly
answered.
Agile software development correct answers An approach to database and software development
that emphasizes "individuals and interactions over processes and tools, working software over
comprehensive documentation, customer collaboration over contract negotiation, and response to
change over following a plan."
Conceptual schema correct answers A detailed, technology-independent specification of the
overall structure of organizational data.
Constraint correct answers A rule that cannot be violated by database users.
Data correct answers Stored representations of objects and events that have meaning and
importance in the user's environment.
Data independence correct answers The separation of data descriptions from the application
programs that use the data.
Data model correct answers Graphical systems used to capture the nature and relationships
among data.
Data warehouse correct answers A subject-oriented, integrated, time-variant, nonupdateable
collection of data used in support of management decision-making processes.
Database correct answers An organized collection of logically related data.
Database application correct answers An application program (or set of related programs) that is
used to perform a series of database activities (create, read, update, and delete) on behalf of
database users.
Database management system (DBMS) correct answers A software system that is used to create,
maintain, and provide controlled access to user databases.
Enterprise data modeling correct answers The first step in database development,
in which the scope and general contents of organizational
databases are specified.
Entity correct answers A person, a place, an object, an event, or a concept in the user
environment about which the organization wishes to maintain data.
Information correct answers Data that have been processed in such a way as to increase the
knowledge of the person who uses the data.
, Logical schema correct answers The representation of a database for a particular data
management technology.
Metadata correct answers Data that describe the properties or characteristics of end-user data
and the context of those data.
Physical schema correct answers Specifications for how data from a logical schema are stored in
a computer's secondary memory by a database management system.
Project correct answers A planned undertaking of related activities to reach an objective that has
a beginning and an end.
Prototyping correct answers An iterative process of systems development in which requirements
are converted to a working system that is continually revised through close work between
analysts and users.
Relational database correct answers A database that represents data as a collection of tables in
which all data relationships are represented by common values in related tables.
Repository correct answers A centralized knowledge base of all data definitions, data
relationships, screen and report formats, and other system components.
Systems development life cycle (SDLC) correct answers The traditional methodology used to
develop, maintain, and replace information systems.
User view correct answers A logical description of some portion of the database that is required
by a user to perform some task.
Associative entity correct answers An entity type that associates the instances of one or more
entity types and contains attributes that are peculiar to the relationship between those entity
instances.
Attribute correct answers A property or characteristic of an entity or relationship type that is of
interest to the organization.
Binary relationship correct answers A relationship between the instances of two entity types.
Business rule correct answers A statement that defines or constrains some aspect of the business.
It is intended to assert business structure or to control or influence the behavior of the business.
Cardinality constraint correct answers A rule that specifies the number of
instances of one entity that can (or must) be associated with
each instance of another entity.
Composite attribute correct answers An attribute that has meaningful component parts
(attributes).
answered.
Agile software development correct answers An approach to database and software development
that emphasizes "individuals and interactions over processes and tools, working software over
comprehensive documentation, customer collaboration over contract negotiation, and response to
change over following a plan."
Conceptual schema correct answers A detailed, technology-independent specification of the
overall structure of organizational data.
Constraint correct answers A rule that cannot be violated by database users.
Data correct answers Stored representations of objects and events that have meaning and
importance in the user's environment.
Data independence correct answers The separation of data descriptions from the application
programs that use the data.
Data model correct answers Graphical systems used to capture the nature and relationships
among data.
Data warehouse correct answers A subject-oriented, integrated, time-variant, nonupdateable
collection of data used in support of management decision-making processes.
Database correct answers An organized collection of logically related data.
Database application correct answers An application program (or set of related programs) that is
used to perform a series of database activities (create, read, update, and delete) on behalf of
database users.
Database management system (DBMS) correct answers A software system that is used to create,
maintain, and provide controlled access to user databases.
Enterprise data modeling correct answers The first step in database development,
in which the scope and general contents of organizational
databases are specified.
Entity correct answers A person, a place, an object, an event, or a concept in the user
environment about which the organization wishes to maintain data.
Information correct answers Data that have been processed in such a way as to increase the
knowledge of the person who uses the data.
, Logical schema correct answers The representation of a database for a particular data
management technology.
Metadata correct answers Data that describe the properties or characteristics of end-user data
and the context of those data.
Physical schema correct answers Specifications for how data from a logical schema are stored in
a computer's secondary memory by a database management system.
Project correct answers A planned undertaking of related activities to reach an objective that has
a beginning and an end.
Prototyping correct answers An iterative process of systems development in which requirements
are converted to a working system that is continually revised through close work between
analysts and users.
Relational database correct answers A database that represents data as a collection of tables in
which all data relationships are represented by common values in related tables.
Repository correct answers A centralized knowledge base of all data definitions, data
relationships, screen and report formats, and other system components.
Systems development life cycle (SDLC) correct answers The traditional methodology used to
develop, maintain, and replace information systems.
User view correct answers A logical description of some portion of the database that is required
by a user to perform some task.
Associative entity correct answers An entity type that associates the instances of one or more
entity types and contains attributes that are peculiar to the relationship between those entity
instances.
Attribute correct answers A property or characteristic of an entity or relationship type that is of
interest to the organization.
Binary relationship correct answers A relationship between the instances of two entity types.
Business rule correct answers A statement that defines or constrains some aspect of the business.
It is intended to assert business structure or to control or influence the behavior of the business.
Cardinality constraint correct answers A rule that specifies the number of
instances of one entity that can (or must) be associated with
each instance of another entity.
Composite attribute correct answers An attribute that has meaningful component parts
(attributes).
