Pergunta de entrevista da empresa Kubikware

How would you fix this DB scheme, and how would you optimize it