Question: Consider the following relational relation: Student 1 5 MARKS Reg _ No ICS / 1 2 0 3 9 0 4 - 2 0 2
Consider the following relational relation: Student MARKS RegNo ICS ICS ICS ICS BCM BCM BCM FEN FEN FEN a Assuming the ChainedOverflow, Random File organization method in which the hashing function Modulus is applied on to the Reg. No attribute and with each bucket storing up to a maximum of tuples, compute the buckets in which the above records would be hashed. Marks Assumptions: i We shall use alphabetical and numerical ordering; where A B etc, and the numerical values assume their respective values ie etc. ii To compute the bucket addresses, the values from the Reg. No field shall be summed up and the Modulus applied respectively. iii All nonnumeric and nontext characters take up values as follows: Symbols Assigned Value
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
