al_sham_only
2006-02-14 21:33:18 UTC
FILE: - 6,017 records
- 171 characters per record
DISK: - 154 cylinders
- 12 tracks per cylinder
- 8 sectors per track
- 512 bytes per sector
(a) Calculate the minimum number of TRACKS and CYLINDERS that will be required to
store the file. Assume that partial records cannot be stored in a sector.
Present one answer in the form of x Cylinders plus y Tracks (round up fractions of a track).
(b) Determine the physical disk address (cyl. #, trk. #, sector #) for
relative record # 1,852.
Assume that the file begins at cyl. # 11, trk # 0, sector # 1.
TIP: For both (a) & (b) above, your calculations and relative displacements should focus on sector capacities
rather than on raw characters.
Show all of your work.
[2]A large poison control center located in a major metropolitan area is in the process of computerizing its files on poisons and on the treatment of persons who have been exposed to poisons or have taken poisons internally. A file containing records on every known poison in the world is to be created. Each record will contain the name of the poison, 4 typical symptoms when ingested by the human body, antidotes, and treatment procedures.
The poison control center will use the file in the following way: As telephone calls are received at the center about a possible poisoning, the caller is asked to give either the name of the poison ingested (if known), or to describe the symptoms of the person who has taken, or has been exposed to, the poison. A search will then be made of the computer-based file to find out what action should be taken as a treatment.
(a)Is the type of processing method that is appropriate for the proposed system batch or real-time? Explain.
(b)What type of storage media should be used to store the file? Explain.
(c)As a data designer, describe the most efficient way to support the system requirements as specified above.
You may not assume that you are working with high-level database software.
Your solution should consider data structures, file organization methods, and file processing methods.
Identify all relevant keys.
(d)Describe how software would navigate through or manipulate the data file(s) on order to respond to a
typical telephone call.
(e)Would your solution be different if there were only 30 poisons in the system? Explain.