《數(shù)據(jù)庫原理》實(shí)驗(yàn)4

一、實(shí)驗(yàn)?zāi)康?/p>

實(shí)驗(yàn)四：管理SQLServer表數(shù)據(jù)熟悉數(shù)據(jù)表結(jié)構(gòu)及使用特點(diǎn)；ManagementStuioT-SQL二、實(shí)驗(yàn)環(huán)境SQLServer2000IP;三、實(shí)驗(yàn)學(xué)時(shí)2學(xué)時(shí)四、實(shí)驗(yàn)要求SQLServerSQLServer完成實(shí)驗(yàn)報(bào)告（部分題只需給出關(guān)鍵語句。五、實(shí)驗(yàn)內(nèi)容及步驟（studentcours、scManagementStuioT-SQL語句實(shí)現(xiàn)進(jìn)行以下操作：向各個(gè)數(shù)據(jù)表中插入如下記錄：學(xué)生信息表（student）SnoSnameSsexSageSdept200515001趙菁菁女23CS200515002李勇男20CS200515003張力男19CS200515004張衡男18IS200515005張向東男20IS200515006張向麗女20IS200515007王芳女20CS200515008王民生男25MA200515009王小民女18MA200515010李晨女22MA200515011張毅男20WM200515012楊磊女20EN200515013李晨女19MA200515014張豐毅男22CS200515015李蕾女21EN200515016劉社男21CM200515017劉星耀男18CM200515018李貴男19EN200515019林自許男20WM200515020馬翔男21200515021劉峰男25CS200515022牛站強(qiáng)男22200515023李婷婷麗女20200515025朱小鷗女30WMinsertintostudentvalues('200515001','趙菁菁','女',23,'cs')insertintostudentvalues('200515002','李勇','男',20,'cs')insertintostudentvalues('200515003','張力','男',23,'cs')insertintostudentvalues('200515004','張衡','男',20,'is')insertintostudentvalues('200515005','張向東','男',23,'is')insertintostudentvalues('200515006','張向麗','女',20,'is')insertintostudentvalues('200515007','王芳','女',23,'cs')insertintostudentvalues('200515008','王民生','男',20,'ma')insertintostudentvalues('200515009','王小民','女',23,'ma')insertintostudentvalues('200515010','李晨','女',20,'ma')insertintostudentvalues('200515011','張毅','男',23,'wm')insertintostudentvalues('200515012','楊磊','男',20,'en')insertintostudentvalues('200515013','李晨','女',23,'ma')insertintostudentvalues('200515014','張豐毅','男',20,'cs')insertintostudentvalues('200515015','李蕾','女',23,'en')insertintostudentvalues('200515016','劉社','男',20,'cm')insertintostudentvalues('200515017','劉星耀','男',23,'cm')insertintostudentvalues('200515018','李貴','男',20,'en')insertintostudentvalues('200515019','林自許','男',23,'wm')insertintostudentvalues('200515020','馬翔','男',20,'')insertintostudentvalues('200515021','劉峰','男',23,'cs')insertintostudentvalues('200515022','牛站強(qiáng)','男',20,'')insertintostudentvalues('200515023','李婷婷','女',23,'')insertintostudentvalues('200515024','嚴(yán)麗','女',20,'')insertintostudentvalues('200515025','朱小鷗','女',20,'wm')課程信息表（course）CnoCnameCpnoCcredit1數(shù)據(jù)庫542數(shù)學(xué)23信息系統(tǒng)144操作系統(tǒng)635數(shù)據(jù)結(jié)構(gòu)746數(shù)據(jù)處理27PASCAL語言648大學(xué)英語49計(jì)算機(jī)網(wǎng)絡(luò)410人工智能2insertintocoursevalues(1,'數(shù)據(jù)庫','5',4)insertintocoursevalues(2,'數(shù)學(xué)','',2)insertintocoursevalues(3,'信息系統(tǒng)','1',4)insertintocoursevalues(4,'操作系統(tǒng)','6',3)insertintocoursevalues(5,'數(shù)據(jù)結(jié)構(gòu)','7',4)insertintocoursevalues(6,'數(shù)據(jù)處理','',2)insertintocoursevalues(7,'PASCAL語言','6',4)insertintocoursevalues(8,'大學(xué)英語','',4)insertintocoursevalues(9,'計(jì)算機(jī)網(wǎng)絡(luò)','',4)insertintocoursevalues(10,'人工智能','',2)選課信息表（sc）SnoCnoGrade200515001175200515002185200515002353200515003186200515004174200515005158200515006 184200515004 246200515005 289200515006 265200515008 272200515009 276200515010 296200515010 886200515011 862200515015 80200515018 858200515001 462200515002 485200515021 954200515001 558200515021 658200515001 770200515005 1065200515016 8Nullinsertinto200515017 8scvalues('200515001',1,75)Nullinsertintoscvalues('200515002',1,85)insertintoscvalues('200515002',3,53)insertintoscvalues('200515003',1,86)insertintoscvalues('200515004',1,74)insertintoscvalues('200515005',1,58)insertintoscvalues('200515006',1,84)insertintoscvalues('200515004',2,46)insertintoscvalues('200515005',2,89)insertintoscvalues('200515006',2,65)insertintoscvalues('200515008',2,72)insertintoscvalues('200515009',2,76)insertintoscvalues('200515010',2,96)insertintoscvalues('200515010',8,86)insertintoscvalues('200515011',8,62)insertintoscvalues('200515015',8,0)insertintoscvalues('200515018',8,58)insertintoscvalues('200515001',4,62)insertintoscvalues('200515002',4,85)insertintoscvalues('200515021',9,54)insertintoscvalues('200515001',5,58)insertintoscvalues('200515021',6,58)insertintoscvalues('200515001',7,70)insertintoscvalues('200515005',10,65)insertintoscvalues('200515016',8,'')insertintoscvalues('200515017',8,'')CSUpdatestudentSetSname='李詠'WhereSname='李勇'andSdept='CS'3UpdatecourseSetCcredit=3WhereCname='數(shù)據(jù)處理'將選修課程“1”5UpdatescSetGrade=Grade+5WhereCno=15UpdatescSetGrade=Grade+5WhereCno=8Cno8將學(xué)號(hào)為“200515010”的學(xué)生信息重新設(shè)置為“王丹丹、女、20、MADeleteFromStudentWhereSno='200515010'Insertintostudentvalues('200515010','王丹丹','女',20,'MA')20050015UpdatescSetmingzi='王婧婧',zhuanye='信息管理',jieshuliang=jieshuliang+