Explore BrainMass

SQL Example Database Design

3. An indexed file for the inventory data on disk and its index table are as follows:

Disk file
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

Index Table
Record Key Disk Address
20 14
130 43
43 10
14 29

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?

Solution Preview

Welcome to!
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 file
Disk_Address Record_Key Item_Name Quantity Price
43 ...