数据库案例.doc

亚装修墙纸网站。装修知识。装修宝典。墙纸知识。装修效果图。应有竟有。欢迎光临!!!阿卡帝亚墙纸交流群:138763561:..CREATEDATABASETESTDBONPRIMARY(NAME='TESTDB_DATA',FILENAME='E:\OBJECT\',SIZE=5MB,MAXSIZE=100MB,FILEGROWTH=15%)LOGON(NAME='TESTDB_LOG',FILENAME='E:\OBJECT\',SIZE=3MB,MAXSIZE=20MB,FILEGROWTH=1)GOCREATETABLESTUDENT(SNOVARCHAR(3)NOTNULL,SNAMEVARCHAR(4)NOTNULL,SSEXVARCHAR(2)NOTNULL,SBIRTHDAYDATETIME,CLASSVARCHAR(5))OVARCHAR(5)AMEVARCHAR(10)NOTNULL,TNOVARCHAR(10)NOTNULL)GOCREATETABLESCORE(SNOVARCHAR(3)OVARCHAR(5)NOTNULL,DEGREENUMERIC(10,1)NOTNULL)GOCREATETABLETEACHER(TNOVARCHAR(3)NOTNULL,MEVARCHAR(4)NOTNULL,TSEXVARCHAR(2)NOTNULL,TBIRTHDAYDATETIMENOTNULL,PROFVARCHAR(6),DEPARTVARCHAR(10)NOTNULL)GOINSERTINTOSTUDENT(SNO,SNAME,SSEX,SBIRTHDAY,CLASS)VALUES(108,'曾华','男','1977-1-9',95033)INSERTINTOSTUDENT(SNO,SNAME,SSEX,SBIRTHDAY,CLASS)VALUES(105,'匡明','男','1976-1-9',95031)INSERTINTOSTUDENT(SNO,SNAME,SSEX,SBIRTHDAY,CLASS)VALUES(107,'王丽','女','1975-1-1',95033)INSERTINTOSTUDENT(SNO,SNAME,SSEX,SBIRTHDAY,CLASS)VALUES(101,'李军','男','1976-2-2',95033)INSERTINTOSTUDENT(SNO,SNAME,SSEX,SBIRTHDAY,CLASS)VALUES(109,'王芳','女','1976-10-2',95031)INSERTINTOSTUDENT(SNO,SNAME,SSEX,SBIRTHDAY,CLASS)VALUES(103,'陆君','男','1974-3-6',95031)AME,TNO)VALUES('3-105','计算机导论',825)AME,TNO)VALUES('3-245','操作系统',804)AME,TNO)VALUES('6-166','数据电路',856)AME,TNO)VALUES('9-888','高等数学',100)INSERTINTOSC