Explore BrainMass

Explore BrainMass

    SQL Example Database Design

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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?

    © BrainMass Inc. brainmass.com October 10, 2019, 4:19 am ad1c9bdddf

    Solution Preview

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

    Solution Summary

    The expert examines SQL examples for database designs. Inventory data is analyzed.