{"course": {"columns": [[0, "Course_ID", "INT", 0, null, 1], [1, "Staring_Date", "TEXT", 0, null, 0], [2, "Course", "TEXT", 0, null, 0]], "primary_keys": ["Course_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Course_ID"]]], "check_constraints": []}, "teacher": {"columns": [[0, "Teacher_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Age", "TEXT", 0, null, 0], [3, "Hometown", "TEXT", 0, null, 0]], "primary_keys": ["Teacher_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Teacher_ID"]]], "check_constraints": []}, "course_arrange": {"columns": [[0, "Course_ID", "INT", 0, null, 1], [1, "Teacher_ID", "INT", 0, null, 2], [2, "Grade", "INT", 0, null, 3]], "primary_keys": ["Course_ID", "Teacher_ID", "Grade"], "foreign_keys": [[0, 0, "teacher", "Teacher_ID", "Teacher_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "course", "Course_ID", "Course_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Course_ID"], [1, 1, "Teacher_ID"], [2, 2, "Grade"]]], "check_constraints": []}}
CREATE TABLE course (
    Course_ID INT   PRIMARY KEY,
    Staring_Date TEXT,
    Course TEXT,
    UNIQUE (Course_ID)
);

CREATE TABLE teacher (
    Teacher_ID INT   PRIMARY KEY,
    Name TEXT,
    Age TEXT,
    Hometown TEXT,
    UNIQUE (Teacher_ID)
);

CREATE TABLE course_arrange (
    Course_ID INT   PRIMARY KEY,
    Teacher_ID INT   PRIMARY KEY,
    Grade INT   PRIMARY KEY,
    PRIMARY KEY (Course_ID, Teacher_ID, Grade),
    UNIQUE (Course_ID, Teacher_ID, Grade),
    FOREIGN KEY (Teacher_ID) REFERENCES teacher(Teacher_ID),
    FOREIGN KEY (Course_ID) REFERENCES course(Course_ID)
);