数据库课程设计-教学管理系统

12345-6-7891011-1213-14151617-18DBMSDBMSCreatedatabase;(1)Createtable(Xnochar(10)primarykeynotnull,Xnamechar(10)notnull,Xdirectorchar(10),)(2)Createtable(Cnochar(10)primarykey,Cnamechar(10)notnull,Xnochar(10),Cdirectorchar(10),)19(3)Createtable(Snochar(10)primarykey,Snamechar(10)notnull,Ssexchar(2)notnull,Saddrchar(10)notnull,Sagesmallintnotnull,Smajorchar(10)notnull,Cnochar(10),)(4)Createtable(Courcenochar(10)primarykey,Courcenamechar(10)notnull,Ccreditsmallintnotnull,Courcedirectorchar(8),)(5)Createtable(Snochar(10),Courcenochar(10),Gradechar(10)notnull,)(6)Createtable(Rnochar(10)primarykey,Rnamechar(10)notnull,Raddrchar(10)notnull,)(7)Createtable(Cnochar(10),Rnochar(10),Stimedatetime,Uestimechar(10),)20(8)Createtable(Tnochar(10)primarykey,Tnamechar(10)notnull,Tsexchar(10)notnull,Tposchar(10)notnull,Tagesmallintnotnull,Tsalsmallintnotnull,)(9)Createtable(Tnochar(10),Cnochar(10),Courcenochar(10),Teachtimedatetimenotnull,)(1):createview_viewasselect*fromwithcheckoption;(2):createview_viewasselect*fromwithcheckoption;(3):createview_viewasselect*fromwithcheckoption;(4):createview_viewasselect*fromwithcheckoption;21(5):createview_viewasselect*fromwithcheckoption;(6):createview_viewasselect*fromwithcheckoption;(7):createview_viewasselect*fromwithcheckoption;(8):createview_viewasselect*fromwithcheckoption;(9):createview_viewasselect*fromwithcheckoption;1Createprocedure_insert@Xnochar(10),@Xnamechar(10),@Xdiredtorchar(10)AsInsertintovalues(@Xno,@Xname,@Xdiredtor);(2)createprocedure_insert@Cnochar(10),@Cnamechar(10),@Xnochar(10),@Cdirectorchar(10)AsInsertintovalues(@Cno,@Cname,@Xno,@Cdirector);22(3)createprocedure_insert@Snochar(10),@Snamechar(10),@Ssexchar(10),@Saddrchar(10),@Sagesmallint,@Smajorchar(10),@Cnochar(10)AsInsertintovalues(@Sno,@Sname,@Ssex,@Saddr,@Sage,@Smajor,@Cno)(4)createprocedure_insert@Courcenochar(10),@Courcenamechar(10),@Ccreditsmallint,@Courcedirectorchar(8)AsInsertintovalues(@Courceno,@Courcename,@Ccredit,@Courcedirc)(5)createprocedure_insert@Snochar(10),@Courcenochar(10),@Gradechar(10)AsInsertintovalues(@Sno,@Courceno,@Grade);(6)createprocedure_insert@Rnochar(10),@Rnamechar(10),@Raddrchar(10)AsInsertintovalues(@Rno,@Rname,@Raddr);(7)createprocedure_insert@Cnochar(10),@Rnochar(10),@Stimedatetime,@UseTimechar(10)AsInsertintovalues(@Cno,@Rno,@Stime,@Usetime)(8)createprocedure_insert@Tnochar(10),@Tnamechar(10),@Tsexchar(10),@Tposchar(10),@Tagesmallint,@TsalsmallintAsInsertintovalues(@Tno,@Tname,@Tsex,@Tpos,@Tage,@Tsal);(9)createprocedure_insert@Tnochar(10),@Cnochar(10),@Courcenochar(10),@TeachtimedatetimeAsInsertintovalues(@Tno,@Cno,@Courceno,@Teachtime)23242526272829