CS6400-Exam1 Test Questions and Answers Graded A+
is a computerized system that enables users to create and
DBMS (Database Management System)
maintain a database
The database definition or descriptive information is also
Meta Data stored by the DBMS in the form of a database catalog or
dictionary
an executing program or process that includes one or
transaction more database accesses, such as reading or updating of
database records
The first phase in the design of the new application for an
requirements specification and analysis
existing database or design of a brand-new database
Overview of the system, does not include hardware or
Conceptual Design
software choices
A stage in the design phase that matches the conceptual
design to the requirements of the selected DBMS and is
Logical Design therefore software-dependent. It is used to translate the
conceptual design into the internal model for a selected
database management system.
translates the logical design into physical components.
The database design is implemented, populated with ac-
Physical Design
tual data, and continuously maintained to reflect the state
of the miniworld.
includes the data item names and data values together in
self-describing data
one structure
Defining a database so that it faithfully represents all key
components of an organization's environment. The ob-
Data Modeling jective is to explicitly capture and store data about every
business activity the organization wishes to plan, control,
or evaluate.
, CS6400-Exam1 Test Questions and Answers Graded A+
(also called a function or method)
operation -The interface (or signature)
-The implementation
User application programs can operate on the data by
program-operation independence invoking these operations through their names and argu-
ments, regardless of how the operations are implemented
allows program-data independence and program-opera-
Data Abstraction
tion independence
subset of the database or it may contain virtual data that is
view
derived from the database files but is not explicitly stored.
A method of dealing with a situation in which two or more
Concurrency Control users or applications need to access the same record at
the same time.
Database design used for browsing and manipulating
OLTP (online transaction processing)
business transaction activity
ensures that each transaction appears to execute in iso-
Isolation lation from other transactions, even though hundreds of
transactions may be executing concurrently
ensures that either all the database operations in a trans-
atomicity
action are executed or none are
the person responsible for coordinating, controlling, and
Database Administrator (DBA)
managing the database
are responsible for identifying the data to be stored in
Database designers the database and for choosing appropriate structures to
represent and store this data
are the people whose jobs require access to the database
End users for querying, updating, and generating reports; the data-
base primarily exists for their use.
Parametric End Users
is a computerized system that enables users to create and
DBMS (Database Management System)
maintain a database
The database definition or descriptive information is also
Meta Data stored by the DBMS in the form of a database catalog or
dictionary
an executing program or process that includes one or
transaction more database accesses, such as reading or updating of
database records
The first phase in the design of the new application for an
requirements specification and analysis
existing database or design of a brand-new database
Overview of the system, does not include hardware or
Conceptual Design
software choices
A stage in the design phase that matches the conceptual
design to the requirements of the selected DBMS and is
Logical Design therefore software-dependent. It is used to translate the
conceptual design into the internal model for a selected
database management system.
translates the logical design into physical components.
The database design is implemented, populated with ac-
Physical Design
tual data, and continuously maintained to reflect the state
of the miniworld.
includes the data item names and data values together in
self-describing data
one structure
Defining a database so that it faithfully represents all key
components of an organization's environment. The ob-
Data Modeling jective is to explicitly capture and store data about every
business activity the organization wishes to plan, control,
or evaluate.
, CS6400-Exam1 Test Questions and Answers Graded A+
(also called a function or method)
operation -The interface (or signature)
-The implementation
User application programs can operate on the data by
program-operation independence invoking these operations through their names and argu-
ments, regardless of how the operations are implemented
allows program-data independence and program-opera-
Data Abstraction
tion independence
subset of the database or it may contain virtual data that is
view
derived from the database files but is not explicitly stored.
A method of dealing with a situation in which two or more
Concurrency Control users or applications need to access the same record at
the same time.
Database design used for browsing and manipulating
OLTP (online transaction processing)
business transaction activity
ensures that each transaction appears to execute in iso-
Isolation lation from other transactions, even though hundreds of
transactions may be executing concurrently
ensures that either all the database operations in a trans-
atomicity
action are executed or none are
the person responsible for coordinating, controlling, and
Database Administrator (DBA)
managing the database
are responsible for identifying the data to be stored in
Database designers the database and for choosing appropriate structures to
represent and store this data
are the people whose jobs require access to the database
End users for querying, updating, and generating reports; the data-
base primarily exists for their use.
Parametric End Users
