Soper walks us through all things about database indexing.

$1.$ At the bottom of this assignment is a sample table in a database. Construct an index which uses part number. If you need a hint, see Soper about minute $21.$ Determine what you would put in the cell for each letter below, and then enter the answer to the corresponding question. $2.$ Now we are going to do a bitmap index. Use the same database table at the bottom of this assignment, and instead construct a bitmap index. Fill in the letters ABCDEF as would fulfill the requirements of a bitmap. $3.$ Stay with the same bitmap index you started in Question $2.$ Sum your bits into a checksum and put the checksum in HIJK.

You will have more data than shown here. But for example, if you only had $4$ records, the checksum for J would be $1,$ because the sum of the numbers in column J is $0+0+1+0=1.$