Database Revision Questions for Computer Science and Technology

In: Computers and Technology

Submitted By lokangjohnbosco
Words 803
Pages 4
Review Questions
24 I Chapter 1 Databases and Database Users
1.1. Define the following terms: data, database, DBMS, database system, database catalog, Program-data independence, user view, DBA, end user, canned transaction, deductive Database system, persistent object, meta-data, transaction-processing application.
1.2. What three main types of actions involve databases! Briefly discuss each.

1.3. Discuss the main characteristics of the database approach and how it differs from
traditional file systems.
1.4. What are the responsibilities of the DBA and the database designers?
1.5. What are the different types of database end users? Discuss the main activities of each.
1.6. Discuss the capabilities that should be provided by a DBMS.
Exercises
1.7. Identify some informal queries and update operations that you would expect to
apply to the database shown in Figure 1.2.
1.8. What is the difference between controlled and uncontrolled redundancy? Illustrate with examples.
1.9. Name all the relationships among the records of the database shown in Figure 1.2.
1.10. Give some additional views that may be needed by other user groups for the database
Shown in Figure 1.2.
1.11. Cite some examples of integrity constraints that you think should hold on the
Database shown in Figure 1.2.

Chapter 2 Database System Concepts and Architecture
Review Questions
2.1. Define the following terms: data model, database schema, database state, internal
Schema, conceptual schema, external schema, data independence, DOL, OML, SOL,
VOL, query language, host language, data sublanguage, database utility, catalog, client/server architecture.
2.2. Discuss the main categories of data models.
2.3. What is the difference between a database schema and a database state?
2.4. Describe the three-schema architecture. Why do we need mappings between?
Schema levels? How do different schema definition languages…...