1.学会使用对象资源管理器创建数据库、创建基本表和查看数据库属性 2.学会使用对象资源管理器向数据库输入数据，修改数据，删除

USE 数据库技术实验 CREATE TABLE Student ( Sno VARCHAR(50) PRIMARY KEY, /*主键*/ Sname VARCHAR(50) NOT NULL, Ssex CHAR(10), Sage INT, Sdept VARCHAR(50) ) CREATE TABLE Course ( Cno VARCHAR(50) PRIMARY KEY, /*主键*/ Cname VARCHAR(50) NOT NULL, Ctime INT, Ccredit INT ) CREATE TABLE Teacher ( Tno VARCHAR(50) PRIMARY KEY, /*主键*/ Tname VARCHAR(50) NOT NULL, Tsex CHAR(10) NOT NULL, Cno VARCHAR(50) FOREIGN KEY REFERENCES Course(Cno),/*外键*/ Tdept VARCHAR(50) ) CREATE TABLE Score ( Sno VARCHAR(50) FOREIGN KEY REFERENCES Student(Sno), /*外键*/ Cno VARCHAR(50) FOREIGN KEY REFERENCES Course(Cno), /*外键*/ Grade int, PRIMARY KEY(Sno, Cno) /*联合主键*/ ) INSERT INTO Student (Sno, Sname, Ssex, Sdept, Sage) VALUES ('96001' ,'马小燕' ,'女', 'CS', 21), ('96002' ,'黎明' ,'男', 'CS', 18), ('96003' ,'刘东明' ,'男', 'MA', 18), ('96004' ,'赵志勇' ,'男', 'IS', 20), ('97001' ,'马蓉' ,'女', 'MA', 19), ('97002' ,'李成功' ,'男', 'CS', 20), ('97003' ,'黎明' ,'女', 'IS', 19), ('97004' ,'李丽' ,'女', 'CS', 19), ('96005' ,'司马志明' ,NULL, 'CS', 18) INSERT INTO Course (Cno, Cname, Ctime, Ccredit) VALUES ('001', '数学分析', 100, 6), ('002', '普通物理', 110, 6), ('003', '微机原理', 80, 4), ('004', '数据结构', 72, 4), ('005', '操作系统', 80, 5), ('006', '数据库原理', 80, 4), ('007', '编译原理', 60, 3), ('008', '程序设计', 40, 2) INSERT INTO Teacher(Tno, Tname, Tsex, Cno, Tdept) VALUES ('1101', '王成刚' ,'男', '004', 'CS'), ('1102', '李正科' ,'男', '003', 'CS'), ('1103', '严敏' ,'女', '001', 'MA'), ('1105', '王成银' ,'女', '004', 'IS'), ('1106', '李副科' ,'女', '003', 'MA'), ('1107', '刘玉兰' ,'女', '006', 'CS'), ('1108', '王成铁' ,'男', '004', 'IS'), ('1109', '马兰' ,'女', '008', 'CS') INSERT INTO Score (Sno, Cno, Grade) VALUES ('96001', '001', '77'), ('96001', '003', '89'), ('96001', '004', '86'), ('96001', '005', '82'), ('96002', '001', '88'), ('96002', '003', '92'), ('96002', '006', '90'), ('96005', '004', '92'), ('96005', '005', '90'), ('96005', '006', '89'), ('96005', '007', '76'), ('96003', '001', '69'), ('97001', '001', '96'), ('97001', '008', '95'), ('96004', '001', '87'), ('96003', '003', '91'), ('97002', '003', '91'), ('97002', '004', NULL), ('97002', '006', '92'), ('97004', '005', '90'), ('97004', '006', '85')