Use Access or SQL to index the following fields:

profilesereagla
  • Save a copy of the TAL Distributors database located within the Shared Files of the course. You will use this copy to create indexed fields in your database.
  • The current TAL Distributors database only has a few customers; however, in reality, such a database would likely have records for thousands or hundreds of thousands of customers and their order information. Describe how indexing fields could be beneficial to this database.
    • Which field(s) would gain the most benefit from being indexed without creating unnecessary tables that require additional storage space? Justify your answers.
  • Use Access or SQL to index the following fields:
    • In the Customer table, create an index for the CustomerNum field and the CustomerName field. CustomerNum should not allow duplicates; the CustomerName should also not allow duplicates.
    • In the Item Table, create an index for the Storehouse field that does allow duplicates.
    • In the Orders table, create an index for the OrderDate field that allows duplicates. Also create a multiple-field index using the OrderNum and CustomerNum fields. This index may also include duplicate values.
    • 7 years ago
    • 3
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      gebtp.rar
    Bids(1)