uctureforspecialityDROPTABLEIFEXISTSspecialityCREATETABLEspecialitysp
ochar8NOTNULLd
ochar6NOTNULLsp
amechar20NOTNULLENGINEI
oDBDEFAULTCHARSETutf8RecordsofspecialityTablestructureforstude
tDROPTABLEIFEXISTSstude
tCREATETABLEstude
ts_
ochar8NOTNULLs
amechar8NOTNULLsexchar2DEFAULTNULLsbirthdaydatetimeDEFAULTNULLd
ochar6NOTNULLsp
ochar8NOTNULLclass_
ochar4DEFAULTNULLENGINEI
oDBDEFAULTCHARSETutf8Recordsofstude
t
4
fTablestructureforstude
t_courseDROPTABLEIFEXISTSstude
t_courseCREATETABLEstude
t_courses_
ochar8NOTNULLtcidsmalli
t6NOTNULLscoreti
yi
t4DEFAULTNULLENGINEI
oDBDEFAULTCHARSETutf8Recordsofstude
t_courseTablestructureforteacherDROPTABLEIFEXISTSteacherCREATETABLEteachert_
ochar8NOTNULLt_
amechar8NOTNULLt_sexchar2DEFAULTNULLt_birthdaydatetimeDEFAULTNULLd
ochar6NOTNULLtech_titlechar10DEFAULTNULLENGINEI
oDBDEFAULTCHARSETutf8RecordsofteacherTablestructureforteacher_courseDROPTABLEIFEXISTSteacher_courseCREATETABLEteacher_coursetcidsmalli
t6NOTNULL
5
ft_
ochar8NOTNULLsp
ochar8NOTNULLclass_
ochar4DEFAULTNULLc
ochar10NOTNULLsemesterchar6DEFAULTNULLschoolyearchar10DEFAULTNULLPRIMARYKEYtcidENGINEI
oDBDEFAULTCHARSETutf8Recordsofteacher_course
6
f题目3、查看各数据表之间的关系，生成数据库关系图。生成数据库关系图截图显示
题目4、利用查询分析器修改上述各表。1、用INSERT语句向各个表中插入数据录入5条记录。录入时注意体会外键约束。实现代码及截图：查询分析器执行情况：SQL语句及执行结果显示INSERTINTOstude
tVALUES6079陈三男19910220203206116实现代码及截图：实验结果截图显示（插入数据的表格）
7
f查询分析器执行情况：SQL语句及执行结果显示INSERTINTOcourseVALUES1计算机网络11205255
实验结果截图显示（插入数据的表格）
实现代码及截图：查询分析器执行情况：SQL语句及执行结果显示INSERTINTOsr