编辑代码

CREATE TABLE student (
  student_id INT,
  name VARCHAR(50),
  gender CHAR(1),
  birth_date DATE
);

CREATE TABLE teacher (
  teacher_id INT,
  name VARCHAR(50),
  gender CHAR(1),
  age INT
);

CREATE TABLE course_score (
  student_id INT,
  course_id INT,
  score FLOAT
)

CREATE TABLE course (
  course_id INT,
  teacher_id INT,
  course_name VARCHAR(100)
);