3nf table normalization

CREATE TABLE buyer(
    buyer_id VARCHAR(10) PRIMARY KEY,
    buyer_name VARCHAR(100) NOT NULL,
    buyer_phoneNumber VARCHAR(20) NOT NULL,
    buyer_email VARCHAR(20) NOT NULL
);

CREATE TABLE address(
    address_id INT(10) PRIMARY KEY,
    address_street TEXT NOT NULL,
    address_city TEXT NOT NULL,
    address_country VARCHAR(10) NOT NULL,
    address_zip_code VARCHAR(6) NOT NULL
);

CREATE TABLE buyer_address(
    buyer_id VARCHAR(10) NOT NULL,
    address_id INT(10) NOT NULL
);

CREATE TABLE product(
    product_id VARCHAR(10) PRIMARY KEY,
    product_name VARCHAR(100) NOT NULL,
    product_weight INT(10) NOT NULL,
    product_price DECIMAL(10,2) NOT NULL
);

CREATE TABLE orders(
    order_id VARCHAR(10) PRIMARY KEY,
    buyer_id VARCHAR(10) NOT NULL,
    order_date DATETIME NOT NULL,
    order_total DECIMAL(10,2) NOT NULL,
    address_id INT(10) NOT NULL
);

CREATE TABLE order_detail(
    order_id VARCHAR(10) NOT NULL,
    product_id VARCHAR(10) NOT NULL,
    qty INT(10) NOT NULL
);