Reference no: EM1371205
Explain the answer, using references/sources cited appropriately.
1. What is meant by data independence? Explain your answer, paying attention to how data independence is implemented.
2. Identify two benefits of separating application software from the database management system. Provide an example when describing the benefits.
3. Design a relational database containing information about film directors, their basic biographical data, and their films. (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. Explain one advantage (with an example) that
a. a sequential file has over an indexed file
b. a sequential file has over a hash file
c. an indexed file has over a sequential file
d. an indexed file has over a hash file
e. a hash file has over a sequential file
f. a hash file has over an indexed file