SQL Example Database Design
Not what you're looking for?
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?
Purchase this Solution
Solution Summary
The expert examines SQL examples for database designs. Inventory data is analyzed.
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 ...
Purchase this Solution
Free BrainMass Quizzes
Javscript Basics
Quiz on basics of javascript programming language.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Basic Networking Questions
This quiz consists of some basic networking questions.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.