Frank Lampard has been confirmed as the new manager of Championship side Coventry City. The 46-year-old has signed a two-and-a-half year contract with the Sky Blues.