{"department": {"columns": [[0, "Department_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Creation", "TEXT", 0, null, 0], [3, "Ranking", "INT", 0, null, 0], [4, "Budget_in_Billions", "REAL", 0, null, 0], [5, "Num_Employees", "REAL", 0, null, 0]], "primary_keys": ["Department_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Department_ID"]]], "check_constraints": []}, "head": {"columns": [[0, "head_ID", "INT", 0, null, 1], [1, "name", "TEXT", 0, null, 0], [2, "born_state", "TEXT", 0, null, 0], [3, "age", "REAL", 0, null, 0]], "primary_keys": ["head_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "head_ID"]]], "check_constraints": []}, "management": {"columns": [[0, "department_ID", "INT", 0, null, 1], [1, "head_ID", "INT", 0, null, 2], [2, "temporary_acting", "TEXT", 0, null, 0]], "primary_keys": ["department_ID", "head_ID"], "foreign_keys": [[0, 0, "head", "head_ID", "head_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "department", "department_ID", "Department_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "department_ID"], [1, 1, "head_ID"]]], "check_constraints": []}}
CREATE TABLE department (
    Department_ID INT   PRIMARY KEY,
    Name TEXT,
    Creation TEXT,
    Ranking INT,
    Budget_in_Billions REAL,
    Num_Employees REAL,
    UNIQUE (Department_ID)
);

CREATE TABLE head (
    head_ID INT   PRIMARY KEY,
    name TEXT,
    born_state TEXT,
    age REAL,
    UNIQUE (head_ID)
);

CREATE TABLE management (
    department_ID INT   PRIMARY KEY,
    head_ID INT   PRIMARY KEY,
    temporary_acting TEXT,
    PRIMARY KEY (department_ID, head_ID),
    UNIQUE (department_ID, head_ID),
    FOREIGN KEY (head_ID) REFERENCES head(head_ID),
    FOREIGN KEY (department_ID) REFERENCES department(Department_ID)
);