CREATE TABLE country
(
    origin  INTEGER
            primary key,
    country TEXT
);
country
CREATE TABLE price
(
    ID    INTEGER
            primary key,
    price REAL
);
price
CREATE TABLE data
(
    ID           INTEGER
            primary key,
    mpg          REAL,
    cylinders    INTEGER,
    displacement REAL,
    horsepower   INTEGER,
    weight       INTEGER,
    acceleration REAL,
    model        INTEGER,
    car_name     TEXT,
    foreign key (ID) references price(ID)
);
data
CREATE TABLE production
(
    ID         INTEGER,
    model_year INTEGER,
    country    INTEGER,
    primary key (ID, model_year),
    foreign key (country) references country(origin),
    foreign key (ID) references data(ID),
    foreign key (ID) references price(ID)
);
production
original_column_name,column_name,column_description,data_format,value_description
ID,,the id of the car,integer,
model_year,model year,year when the car model was introduced in the market,integer,
country,,country id to which the car belongs,integer,"Japan --> Asia 
USA --> North America"
production
original_column_name,column_name,column_description,data_format,value_description
ID,,unique ID for each car ,integer,
price,,price of the car in USD,real,
price
original_column_name,column_name,column_description,data_format,value_description
ID,,unique ID for each car ,integer,
mpg,mileage per gallon,mileage of the car in miles per gallon,real,commonsense evidence: The car with higher mileage is more fuel-efficient. 
cylinders,number of cylinders,the number of cylinders present in the car,integer,
displacement,,engine displacement in cubic mm,real,"commonsense evidence: sweep volume = displacement / no_of cylinders
"
horsepower,horse power,horse power associated with the car,integer,"commonsense evidence: horse power is the metric used to indicate the power produced by a car's engine - the higher the number, the more power is sent to the wheels and, in theory, the faster it will go. "
weight,,weight of the car in lbs,integer,"commonsense evidence: A bigger, heavier vehicle provides better crash protection than a smaller"
acceleration,,acceleration of the car in miles per squared hour,real,
model,,the year when the car model was introduced in the market,integer,commonsense evidence: 0 --> 1970
car_name,car name,name of the car,text,
data
original_column_name,column_name,column_description,data_format,value_description
origin,,the unique identifier for the origin country,integer,
country,,the origin country of the car,text,
country