2、连接准备：
（1）查看mysql服务状态是否开启
（2）查看虚拟机IP地址
（3）登录进入mysql
（4）创建用户deng5，创建数据库dengqinyi，对用户deng5赋予使用dengqinyi数据库的全部权限并刷新权限
（5）查看用户情况，deng5用户已存在
（6）从外部navicat for mysql软件测试是否可以用新建的deng5用户，连接成功
3、源代码示例：
use dengqinyi;create table v_student(student_id varchar(20) primary key,student_name varchar(20) not null,student_sex varchar(10),department_id varchar(20) not null,student_birthday date);create table v_teacher(teacher_id varchar(20) primary key,teacher_name varchar(20) not null,teacher_sex varchar(10),department_id varchar(20) not null,teacher_birthday date,teacher_workyear date);create table v_course(course_id varchar(20) primary key,course_name varchar(20) not null,course_credit float(2,1),course_hour int);create table v_textbook(textbook_id varchar(20) primary key,textbook_name varchar(20) not null,press varchar(50),unit_price float(4,1),publish_date date);create table v_textbook_selection(course_id varchar(20),textbook_id varchar(20),textbook_selection_number int,primary key (course_id,textbook_id),foreign key (course_id) references v_course(course_id),foreign key (textbook_id) references v_textbook(textbook_id));create table v_student_score(student_id varchar(20),course_id varchar(20),grade float(3,1) check(grade <= 100 and grade >= 0),primary key(student_id,course_id),foreign key (student_id) references v_student(student_id) on delete cascade,foreign key (course_id) references v_course(course_id));create table v_department(department_id varchar(20) primary key,department_name varchar(20) not null,department_administrator varchar(20),department_phone varchar(20));create table v_teacher_course_task(teacher_id varchar(20),course_id varchar(20),primary key(teacher_id,course_id),foreign key (teacher_id) references v_teacher(teacher_id),foreign key (course_id) references v_course(course_id));create table v_classroom(classroom_id varchar(20) primary key,classroom_location varchar(20) not null,classroom_capacity int);create table v_course_develop(course_id varchar(20),teacher_id varchar(20),classroom_id varchar(20),primary key(course_id,teacher_id,classroom_id),foreign key (course_id) references v_course(course_id),foreign key (teacher_id) references v_teacher(teacher_id),foreign key (classroom_id) references v_classroom(classroom_id));alter table v_studentadd constraint foreign key (department_id) references v_department(department_id);alter table v_teacheradd constraint foreign key (department_id) references v_department(department_id);
3、结果截图：（1）十张表的构建截图
： ①显示表结构：
②学生表
③教师表
④课程表
⑤教材选用表
⑥学生成绩表
⑦院系表
⑧教师课程任务表
⑨课程开设表
⑩课室表
(11)教材表