Suppose you created a file for each relation in your answer to Problem and Exercise 9-45. If the following queries represented the complete set of accesses to this database, suggest and justify what primary and secondary key indexes you would build.

a. For each PART in Item_Number order list in Vendor_ID, sequence all the vendors and their associated prices for that part.

b. List all PART RECEIPTs, including related PART fields for all the parts received on a particular day.

c. For a particular VENDOR, list all the PARTs, and their associated prices, that VENDOR can supply.

Problem and Exercise 9-45

Transcribed Image Text:

VENDOR PRICE QUOTE PART K Quote_Quantity Price %23 Vendor ID Address Item Number Description Priced_at PART RECEIPT Order Number Date Order_Quantity