Dense Index Files(Cont.) Dense index on dept name,with instructorfile sorted on dept name Biology 76766 Crick Biology 72000 Comp.Sci. 10101 Srinivasan Comp.Sci. 65000 Elec.Eng. 45565 Katz Comp.Sci. 75000 Finance 83821 Brandt Comp.Sci. 92000 History 98345 Kim Elec.Eng. 80000 Music 12121 Wu Finance 90000 Physics 76543 Singh Finance 80000 32343 El Said History 60000 58583 Califieri History 62000 15151 Mozart Music 40000 22222 Einstein Physics 95000 33465 Gold Physics 87000 Database System Concepts-7th Edition 14.7 @Silberschatz,Korth and SudarshanDatabase System Concepts - 7 14.7 ©Silberschatz, Korth and Sudarshan th Edition Dense Index Files (Cont.) ▪ Dense index on dept_name, with instructor file sorted on dept_name