2023.1.30作业
drop database if exists ccc;
create database ccc default character set utf8mb4;
use ccc;
create table tbl_academy
(
aca_num int not null,
aca_name varchar(15) not null,
aca_intro varchar(100) not null,
primary key (aca_num)
)engine innodb comment'学院表';
create table tbl_teacher
(
stuff_num int not null,
tea_name varchar(10) not null,
tea_gender varchar(1) not null,
tea_birthday date not null,
tea_position varchar(10) not null,
primary key(stuff_num)
)engine innodb comment'教师表';
create table tbl_student
(
stu_num int not null,
stu_name varchar(10) not null,
stu_gender varchar(1) not null,
stu_birthday date not null,
native_place varchar(5),
primary key(stu_num)
)engine innodb comment'学生表';
create table tbl_course
(
course_num int not null,
course_name varchar(20) not null,
course_score int not null,
course_term int not null,
primary key(course_num)
)engine innodb comment'课程表'