Database Reference
In-Depth Information
3. Unlike in a file-oriented environment, specialized software (DBMS) is
absolutely necessary in a database environment. Give any four reasons why
this is true.
4. What is multilevel data independence? How does DBMS provide this
independence?
5. What are the major hardware components that support a database
environment?
6. Describe any three functions of operating system software in a database
environment.
7. How can you classify the users in a database environment? List the
requirements of any two of the user groups.
8. “The database engine is the heart of the DBMS.” Is this so? Explain briefly.
9. List any four types of services provided by the data dictionary.
10. What are forms? What is the role of the forms generator in the DBMS?
EXERCISES
1. Indicate whether true or false:
A. People and procedures are part of a database environment.
B. DML contains features for defining data structures.
C. The external level schema defines files, records, blocks, and physical
locations.
D. In a database environment, large volumes of data pass through memory
buffers.
E. Tape storage devices are not useful for database backup.
F. CASE tools may be used for data modeling.
G. Sometimes the data dictionary is also used for storing the actual data.
H. The applications developer component in the DBMS is independent and
does not use the outputs from other components.
I. Fault-tolerant data storage generally keeps duplicate sets of data.
J. The database engine component is responsible for the speed of database
operations.
2. Manual and automated procedures are part of the overall database environ-
ment in an organization. Discuss the types of procedures needed by database
practitioners and end users.
3. What is transaction management in a database environment? Describe the
DBMS components that perform transaction management.
4. Discuss the role of operating system software in a database environment.
What functions must this software provide?
5. You are one of the power users in your company's database environment.
How would you plan to use the database and what services do you expect to
be provided for you?
Search WWH ::
Custom Search