plz make sure there is no plagiarism

 

Q) We store records with the following structure: Ssn, lname, fname in a data file ordered on lname a. Assume each record is 50 bytes long and that the block size is 200 bytes. Assume an unspanned organization. How many blocks are needed for the data file if there are 10,000 records? b. If we want an index on lname because lots of queries search based on last name, what kind of index is needed? c. The record length for the index file will be 26 bytes, so the blocking factor for the index file is 7. Draw a picture of the index structure for this first set of 10 records. 978-22-3333 Cilip Peter 555-11-2134 Figworth Sam 895-33-1123 Johns Tom 333-33-3333 Lee Joseph 455-67-3455 Lee Ming 213-56-2222 Samson Pam 434-78-2134 Smith Mary 542-99-2301 Smith Sam 677-23-4444 Yang Beatice 453-55-1237 Zazzle Zelda