創建一個名為course的數據庫 在該數據庫下創建以下幾個表： Students表：sid整型自增主鍵，sname字符串64位，gender字符串12位，dept_id整型并外鍵到dept表的id字段 Dept表：id整型自增主鍵，dept_name字符串64位 Course表：id整型自增字段主鍵，course_name字符串64位，teacher_id整型外鍵到teacher表的id字段 Teacher表：id整型自增字段主鍵，name字符串64位，dept_id整型外鍵到dept表的id字段 創建選課成績表score(sid,course_id,score) **Students表和teacher表的dept_id為非空** ~~~ create database course; use course; create table dept( id int auto_increment primary key, dept_name varchar(64) ); create table students( sid int auto_increment primary key, sname varchar(64), gender varchar(12), dept_id int not null , constraint for_1 foreign key(dept_id) references dept(id) ); create table teacher (id int auto_increment primary key, name varchar(64), dept_id int not null, constraint for_3 foreign key(dept_id) references dept(id) ); create table course ( id int auto_increment primary key, course_name varchar(64), teacher_id int, constraint for_2 foreign key(teacher_id) references teacher(id) ); create table score(sid int,course_id int,score int); ~~~