1 what is meant by data independence explain your answer2

Assignment Help Database Management System

Reference no: EM13379657

#1. What is meant by data independence? Explain your answer.

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

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

#4. 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?

#5. 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?

When would you choose to implement distributed databases, rather than local databases? Would you go for this design if all your computers were localized in one building? What if they are spread out in your country?

What would you recommend when they are spread worldwide? When would you mirror databases and when would you use databases tailored for the local environment?

What would you use as a hash function? Would your choice of a hash function depend on the language from which the words are chosen? Why should such a file not be stored as a sequential file?

Reference no: EM13379657

Questions Cloud

The company is considering the acquisition of equipment : the company is considering the acquisition of equipment that would radically change its manufacturing process. the

Part a of this assignment requires an analysis of certain : part a of this assignment requires an analysis of certain aspects of brown ltdafter studying brown ltd answer the

Familiarize yourself with one of the industry publications : familiarize yourself with one of the industry publications that reports physical cash prices for natural gas. inside

Question 1requiredstudy the information provided below and : question 1requiredstudy the information provided below and answer the following questions1.1explain the changes that

1 what is meant by data independence explain your answer2 : 1. what is meant by data independence? explain your answer.2. identify two benefits of separating application software

1after reading nordin et al 2009 and williams et al 2002 : 1.after reading nordin et al. 2009 and williams et al. 2002 how does the complexity of an ecosystem influence the

Part i-its a small small worlddecember 5 1952 dawned clear : part i-its a small small worlddecember 5 1952 dawned clear and cold in london england. hnbsp e air was damp and

Firm a has 10000 in assets entirely financed with equity : firm a has 10000 in assets entirely financed with equity. firm b also has 10000 in assets but these assets are financed

Which one of the following factors would most likely cause : which one of the following factors would most likely cause an increase in consumption i.e. an increase in the amount of

User Account

All Pages