Given a relation Criminal(id, name, crime) containing 1,000,…
Given a relation Criminal(id, name, crime) containing 1,000,000 records, where each data page of the relation holds 100 records. Assume that Criminal.id is a candidate key for this relation, with values lying in the range 0 to 999,999, and that Criminal is stored and sorted in Criminal.id order. a. For each of the following relational algebra queries: (i)
Read Details