Database schema optimization

It is necessary to perform a refactoring of the current database schema: analyze its structure, identify weaknesses, and suggest improvement options.

User(id, name, sex, birthday)
Product(id, maker, model, type)
Order(user_id, product_id, date, count, code, price, total_sum)