P22
(1)创建院部管理数据库(departdb)
CREATE DATABASE IF NOT EXISTS departdb
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
(2)创建专业教师数据库(teacherdb)
CREATE DATABASE IF NOT EXISTS teacherdb
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
(3)创建学管教师数据库(mangedb)
CREATE DATABASE IF NOT EXISTS mangedb
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
P24
(1)创建课程管理数据库(coursedb)
CREATE DATABASE IF NOT EXISTS coursedb
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
(2)创建教材管理数据库(bookdb)
CREATE DATABASE IF NOT EXISTS bookdb
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
(3)创建实验室设备管理数据库(equipmentdb)
CREATE DATABASE IF NOT EXISTS equipmentdb
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;