Explore BrainMass

SQL Example Database Design

This content was STOLEN 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 25, 2018, 6: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.

See Also This Related BrainMass Solution

Designing a database

It is important to know the type of computer for running the database in order to ensure that the configurations of the computer are not too obsolete for the database to perform efficiently and properly. It is important for organizations to keep their hardware resources updated in order to maximize the usage of database management system. The knowledge of important features such as disk space available, processor speed etc. are prerequisites for installing database management systems. If the computers of an organization are to old, the database management system may not be installed in the organization and will not run properly or sometimes not at all. This information is good to remember as planning a particular database implementation.

I need a good description and explanation of any situation(s) where this type of situation hindered your project from successfully deploying and what needed to happen in order for the database to run at a proficient level?

View Full Posting Details