2nf order

CREATE TABLE 2nf_order(
    order_id VARCHAR(10) NOT NULL,
    product_id VARCHAR(10) NOT NULL,
    qty INT(10) NOT NULL,
    order_date DATETIME NOT NULL,
    order_total DECIMAL(10,2) NOT NULL
);

CREATE TABLE 2nf_buyer(
    buyer_id VARCHAR(10) PRIMARY KEY,
    buyer_name VARCHAR(100) NOT NULL,
    buyer_address_street TEXT NOT NULL,
    buyer_address_city TEXT NOT NULL,
    buyer_address_zip_code TEXT NOT NULL,
    buyer_address_country TEXT NOT NULL
);

CREATE TABLE 2nf_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
);