This preview has intentionally blurred parts. Sign up to view the full document

View Full Document

Unformatted Document Excerpt

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. 1.7. Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 01.02 . 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 01.02 . 1.10. Give some additional views that may be needed by other user groups for the database shown in Figure 01.02 . 1.11. Cite some examples of integrity constraints that you think should hold on the database shown in Figure 01.02 . 2.1. 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. 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 support this architecture? 2.5. What is the difference between logical data independence and physical data independence? 2.6. What is the difference between procedural and nonprocedural DMLs? 2.7. Discuss the different types of user-friendly interfaces and the types of users who typically use each. 2.8. With what other computer system software does a DBMS interact? 2.9. Discuss some types of database utilities and tools and their functions. 2.10. Think of different users for the database of Figure 01.02 . What types of applications would each user need? To which user category would each belong, and what type of interface would each need? 2.11. Choose a database application with which you are familiar. Design a schema and show a sample database for that application, using the notation of Figure 02.01 and Figure 01.02 . 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. ... View Full Document

End of Preview

Sign up now to access the rest of the document