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

Reviews

Write a Review

 

Computer Engineering Questions & Answers

  Resolving the ambiguities in the software

Describe what you must do in such a situation. You know that cost to your current employer will increase in case the ambiguities are not resolved. Though, you have also a responsibility of confidentiality to your previous employer.

  How can be secure mail infrastructure using identities

How can be secure mail infrastructure using identities.What may be a new approach to secure mail infrastructure?

  Microsoft windows 2000 has domains alpha, beta, and omega

Microsoft Windows 2000  has domains ALPHA, BETA, and OMEGA

  Write down a program that reads a social security number

Write down a program that reads a social security number written as contiguous digits (for instance, 509435456), uses the charAt method to obtain each character and then prints each digit on a separate line followed by a colon and the digit printe..

  Evaluating the wireless nics

Describe whether this is still true today, and state the factors which are moving wireless NICs into the more dominant role, if any.

  Explain how information systems can be used

Briefly describe the processes that are necessary for an organization to have a mass-customization capability. How does it relate to "micro marketing"? express the process known as General Electric Direct.

  Verilog system

Develop a verilog system which utilizes a block code for the error management. The system must accept a 15-word block of 8-bit data words one word at a time.

  Securing the personal data

Because of the information systems are capable of storing and compiling the large amount of the data, several people worry that, and their private data will end up in the wrong hands.

  Make numeric buttons for numbers input

create the Calculate button the Accept button.make numeric buttons for numbers input

  Create simple program to demonstrate using stream i/o

Most stream I/O uses sequential access processes, but it is possible to use stream I/O for random access. The RandomAccessFile class in java.io implements random access files.

  Determining the bandwidth

Suppose N ethernet stations, all trying to transmit at the same time, need N/2 slot time in order to sort out who transmit next. Supposing the average packet size is 5 slot times, express the available bandwidth as a function of N?

  Vulnerabilities in purchasing through debit card

Recognize any potential vulnerabilities in act of making a purchase through the debit card, and which area of the CIA triad they apply to.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd