What is an index? Compare the concept of the index in a book to an index in an information system.

Using “The Prophet” (Kahlil Gibran) as a reference, create a short position paper on the topic of personal strategy.
August 5, 2017
What is the significance and nature of Cain and Abel’s gifts? i.e., what was the basis of their acceptance or rejection?
August 5, 2017
Show all

What is an index? Compare the concept of the index in a book to an index in an information system.

Assignment 1-due 8/8

  1. Describe the following disk concepts or components.
  2. Platter and recording surface.
  3. Track.
  4. Cylinder.
  5. Read/write head.
  6. Access-arm mechanism.
  7. Describe the four steps in the transfer of data from

disk to primary memory.

  1. What is an index? Compare the concept of the index

in a book to an index in an information system.

  1. What is an indexed-sequential file?
  2. Describe how a direct search works using a B+-tree

index.

  1. Answer the following general questions about

indexes:

  1. Can an index be built over a non-unique field?
  2. Can an index be built over a field if the file is not

stored in sequence by that field?

  1. Can an index be built over a combination of fields

as well as over a single field?

  1. Is there a limit to the number of indexes that can

be built for a file?

  1. How is an index affected when a change is made

to a file? Does every change to a file affect every

one of its indexes?

  1. Can an index be used to achieve sequential

access? Explain

  1. Describe how a direct search works in a hashed file

using the division-remainder method of hashing.

  1. What is physical database design?
  2. Describe why physical database design is necessary.

Leave a Reply

Your email address will not be published. Required fields are marked *