CS6400-Exam1 Questions with Correct Answers New Version (Fully Solved)
DBMS (Database Management System) - Answers is a computerized system that enables users to create
and maintain a database
Meta Data - Answers The database definition or descriptive information is also stored by the DBMS in
the form of a database catalog or dictionary
transaction - Answers an executing program or process that includes one or more database accesses,
such as reading or updating of database records
requirements specification and analysis - Answers The first phase in the design of the new application
for an existing database or design of a brand-new database
Conceptual Design - Answers Overview of the system, does not include hardware or software choices
Logical Design - Answers 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 - Answers 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 - Answers includes the data item names and data values together in one structure
Data Modeling - Answers 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 - Answers (also called a function or method)
-The interface (or signature)
-The implementation
program-operation independence - Answers 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 - Answers allows program-data independence and program-operation independence
view - Answers subset of the database or it may contain virtual data that is derived from the database
files but is not explicitly stored.
Concurrency Control - Answers 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) - Answers Database design used for browsing and manipulating
business transaction activity
Isolation - Answers ensures that each transaction appears to execute in isolation from other
transactions, even though hundreds of transactions may be executing concurrently
atomicity - Answers ensures that either all the database operations in a transaction are executed or
none are
Database Administrator (DBA) - Answers the person responsible for coordinating, controlling, and
managing the database
Database designers - Answers 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 - Answers 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 - Answers Their main job function revolves around constantly querying and
updating the database, using standard types of queries and updates
Sophisticated end users - Answers 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 - Answers 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 - Answers occasionally access the database, but they may need different information
each time.
System analysts - Answers 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 - Answers implement these specifications as programs; then they test, debug,
document, and maintain these canned transactions.
redundancy - Answers storing the same data multiple times
data normalization - Answers database design that stores each logical data item—such as a student's
name or birth date—in only one place in the database.
Controlled Redundancy - Answers maintains replicas or exact copies.
Denormalization - Answers The process of transforming normalized relations into non-normalized
physical record specifications
DBMS (Database Management System) - Answers is a computerized system that enables users to create
and maintain a database
Meta Data - Answers The database definition or descriptive information is also stored by the DBMS in
the form of a database catalog or dictionary
transaction - Answers an executing program or process that includes one or more database accesses,
such as reading or updating of database records
requirements specification and analysis - Answers The first phase in the design of the new application
for an existing database or design of a brand-new database
Conceptual Design - Answers Overview of the system, does not include hardware or software choices
Logical Design - Answers 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 - Answers 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 - Answers includes the data item names and data values together in one structure
Data Modeling - Answers 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 - Answers (also called a function or method)
-The interface (or signature)
-The implementation
program-operation independence - Answers 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 - Answers allows program-data independence and program-operation independence
view - Answers subset of the database or it may contain virtual data that is derived from the database
files but is not explicitly stored.
Concurrency Control - Answers 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) - Answers Database design used for browsing and manipulating
business transaction activity
Isolation - Answers ensures that each transaction appears to execute in isolation from other
transactions, even though hundreds of transactions may be executing concurrently
atomicity - Answers ensures that either all the database operations in a transaction are executed or
none are
Database Administrator (DBA) - Answers the person responsible for coordinating, controlling, and
managing the database
Database designers - Answers 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 - Answers 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 - Answers Their main job function revolves around constantly querying and
updating the database, using standard types of queries and updates
Sophisticated end users - Answers 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 - Answers 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 - Answers occasionally access the database, but they may need different information
each time.
System analysts - Answers 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 - Answers implement these specifications as programs; then they test, debug,
document, and maintain these canned transactions.
redundancy - Answers storing the same data multiple times
data normalization - Answers database design that stores each logical data item—such as a student's
name or birth date—in only one place in the database.
Controlled Redundancy - Answers maintains replicas or exact copies.
Denormalization - Answers The process of transforming normalized relations into non-normalized
physical record specifications
