Frank Lampard has been appointed as the new head coach of Coventry City