2010811050 陈艺军 实验六2010811050 陈艺军 实验六.docVIP

集美大学计算机工程学院实验报告 课程：：：名称： 上机实践日期： 实验项目编号：组： 一、目的本次所涉及并要求掌握的知识点二、内容与三、用环境本次所使用的平台和相关软件SQLFULL_X86_CHS 四use STUDENT go create table S50 ( SNO VARCHAR (6) PRIMARY KEY, SNAME VARCHAR(20), DEPA VARCHAR(20), AGE INT, SEX CHAR(4), ); INSERT INTO S47 VALUES(200512,李勇,计算机系,20,男); INSERT INTO S50 VALUES(200518,刘晨,计算机系,19,女); INSERT INTO S50 VALUES(200018,王敏,数学系,18,女); INSERT INTO S50 VALUES(200511,杨扬,物理系,20,男); INSERT INTO S50 VALUES(200510,张立,信息系,19,男); INSERT INTO S50 VALUES(200513,张立,物理系,19,男); INSERT INTO S50 VALUES(200514,王点点,信息系,19,女); INSERT INTO S50 VALUES(200012,欧阳雨,数学系,20,男); INSERT INTO S50 VALUES(200515,刘依依,数学系,23,女); （2） use STUDENT go create table C50 ( CNO VARCHAR(10) PRIMARY KEY, CNAME VARCHAR(20), cpno varchar(10), credit int ) INSERT INTO C50 VALUES(c01,数据库原理,c03,4); INSERT INTO C50 VALUES(c02,信息系统,C01,4); INSERT INTO C50 VALUES(c03,数据结构,null,6); INSERT INTO C50 VALUES(c04,DB_设计,co1,3); （3） use STUDENT go create table SC50 ( SNO VARCHAR(6) NOT NULL, SNAME VARCHAR(10) NOT NULL, GRADE DECIMAL, FOREIGN KEY (SNO) REFERENCES S50(SNO), FOREIGN KEY (SNAME) REFERENCES C50(CNO) ) INSERT INTO SC50 VALUES(200512,c02,70); INSERT INTO SC50 VALUES(200512,c03,null); INSERT INTO SC50 VALUES(200512,c04,null); INSERT INTO SC50 VALUES(200515,c01,80); INSERT INTO SC50 VALUES(200518,c03,95); INSERT INTO SC50 VALUES(200518,c01,80); INSERT INTO SC50 VALUES(200518,c02,45); INSERT INTO SC50 VALUES(200511,c02,78); INSERT INTO SC50 VALUES(200511,c01,45); INSERT INTO SC50 VALUES(200511,c03,89); INSERT INTO SC50 VALUES(200514,c02,78); INSERT INTO SC50 VALUES(200514,c01,45); INSERT INTO SC50 VALUES(200514,c03,89); INSERT INTO SC50 VALUES(200514,c04,78); （二）. 验证性实验 1．数据的插入 （1）单记录的插入 USE STUDENT GO SELECT * FROM S50 INSERT INTO S50(SNO,SNAME) VALUES(200300,Paulwen) SELECT * FROM S50 （2）多记录的插入 CREATE TABLE SBAK(SNO VARCHAR (10) NOT NULL ,SNAME VARCHAR(20), DEPA VARCHAR(20), AGE INT, SEX CHAR(4)) GO SELECT * FROM SBAK INSERT INTO SBAK SELECT * FROM S50 SELECT * FRO