Identify two benefits of separating application software from the database management system.

1. Identify two benefits of separating application software from the database management system.

2. Identify the level within a database system (user, programmer of application software, and designer of the DBMS software) at which each of the following concerns or activities occur:

a. How should data be stored on a disk to maximize efficiency?

b. Is there a vacancy on flight 243?

c. Could a relation be stored as a sequential file?

d. How many times should a user be allowed to mistype a password before the conversation is terminated?

e. How can the PROJECT operation be implemented?

3. Design a relational database containing information about music composers, their lives, and their compositions. (Avoid redundancies similar to those in Figure 9.4)

PART 2

1. Suppose a sequential file contains 50,000 records, and 5 milliseconds are required to interrogate an entry. How long should we expect to wait when retrieving a record from the middle of the file?

2. The chapter drew parallels between a traditional file index and the file directory system maintained by an operating system. In what ways does an operating system`s file directory differ from a traditional index?