Termination of rotational bands: disappearance of quantum many-body collectivity