/*
Navicat MySQL Data Transfer

Source Server         : 001
Source Server Version : 50555
Source Host           : localhost:3306
Source Database       : student_info

Target Server Type    : MYSQL
Target Server Version : 50555
File Encoding         : 65001

Date: 2022-09-16 11:08:18
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `course`
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
  `cno` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `cname` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `credit` int(11) DEFAULT NULL,
  `cpno` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`cno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of course
-- ----------------------------
INSERT INTO course VALUES ('1', '数据库', '4', '5');
INSERT INTO course VALUES ('2', '数学', '6', null);
INSERT INTO course VALUES ('3', '信息系统', '3', '1');
INSERT INTO course VALUES ('4', '操作系统', '4', '6');
INSERT INTO course VALUES ('5', '数据结构', '4', '7');
INSERT INTO course VALUES ('6', '数据处理', '3', null);
INSERT INTO course VALUES ('7', 'PASCAL语言', '4', '6');

-- ----------------------------
-- Table structure for `sc`
-- ----------------------------
DROP TABLE IF EXISTS `sc`;
CREATE TABLE `sc` (
  `sno` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cno` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `grade` int(4) DEFAULT NULL,
  PRIMARY KEY (`sno`,`cno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of sc
-- ----------------------------
INSERT INTO sc VALUES ('95001', '1', '92');
INSERT INTO sc VALUES ('95001', '2', '85');
INSERT INTO sc VALUES ('95001', '3', '88');
INSERT INTO sc VALUES ('95002', '2', '90');
INSERT INTO sc VALUES ('95002', '3', '80');
INSERT INTO sc VALUES ('95003', '2', '85');
INSERT INTO sc VALUES ('95004', '1', '58');
INSERT INTO sc VALUES ('95004', '2', '85');

-- ----------------------------
-- Table structure for `student`
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `sno` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `sname` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
  `ssex` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `sage` int(11) NOT NULL,
  `sdept` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO student VALUES ('95001', '李勇', '男', '20', 'CS');
INSERT INTO student VALUES ('95002', '刘晨', '女', '19', 'IS');
INSERT INTO student VALUES ('95003', '王敏', '女', '18', 'MA');
INSERT INTO student VALUES ('95004', '张立', '男', '19', 'IS');
INSERT INTO student VALUES ('95005', '刘云', '女', '18', 'CS');