数据库.创建表

1）创建以上几张表，并给表中输入数据。

学生表1  T_STUDENT
create table T_student(
stuno varchar2(16) primary key,
stuname varchar2(16),
stusex varchar2(6),
stubir date
)
课程信息表2  T_COURSE
create table T_course(
courseno varchar2(16) primary key,
coursename varchar2(16),
teano varchar2(16),
foreign key(teano) references T_teacher(teano)
)


教师信息表 3 T_TEACHER
create table T_teacher(
teano varchar2(16) primary key,
teaname varchar2(16),
teatitle varchar2(16)
)
考试成绩表 4  T_SCORE
create table T_score(
stuno varchar2(16),
courseno varchar2(16),
type varchar2(16),
socre float,
primary key(stuno,courseno,type),
foreign key(courseno) references T_course(courseno)
)