A sandwich is a popular lunch item that is usually comprised of meat, cheese, vegetables, bread etc. Jacob's sibling and their friends commonly ate sandwiches when hanging out in the Great Hall. ...... ..... ..... ..... ....... ...... ...... ............................................................................................................................................................................................................

Database information: The database has 100,000 location records (AKA rows) Our O/S uses physical block sizes of 4096 bytes A location has the following fields and FIXED sizes in bytes . id (primary key): 4 bytes address: 256 bytes city: 50 bytes . county: 50 bytes state: 2 bytes zip: 5 bytes owner_info: 512 bytes Index 11 is based on id. Each index entry in 11 contains the id and a 4-byte pointer to the next block in the index (or a record's data block) Index 12 is based on state, address, and id. Each index entry in 12 contains state, address, id and a 4-byte pointer to the next block in the index (or a record's data block) Questions: A. How large is each record in bytes? (256+4+50+50+2+5+512)= 879 4096/879= 4.6 B. How many records are in each data block? C. How many total data blocks are there? D. How large is an index entry in Index 11? E. How many index entries per index block in Index 11? F. How many index entries are in the leaf level of Index 11? G. How many index blocks are in the leaf level of Index 11? H. How many levels are in Index 11? 1. How large is an index entry in Index 12? J. How many index entries per index block in Index 12? K. How many index entries are in the leaf level of Index 12