数据库原理及应用附录B实验Student-info程序代码

´´½¨±ícreatetableStudent(Snochar(8)primarykey,Snamevarchar(8)notnull,Sexchar(2)notnull,Birthsmalldatetimenotnull,Classnochar(3)notnull,Entrance_datesmalldatetimenotnull,Home_addrvarchar(40),Sdeptchar(2)notnull,Postcodechar(6)check(PostcodeLike'[1-9][0-9][0-9][0-9][0-9][0-9]'))createtableCourse(Cnochar(3)primarykey,Cnamevarchar(20)notnull,Total_periorsmallintcheck(Total_perior0),Credittinyintcheck(Credit=6andcredit0))createtableSC(Snochar(8)notnull,Cnochar(3)notnull,Gradetinyintcheck(Grade=0andGrade=100),primarykey(Sno,Cno),foreignkey(Sno)referencesStudent(Sno),foreignkey(Cno)referencesCourse(Cno)£©²åÈëÊý¾ÝinsertintoStudentvalues('20110001','Õźç','ÄÐ','1992-09-01','051','2011-09-01','ÄϾ©','CS','200413'),('20110002','ÁÖºì','Å®','1991-11-12','051','2011-09-01','±±¾©','CS','100010'),('20110103','ÕÔÇà','ÄÐ','1993-05-11','061','2011-09-01','ÉϺ£','MS','200013');insertintoCoursevalues('001','¸ßÊý','96','6'),('002','CÓïÑÔ³ÌÐòÉè¼Æ','80','5'),('003','JAVAÓïÑÔ³ÌÐòÉè¼Æ','48','3'),('004','VisualBasic','48','4');insertintoSCvalues('20050001','001',89),('20110001','001',89),('20110001','002',78),('20110001','003',89),('20110002','002',60),('20110103','001',80);