TeacherTnTname教师表 Tn教师编号Tname教师名字学生表 StudentSn学号Sname学生姓名Sage学生年龄Ssex学生性别课程表CourseCn课程编号Cname课程名称Tn 教师编号SC 成绩表 Sn学号Cn课程编号score成绩 写出sql建表语句 并给我一些测试数据

建表语句：

CREATE TABLE Teacher (
  Tn INT PRIMARY KEY,
  Tname VARCHAR(50)
);

CREATE TABLE Student (
  Sn INT PRIMARY KEY,
  Sname VARCHAR(50),
  Sage INT,
  Ssex VARCHAR(10)
);

CREATE TABLE Course (
  Cn INT PRIMARY KEY,
  Cname VARCHAR(50),
  Tn INT,
  FOREIGN KEY (Tn) REFERENCES Teacher(Tn)
);

CREATE TABLE SC (
  Sn INT,
  Cn INT,
  score INT,
  PRIMARY KEY (Sn, Cn),
  FOREIGN KEY (Sn) REFERENCES Student(Sn),
  FOREIGN KEY (Cn) REFERENCES Course(Cn)
);

测试数据：

INSERT INTO Teacher (Tn, Tname) VALUES
(1, 'Teacher A'),
(2, 'Teacher B'),
(3, 'Teacher C');

INSERT INTO Student (Sn, Sname, Sage, Ssex) VALUES
(1001, 'Student A', 18, 'Male'),
(1002, 'Student B', 19, 'Female'),
(1003, 'Student C', 20, 'Male');

INSERT INTO Course (Cn, Cname, Tn) VALUES
(1, 'Math', 1),
(2, 'Science', 2),
(3, 'English', 3);

INSERT INTO SC (Sn, Cn, score) VALUES
(1001, 1, 90),
(1001, 2, 85),
(1001, 3, 95),
(1002, 1, 75),
(1002, 2, 80),
(1002, 3, 85),
(1003, 1, 85),
(1003, 2, 90),
(1003, 3, 80);
``