INF3703 STUDYS GUIDE ANSWERS AND QUESTIONS
SET A+
✔✔Which concurrent control problem occurs when a transaction calculates some
aggregate functions over a set of data while other transactions are updating the data -
✔✔Inconsistent retrievals
✔✔The ____ table space is used for transaction-recovery purposes - ✔✔rollback
segment
✔✔The fourth step in query formulation process is to_____ - ✔✔determine what
selection criteria are needed
✔✔____ must be set large enough to permit as many requests to be serviced from the
cache as possible - ✔✔The data cache
✔✔The DDBMS component found in each computer that requests data is known as
_____ - ✔✔the transaction processor
✔✔____ exists when the end user or programmer must specify both the fragment
names and their locations - ✔✔Location mapping transparency
✔✔The benefit of cloud infrastructure that makes it easy to increase the database
capacity and/or change the underlying data model is known as_______ - ✔✔scalable
architecture
✔✔From the data analyst's point of view, decision support system (DSS) data differ
from operational data in the following ways except for_____ - ✔✔query activity
(frequency and complexity)
✔✔Bill Inmon's approach to data warehouse development is often referred to as _____
- ✔✔a top-down approach
, ✔✔Analyzing massive amounts of data to uncover hidden trends, patterns and
relationships; and forming computer models to simulate the findings and using the
models to support business decision-making are performed by - ✔✔data mining
✔✔Which database connectivity allows any Windows application to access relational
data sources, using SQL via a standard application programming interface - ✔✔Open
database connectivity (ODBC)
✔✔What is considered in a database initial study regarding the organization's operating
environment and mission - ✔✔Company situation analysis
✔✔The second stage in the database design cycle is known as logical database design.
What is the aim logical database design stage?
What are the phase/activities of logical design stage? - ✔✔The aim of the logical design
stage is to map the conceptual module into a logical model which can be implemented
on a relational DBMS
The logical design stage consists of the following phases/activities:
1. Creating the logical data model.
2. Validating the logical data model using normalization.
3. Assigning and validating integrity constraints.
4. Merging logical models constructed for different parts for the database together.
5. Reviewing the logical data model with the user
✔✔Distinguish between the Systems Development Life Cycle(SDLC) and the Database
Life Cycle (DBLC) - ✔✔The SDLC traces the history (life cycle) of an information
system. The DBLC traces the history (life cycle) of a database system.
SDLC is composed of five (5) phases (i.e. planning, analysis, detailed system design,
implementation, and maintenance).
DBLC consists of (6)phases (i.e. database initial study, database design,
implementation and loading, testing and evaluation, operation, and maintenance and
evolution)
✔✔Briefly explain the main relationship between Information Systems and Database
Systems? Provide a practical example - ✔✔Information Systems deals with a variety of
issues such as data collection, storage and retrieval.
It also facilitates the transformation of data into information and the management of both
data and information.
SET A+
✔✔Which concurrent control problem occurs when a transaction calculates some
aggregate functions over a set of data while other transactions are updating the data -
✔✔Inconsistent retrievals
✔✔The ____ table space is used for transaction-recovery purposes - ✔✔rollback
segment
✔✔The fourth step in query formulation process is to_____ - ✔✔determine what
selection criteria are needed
✔✔____ must be set large enough to permit as many requests to be serviced from the
cache as possible - ✔✔The data cache
✔✔The DDBMS component found in each computer that requests data is known as
_____ - ✔✔the transaction processor
✔✔____ exists when the end user or programmer must specify both the fragment
names and their locations - ✔✔Location mapping transparency
✔✔The benefit of cloud infrastructure that makes it easy to increase the database
capacity and/or change the underlying data model is known as_______ - ✔✔scalable
architecture
✔✔From the data analyst's point of view, decision support system (DSS) data differ
from operational data in the following ways except for_____ - ✔✔query activity
(frequency and complexity)
✔✔Bill Inmon's approach to data warehouse development is often referred to as _____
- ✔✔a top-down approach
, ✔✔Analyzing massive amounts of data to uncover hidden trends, patterns and
relationships; and forming computer models to simulate the findings and using the
models to support business decision-making are performed by - ✔✔data mining
✔✔Which database connectivity allows any Windows application to access relational
data sources, using SQL via a standard application programming interface - ✔✔Open
database connectivity (ODBC)
✔✔What is considered in a database initial study regarding the organization's operating
environment and mission - ✔✔Company situation analysis
✔✔The second stage in the database design cycle is known as logical database design.
What is the aim logical database design stage?
What are the phase/activities of logical design stage? - ✔✔The aim of the logical design
stage is to map the conceptual module into a logical model which can be implemented
on a relational DBMS
The logical design stage consists of the following phases/activities:
1. Creating the logical data model.
2. Validating the logical data model using normalization.
3. Assigning and validating integrity constraints.
4. Merging logical models constructed for different parts for the database together.
5. Reviewing the logical data model with the user
✔✔Distinguish between the Systems Development Life Cycle(SDLC) and the Database
Life Cycle (DBLC) - ✔✔The SDLC traces the history (life cycle) of an information
system. The DBLC traces the history (life cycle) of a database system.
SDLC is composed of five (5) phases (i.e. planning, analysis, detailed system design,
implementation, and maintenance).
DBLC consists of (6)phases (i.e. database initial study, database design,
implementation and loading, testing and evaluation, operation, and maintenance and
evolution)
✔✔Briefly explain the main relationship between Information Systems and Database
Systems? Provide a practical example - ✔✔Information Systems deals with a variety of
issues such as data collection, storage and retrieval.
It also facilitates the transformation of data into information and the management of both
data and information.
