A woman was shot dead in Sheffield in the early hours of Bank Holiday Monday.