3. An indexed file for the inventory data on disk and its index table are as follows:
Disk Address Record Key Item Name Quantity Price
43 130 Pen 300 $4
20 12 Paper 200 $5
05 23 Disk 250 $6
10 43 Watch 100 $7
Record Key Disk Address
In the ABOVE indexed file, how can the computer read all of the records from the disk logically sequentially based on the values of the record key in the ascending order?
In the ABOVE indexed file, if one wants to randomly read individual records based on the price of the item, how would you design the index table?© BrainMass Inc. brainmass.com August 19, 2018, 12:57 pm ad1c9bdddf
Welcome to BrainMass.com!
Please rate 5/5 for my notes and ideas. I'm honored to assist you on your future academic endeavors as a Special Request. Your business is valuable to me! Thank you so much for using BrainMass! Let me know if you have any question related to this or any other topic.
Disk_Address Record_Key Item_Name Quantity Price
The expert examines SQL examples for database designs. Inventory data is analyzed.