Question: This question is related to Database Management please,don't answer with handwriting . Thank Year 2020, You are hired as a database developer in a new

This question is related to Database Management

please,don't answer with handwriting .

Thank

This question is related to Database Management please,don't answer with handwriting .

Year 2020, You are hired as a database developer in a new established university. Yoiu are required to computerize the existing students information system. The details are as follows: . Currently enrolled students "r" : 25,000 . Block size "B" of disk to store data is 512 bytes. .Record pointer "P" size is 7 bytes . Each record is of fixed length with following attributes. Attributes Size (in bvtes 30 30 ex 10 Phone Address 30 Your task is to a) Calculate number of file blocks "b" to store data of all the students. b) Calculate umber of index blocks bi , if the file is ordered by StudentId and a primary index is constructed on same field. c) show how binary search algorithm with primary indexing would be a better choice than binary search algorithm without primary indexing, (by compare the average cost in terms of block accesses) [ Note: You may need to calculate some intermediate values to get final results ]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!