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.
What three main types of actions involve databases? Briefly discuss each.
Discuss the main characteristics of the database approach and how it differs from traditional file
What are the responsibilities of the DBA and the database designers?
What are the different types of database end users? Discuss the main activities of each.
Discuss the capabilities that should be provided by a DBMS.
Identify some informal queries and update operations that you would expect to apply to the database
What is the difference between controlled and uncontrolled redundancy? Illustrate with examples.
Name all the relationships among the records of the database shown in
Give some additional views that may be needed by other user groups for the database shown in
Cite some examples of integrity constraints that you think should hold on the database shown in
Define the following terms: data model, database schema, database state, internal schema, conceptual
schema, external schema, data independence, DDL, DML, SDL, VDL, query language, host
language, data sublanguage, database utility, catalog, client-server architecture.
Discuss the main categories of data models.
What is the difference between a database schema and a database state?
Describe the three-schema architecture. Why do we need mappings between schema levels? How do
different schema definition languages support this architecture?
What is the difference between logical data independence and physical data independence?
What is the difference between procedural and nonprocedural DMLs?
Discuss the different types of user-friendly interfaces and the types of users who typically use each.
With what other computer system software does a DBMS interact?
Discuss some types of database utilities and tools and their functions.
Think of different users for the database of
. What types of applications would each user
need? To which user category would each belong, and what type of interface would each need?
Choose a database application with which you are familiar. Design a schema and show a sample
database for that application, using the notation of
. What types of
additional information and constraints would you like to represent in the schema? Think of several
users for your database, and design a view for each.