Question

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

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

a. How have to data been stored on a disk to maximize effectiveness?

b. Is there a vacancy on flight 243?

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

d. How many times should a user be allowed to mistype a password before 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.

PART 2

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

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