How will you design the index table

Assignment Help Computer Engineering

Reference no: EM1333276

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?

Reference no: EM1333276

Questions Cloud

How to make the changes permanent : Write down and execute two INSERT statements to insert rows into the ZIPCODE table for the following two cities of your choice. After your INSERT statements are successful, make the changes permanent.

Recruiting methods are used by your organization : What recruiting methods are used by your organization and What are the advantages and disadvantages of these employed methods?

Product placement in tv and the movies : How does product placement in TV and The Movies impacts consumer behavior.

Breakeven analysis applied to decision making proces : How could breakeven analysis be applied to the decision making process involved in introducing a new service?

How will you design the index table : In the ABOVE indexed file, how may the computer read all of the records from the disk logically sequentially based on the values of the record key in the ascending order.

Protect an organization from legal issues : Human Resources - Can job analysis procedures can protect an organization from legal issues?

Elucidate what payments will you receive : If you buy the stock and plan to hold it for 3 years, Elucidate what payments will you receive. What is the present value of those payments? Compare your answer to (b).

Prepare a written proposal outlining a specific product : Prepare a written proposal outlining a specific product or service idea you have for Triangle Solutions

Calculate the level of excess supply : Suppose demand and supply conditions in the competitive market for unskilled labor

User Account

All Pages