Multitable Clustering File Organization (cont.) good for queries involving department instructor,and for queries involving one single department and its instructors bad for queries involving only department results in variable size records Can add pointer chains to link records of a particular relation Database System Concepts-7th Edition 13.15 @Silberschatz,Korth and SudarshanDatabase System Concepts - 7 13.15 ©Silberschatz, Korth and Sudarshan th Edition Multitable Clustering File Organization (cont.) ▪ good for queries involving department ⨝ instructor, and for queries involving one single department and its instructors ▪ bad for queries involving only department ▪ results in variable size records ▪ Can add pointer chains to link records of a particular relation