Normalization.

raw_orders repeats customer_name and city on every order. Prefer customers + orders with customer_id. Create the normalized tables and move data with INSERT…SELECT DISTINCT / INSERT…SELECT.

Small example:

CREATE TABLE customers (...);
CREATE TABLE orders (...);
INSERT INTO customers ... SELECT DISTINCT ...;
INSERT INTO orders ... SELECT ...;