CS6400-Exam question with answers 100%
pass
DBMS (Database Management System) - -is a computerized system that enables
users to create and maintain a database
-Meta Data - -The database definition or descriptive information is also stored by
the DBMS in the form of a database catalog or dictionary
-transaction - -an executing program or process that includes one or more
database accesses, such as reading or updating of database records
-requirements specification and analysis - -The first phase in the design of the new
application for an existing database or design of a brand-new database
-Conceptual Design - -Overview of the system, does not include hardware or
software choices
-Logical Design - -A stage in the design phase that matches the conceptual design
to the requirements of the selected DBMS and is therefore software-dependent. It is
used to translate the conceptual design into the internal model for a selected
database management system.
-Physical Design - -translates the logical design into physical components. The
database design is implemented, populated with actual data, and continuously
maintained to reflect the state of the miniworld.
-self-describing data - -includes the data item names and data values together in
one structure
-Data Modeling - -Defining a database so that it faithfully represents all key
components of an organization's environment. The objective is to explicitly capture
and store data about every business activity the organization wishes to plan,
control, or evaluate.
-operation - -(also called a function or method)
-The interface (or signature)
-The implementation
-program-operation independence - -User application programs can operate on the
data by invoking these operations through their names and arguments, regardless
of how the operations are implemented
-Data Abstraction - -allows program-data independence and program-operation
independence
-view - -subset of the database or it may contain virtual data that is derived from
the database files but is not explicitly stored.
, -Concurrency Control - -A method of dealing with a situation in which two or more
users or applications need to access the same record at the same time.
-OLTP (online transaction processing) - -Database design used for browsing and
manipulating business transaction activity
-Isolation - -ensures that each transaction appears to execute in isolation from
other transactions, even though hundreds of transactions may be executing
concurrently
-atomicity - -ensures that either all the database operations in a transaction are
executed or none are
-Database Administrator (DBA) - -the person responsible for coordinating,
controlling, and managing the database
-Database designers - -are responsible for identifying the data to be stored in the
database and for choosing appropriate structures to represent and store this data
-End users - -are the people whose jobs require access to the database for
querying, updating, and generating reports; the database primarily exists for their
use.
-Parametric End Users - -Their main job function revolves around constantly
querying and updating the database, using standard types of queries and updates
-Sophisticated end users - -include engineers, scientists, business analysts, and
others who thoroughly familiarize themselves with the facilities of the DBMS in
order to implement their own applications to meet their complex requirements.
-Standalone users - -maintain personal databases by using ready-made program
packages that provide easy-to-use menu-based or graphics-based interfaces. An
example is the user of a financial software package that stores a variety of personal
financial data.
-Casual end users - -occasionally access the database, but they may need different
information each time.
-System analysts - -determine the requirements of end users, especially naive and
parametric end users, and develop specifications for standard canned transactions
that meet these requirements.
-Application programmers - -implement these specifications as programs; then they
test, debug, document, and maintain these canned transactions.
-redundancy - -storing the same data multiple times
-data normalization - -database design that stores each logical data item—such as
a student's name or birth date—in only one place in the database.
pass
DBMS (Database Management System) - -is a computerized system that enables
users to create and maintain a database
-Meta Data - -The database definition or descriptive information is also stored by
the DBMS in the form of a database catalog or dictionary
-transaction - -an executing program or process that includes one or more
database accesses, such as reading or updating of database records
-requirements specification and analysis - -The first phase in the design of the new
application for an existing database or design of a brand-new database
-Conceptual Design - -Overview of the system, does not include hardware or
software choices
-Logical Design - -A stage in the design phase that matches the conceptual design
to the requirements of the selected DBMS and is therefore software-dependent. It is
used to translate the conceptual design into the internal model for a selected
database management system.
-Physical Design - -translates the logical design into physical components. The
database design is implemented, populated with actual data, and continuously
maintained to reflect the state of the miniworld.
-self-describing data - -includes the data item names and data values together in
one structure
-Data Modeling - -Defining a database so that it faithfully represents all key
components of an organization's environment. The objective is to explicitly capture
and store data about every business activity the organization wishes to plan,
control, or evaluate.
-operation - -(also called a function or method)
-The interface (or signature)
-The implementation
-program-operation independence - -User application programs can operate on the
data by invoking these operations through their names and arguments, regardless
of how the operations are implemented
-Data Abstraction - -allows program-data independence and program-operation
independence
-view - -subset of the database or it may contain virtual data that is derived from
the database files but is not explicitly stored.
, -Concurrency Control - -A method of dealing with a situation in which two or more
users or applications need to access the same record at the same time.
-OLTP (online transaction processing) - -Database design used for browsing and
manipulating business transaction activity
-Isolation - -ensures that each transaction appears to execute in isolation from
other transactions, even though hundreds of transactions may be executing
concurrently
-atomicity - -ensures that either all the database operations in a transaction are
executed or none are
-Database Administrator (DBA) - -the person responsible for coordinating,
controlling, and managing the database
-Database designers - -are responsible for identifying the data to be stored in the
database and for choosing appropriate structures to represent and store this data
-End users - -are the people whose jobs require access to the database for
querying, updating, and generating reports; the database primarily exists for their
use.
-Parametric End Users - -Their main job function revolves around constantly
querying and updating the database, using standard types of queries and updates
-Sophisticated end users - -include engineers, scientists, business analysts, and
others who thoroughly familiarize themselves with the facilities of the DBMS in
order to implement their own applications to meet their complex requirements.
-Standalone users - -maintain personal databases by using ready-made program
packages that provide easy-to-use menu-based or graphics-based interfaces. An
example is the user of a financial software package that stores a variety of personal
financial data.
-Casual end users - -occasionally access the database, but they may need different
information each time.
-System analysts - -determine the requirements of end users, especially naive and
parametric end users, and develop specifications for standard canned transactions
that meet these requirements.
-Application programmers - -implement these specifications as programs; then they
test, debug, document, and maintain these canned transactions.
-redundancy - -storing the same data multiple times
-data normalization - -database design that stores each logical data item—such as
a student's name or birth date—in only one place in the database.
