-- 1. Таблица стран
CREATE TABLE Country (
    ID AUTOINCREMENT PRIMARY KEY,
    Name TEXT(100),
    Population LONG
);

-- 2. Таблица народов
CREATE TABLE Nation (
    ID AUTOINCREMENT PRIMARY KEY,
    Name TEXT(100),
    Language TEXT(50)
);

-- 3. Таблица связи "страны — народы"
CREATE TABLE CountryNation (
    CountryID LONG,
    NationID LONG,
    CONSTRAINT pk_CountryNation PRIMARY KEY (CountryID, NationID),
    CONSTRAINT fk_Country FOREIGN KEY (CountryID) REFERENCES Country(ID),
    CONSTRAINT fk_Nation FOREIGN KEY (NationID) REFERENCES Nation(ID)
);