Database system
- Define the following terms: data, database, DBMS, database system, data- base catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application.
1.2. What four 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.
1.7. Discuss the differences between database systems and information retrieval systems.
1.8 Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2.
1.9. What is the difference between controlled and uncontrolled redundancy? Illustrate with examples.
1.10. Specify all the relationships among the records of the database shown in
Figure 1.2.
1.11. Give some additional views that may be needed by other user groups for the database shown in Figure 1.2.
1.12. Cite some examples of integrity constraints that you think can apply to the database shown in Figure 1.2.
1.13. Give examples of systems in which it may make sense to use traditional file processing instead of a database approach
