image.png
    /
    创建学生表结构
    /
    | student | CREATE TABLE student (
    student_id varchar(20) DEFAULT NULL COMMENT ‘学生学号’,
    name varchar(10) DEFAULT NULL COMMENT ‘姓名’,
    gender enum(‘男’,’女’) DEFAULT NULL COMMENT ‘性别’,
    depname enum(‘计科系’,’法律系’) DEFAULT NULL COMMENT ‘系名’
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
    /
    插入学生信息
    /
    insert into student values(‘20200401’,’李小四’,’男’,’计科系’);
    insert into student values(‘20200402’,’张小兰’,’女’,’计科系’);
    insert into student values(‘20200403’,’王帅八’,’男’,’法律系’);
    insert into student values(‘20200404’,’李大四’,’男’,’法律系’);
    /
    输出学生表
    /
    image.png
    /
    创建院系表结构
    /
    | department | CREATE TABLE department (
    name enum(‘计科系’,’法律系’) DEFAULT NULL COMMENT ‘系名’,
    dean varchar(10) DEFAULT NULL COMMENT ‘系主任’
    /
    插入院系信息
    /
    insert into department values(‘计科系’,’张宝’);
    insert into department values(‘法律系’,’刘德’);
    image.png
    /
    创建学生分数表结构
    /
    | student_grade | CREATE TABLE student_grade (
    student_id varchar(10) DEFAULT NULL COMMENT ‘学生学号’,
    course enum(‘高等数学’,’大学英语’,’微机原理’,’线性代数’,’法律基础’) DEFAULT NULL COMMENT ‘科目’,
    grade decimal(10,2) DEFAULT NULL COMMENT’分数’
    /
    插入分数表信息
    /
    insert into student_grade values(‘20200401’,’高等数学’,89);
    insert into student_grade values(‘20200401’,’大学英语’,90);
    insert into student_grade values(‘20200401’,’微机原理’,99);
    insert into student_grade values(‘20200402’,’高等数学’,89);
    insert into student_grade values(‘20200402’,’大学英语’,90);
    insert into student_grade values(‘20200402’,’线性代数’,99);
    insert into student_grade values(‘20200403’,’高等数学’,89);
    insert into student_grade values(‘20200403’,’法律基础’,98);
    insert into student_grade values(‘20200404’,’大学英语’,90);
    insert into student_grade values(‘20200404’,’法律基础’,99);
    /
    输出分数表信息
    /
    image.png