For each of the following file processing operations, indicate whether a sequential file, indexed random file, virtual storage access method, hashing,

For each of the following file processing operations, indicate whether a sequential file, indexed random file, virtual storage access method, hashing, or pointer structure would work best. You may choose as many as you wish for each step. Also, indicate which would perform the least optimally.

a. Retrieve a record from the file based on its primary key value.

b. Update a record in the file.

c. Read a complete file of records.

d. Find the next record in a file.

e. Insert a record into a file.

f. Delete a record from a file.

g. Scan a file for records with secondary keys.

Solutions

Expert Solution

Access Methods

a. indexed sequential or indexed random; least optimal: sequential

b. indexed random or hashing; least optimal: sequential

c. sequential; least optimal: indexed random

d. sequential or pointer; least optimal; indexed random

e. indexed random or hashing; least optimal: sequential

f. indexed random or hashing; least optimal: sequential

g. indexed random; least optimal: hashing

Junaid answered 7 months ago

Next > < Previous

Related Solutions

Which statement is NOT correct? The Virtual storage Access Method a. is used for very large files ..

Which statement is NOT correct? The Virtual storage Access Methoda. is used for very large files that need both direct access and batch processing.b. may use an overflow area for records.c. provides an exact physical address for each record.d. is appropriate for files that require few insertions or deletions.

In each of the following situations, indicate whether a fixed (F), sequential (S), or discovery (D)...

In each of the following situations, indicate whether a fixed (F), sequential (S), or discovery (D) attributes sampling plan is being used. The audit team has determined the tolerable rate of deviation to be 5%, the risk of overreliance to be 10%, and the expected population deviation rate to be zero. Based on the risk of overreliance, expected population deviation rate and tolerable rate of deviation, the audit team examined a sample of 50 items before determining if additional...

Why is a device such as a tape-drive a poor secondary storage device for Random/Direct access to a file?

For each of the following items, indicate whether a sequential, block, group, alphabetic, or mnemonic code would be most appropriate (you may list

For each of the following items, indicate whether a sequential, block, group, alphabetic, or mnemonic code would be most appropriate (you may list multiple methods; give an example and explain why each method is appropriate):a. state codesb. check numberc. chart of accountsd. inventory item numbere. -bin number (inventory warehouse location)f. sales order numberg. vendor codeh. invoice numberi. customer number

In each of the following situations, indicate whether Walters, CPA is using unrestricted random (UR), systematic...

In each of the following situations, indicate whether Walters, CPA is using unrestricted random (UR), systematic random (SR), haphazard (H), or block (B) selection.? A. Walters created a list of all sales invoices to verify that they were supported by the appropriate shipping documents. Invoice number 15 was selected first for examination, followed by the invoices numbered 30, 45, 60, 75, 90, and so on until 40 invoices had been selected. ?B. To test the occurrence assertion regarding sales invoices,...

for each of the following oxides, indicate whether it is ionic or molecular and whether it...

for each of the following oxides, indicate whether it is ionic or molecular and whether it is acidic or basic. Then write a balanced equation for the reaction with the oxide and water. SO2(g), CaO(s), Li2O(s), SeO(s), P4O6(s)

1. Indicate whether the following individuals are "Required" (based on income) or "Not required" to file...

1. Indicate whether the following individuals are "Required" (based on income) or "Not required" to file a tax return for 2020. Click here to access the standard deduction tables to use. Required / Not Required a. Patricia, age 19, is a self-employed single individual with gross income of $5,200 from an unincorporated business. Business expenses amounted to $4,900. Not required b. Mike is single and is 67 years old. His gross income from wages was $12,750. Not required c. Ronald...

Indicate whether the following represent IT input controls, processing controls, or output controls. •In the payroll...

Indicate whether the following represent IT input controls, processing controls, or output controls. •In the payroll system, work hours entered for a single employee for a week cannot exceed 70. •In the purchasing system, list of vendor checks printed is scanned by the controller before checks are mailed. •In a sales system, invoices would not be printed if total revenue doesn't match quantity times sales price. •In the purchasing system, vendor invoices cannot be entered if the vendor name doesn't...

Indicate whether each of the following statements is true or false. If false, indicate how to...

Indicate whether each of the following statements is true or false. If false, indicate how to correct the statement. a. The amount reported for accumulated other comprehensive income (AOCI) on the balance sheet must be a positive amount consistent with all other stockholders’ equity accounts. b. Changes in AOCI are reflected in other comprehensive income, which is different from net income. c. Other comprehensive income does not imply a change in cash.

8) For the following taxpayers indicate whether the taxpayer should file a tax return and why....

8) For the following taxpayers indicate whether the taxpayer should file a tax return and why. a. Robert earned $50,000 this year as a staff accountant. His estimated tax liability is $4,500, and he expects to receive a $500 tax refund. b. Amy earned $4,000 this year working part-time. She will have no federal tax liability and has not made any federal tax payments. c. Ty earned $2,500 this summer and had $200 of federal taxes withheld from his paycheck....

Subjects