资源描述：
《数据库课程设计 教学管理系统》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、学校教务管理的数据库设计学生表droptablestudentcreatetablestudent(Snochar(40)primarykey,Snamechar(40),Ssexchar(2),Sclasschar(20),Sclassnochar(20),Sbirthdaydatetime,Shomechar(40),Sdeptchar(40),);insertintostudentvalues('12232617','Victor','男','英语','082','2/1/1990','America','07'
2、);insertintostudentvalues('12232621','Susan','女','英语','083','1/25/1990','japan','07');insertintostudentvalues('12232625','Carlos','男','广告设计','082','2/12/1990','America','01');insertintostudentvalues('12232627','Dave','男','电子商务','082','10/1/1989','America','02');
3、insertintostudentvalues('12232628','Gaby','女','金融','081','1/12/1990','Italy','04');insertintostudentvalues('12232629','Lynette','女','会计','082','9/12/1989','Britain','05');insertintostudentvalues('12232636','Bree','女','会计','082','11/18/1989','Italy','05');inserti
4、ntostudentvalues('12232645','tom','男','数学','081','12/22/1989','Britain','06');insertintostudentvalues('12232631','zach','男','国际贸易','081','4/16/1990','Japan','03');insertintostudentvalues('12232641','Karl','男','计算机','082','6/8/1990','Britain','08');insertintostud
5、entvalues('12232633','Edie','女','广告设计','083','12/11/1989','Holland','01');insertintostudentvalues('12232643','Dylan','女','数学','082','4/20/1990','Britain','06');insertintostudentvalues('12232610','John','男','金融','081','11/25/1989','America','04');insertintostuden
6、tvalues('12232620','Mike','男','计算机','082','12/30/1989','China','08');系表droptabledepartmentcreatetabledepartment(Sdeptchar(40)primarykey,Dnamechar(9),Dmasterchar(20));insertintodepartmentvalues('01','广告设计','zt');insertintodepartmentvalues('02','电子商务','bc');insert
7、intodepartmentvalues('03','国际贸易','kl');insertintodepartmentvalues('04','金融','nn');insertintodepartmentvalues('05','会计','jr');insertintodepartmentvalues('06','数学','ed');insertintodepartmentvalues('07','英语','mj');insertintodepartmentvalues('08','计算机','ry');教师表drop
8、tableteachercreatetableteacher(Tnochar(9)primarykey,Tnamechar(20),Tclasschar(20),Tworkchar(20));insertintoteachervalues('001','赵老师','特级教师','线性代数');insertintoteacherva
