教师管理系统数据库设计.docxVIP

数据库表SQL脚本--createdatabase TMSystem;--教师管理系统,（名字随便起的）gouse TMSystem;go--1职务职称表createtable job(jobId integerprimarykeyidentity, jobName nvarchar(10));insertinto job(jobName)values(N教授);insertinto job(jobName)values(N副教授);insertinto job(jobName)values(N院长);insertinto job(jobName)values(N副院长);insertinto job(jobName)values(N博士生导师);insertinto job(jobName)values(N硕士生导师);insertinto job(jobName)values(N博士生导师);insertinto job(jobName)values(N高级工程师);insertinto job(jobName)values(N学院教工);insertinto job(jobName)values(N讲师);insertinto job(jobName)values(N主任);insertinto job(jobName)values(N副主任);insertinto job(jobName)values(N江苏省特聘教授);insertinto job(jobName)values(N江苏大学特聘教授);--2学院系部表createtable department(departmentId integerprimarykeyidentity,departmentName nvarchar(10));insertinto department(departmentName)values(N科学系);insertinto department(departmentName)values(N工程系);insertinto department(departmentName)values(N通信工程系);insertinto department(departmentName)values(N物联网空间安全系);insertinto department(departmentName)values(N软件工程系);insertinto department(departmentName)values(N基础部);insertinto department(departmentName)values(N专业实验室);insertinto department(departmentName)values(N计算中心);insertinto department(departmentName)values(N物联网工程研究所);insertinto department(departmentName)values(N软件系统研究所);insertinto department(departmentName)values(N电子与通信技术研究所);insertinto department(departmentName)values(N计算机科学国际化部);--3教师表createtable teacher(teacherId nvarchar(15)primarykey,--教师工号eacherName nvarchar(10)notnull,--教师姓名sex integernotnull,--性别0:男1：女jobName nvarchar(10)notnull,--职务职称（这里要保存职务的编号还是名称）？？？？？？departmentId integernotnull,--所属系部（这里要保存系部的编号还是名称）？？？？？？researchDirection nvarchar(20)notnull,--研究方向phoneNumber nvarchar(20),--联系电话eMail nvarchar(20),--电子邮箱production nvarchar(200));--个人简介有的老师的简介好长，字数也许不够，就这样还是？？？？？--4教育情况createtable education(educationId integerprimarykeyidentity,teacherId nvarchar(15)foreignkeyreferences teacher(teacherId),educationExperience nvarchar(50)notnull);--教育情况--5学术兼职createtable part