12.试题编号：2-12 《学生管理系统》选课管理模块

说起这个技能抽查，真的是一个令人头疼的事，搞的不好影响毕业，看起来简单，实则处处暗藏玄机，今天我们来看看一道技能抽查中的数据库题目

 

 

 

 

 以上便是所有的题目，接下来我们来看一下，解答过程，

1.创建数据库 StudentDB。
create database StudentDB;

2.根据图 2.12.2 和表 2.12.1，创建数据表 T_student、T_course、T_score。

创建数据表 T_student
___ __  ___  ______ __  ___  ______ __  ___  ______ __  ___  ______ __  ___  ______ __  ___  ______ __  ___  ___
DROP TABLE IF EXISTS `t_student`;
CREATE TABLE `t_student`  (
  `Stud_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `Stud_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Stud_sex` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Birth_date` datetime(0) DEFAULT NULL,
  `Entry_Date` datetime(0) DEFAULT NULL,
  `Mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Birth_place` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Reserve` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`Stud_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

创建数据表T_course
___ __  ___  ______ __  ___  ______ __  ___  ______ __  ___  ______ __  ___  ______ __  ___  ______ __  ___  ___

DROP TABLE IF EXISTS `t_course`;
CREATE TABLE `t_course`  (
  `Course_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `Course_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Teacher_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`Course_id`) USING BTREE,
  INDEX `Course_name`(`Course_name`) USING BTREE,
  INDEX `Course_name_2`(`Course_name`, `Course_id`) USING BTREE,
  INDEX `Course_id`(`Course_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------

创建数据