Assume we have the following information about a Universitydatabase:
- All tables are stored in packed form in blocks of length 4096bytes.
- Student has 10,000 tuples, each 200 bytes long. It is hashed onstuId, the primary key, and has a secondary non-clustered index onlastName, with three levels. There are 8000 values for lastName,2000 values for firstName, 25 values for major, and 150 values forcredit.
- Faculty has 800 tuples of length 100 bytes. It has an index onfacId, the primary key, with two levels. There is a secondarynon-clustered index on department, with one level. facName has 650values, department has 25 values, and rank has 4
OROR