试卷代号 座位号
中央广播电视大学200-2009学年度第学期期末考试
题号 一 二 三 四 总 分 得分
一、单项选择题（每个题只有一个答案是正确的。每题2分，共0分）
（ ）。
A、B、
C、D、 SQL Server默认的登录账号为-R图
D、将E-R图转换为关系模型A、B、C、D、
二、0分
1．关系模型由三个部分组成，分别是 、关系操作集合和 。。
三、2分，共10分）
1．DELETE TABLE的功能是删除表结构。（ ）
2．在教师任课关系（教师编号，教师姓名，教师职称，课程号，课程名，课时费）中，主键是教师编号。（ ）
3．触发器是一种特殊的存储过程，它基于一个表创建，可以针对多个表进行操作。（ ）
4．做结构设计时，要尽量使设计符合第三范式的要求。（ ）
5．登录账号用于身份验证，用户账号用于权限验证。（ ）
简述题（0分）
、题（0分）
Text1为课程号、Text2为课程名。进入界面后，用户输入所有数据，点击“确认”按钮，将结果插入到课程表courses中。请补充完成下列程序代码。
图2“增加记录”窗体运行界面
Private Sub Command1_Click()
‘声明一个记录集对象
Dim ADOrs As New Recordset
‘将记录集对象与已建立的数据库联接对象ADOcn绑定
ADOrs.ActiveConnection=ADOcn
‘第一步：在课程表Courses中查询是否存在关键字相同的记录
（1）拼写查询字符串
strSQL =
（2）执行查询语句
strSQL
‘第二步：如果记录已经存在，则退出程序
If Not Then
MsgBox “记录已存在，不能继续增加”
Exit Sub
End If
‘第三步：将结果插入到课程表Courses中
strSQL = “Insert Into courses(Cno,CName) Values(‘”+Text1+“’, ‘”+Text2+“’)”
strSQL
End Sub
中央广播电视大学200-2009学年度第学期期末考试
答案及评分标准
单项选择题（每个题只有一个答案是正确的。每题2分，共0分）
二、0分
1．数据结构 、关系的完整性
2．可移动
3． 行为设计
三、2分，共10分）
1．（ × ）（ × ）．（）．（）
．（）（0分）
、题（0分）;
评分要点
（1）写出CREATE TABLE语句得2分
（2）写出CREATE TABLE Students （
SNo CHAR(10),
SName CHAR(10),
SD DATETIME
）;得5分。
（3）用PRIMARY KEY等方式声明了主键得3分
（4）所有字符型数据类型可以是Char型或VarChar型。日期型也可以采用smalldatetime数据类型。所有语句不区分大小写。
2．参考答案及评分要点：
参考答案
SELECT students.Sno,Sname,Cname,mark
FROM students,courses,marks
WHERE students.Sno=marks.Sno and courses.Cno=marks.Cno and students.Sno=‘2009001’
评分要点
SELECT部分书写正确得3分，FROM部分书写正确得3分，WHERE部分书写正确得4分。所有语句不区分大小写。
3．参考答案及评分要点：
‘第一步：在课程表Courses中查询是否存在关键字相同的记录
strSQL=“Select CNo From courses Where Cno=‘” + Text1 + “’”（本小点6分）
ADOrs.Open StrSQL （本小点4分）
‘第二步：如果记录已经存在，则退出程序
If Not ADOrs.EOF Then （本小点4分）
MsgBox “记录已存在，不能继续增加”
Exit Sub
End If
‘第三步：将结果插入到课程表Courses中
strSQL = “Insert Into courses(Cno,CName) Values(‘”+Text1+“’,‘”+Text2+“’)”
ADOcn.Execute strSQL （本小点6分）
End Sub
to West rear, to County Shen Liqun report guerrillas breakout Hou of action situation, boat via Zhejiang wuxing daughter town Shi, six people has a NI surname "spies" (enemy) midway tuogu landing tipsters, away from small town three in Xu, was day Elves Li Taishan Department captured, five people all killed, broken corpse sank Yu River in the. On January 18, 1943, when the Japanese army militiamen arrested 53 people in Wuzhen, transferred to the tomb of the former Japanese military police command (in the "Tai" Jiang Yuan), the 28th in Shenyang North of jade bang massacred them. Hu Maosheng knife wounds woke up in the middle of them, crawling out from the dead, in the tomb of Gao Changhai residents, saved by bing. Such as Hu Maosheng, Gao Changhai is a witness to this tragedy. (B) in memory of "massacre" Xu Youyong yan tomb is the copper law. Copper originally was called Luo yan Tomb, because Eastern Han dynasty distinguished prose poems my father yan Tan bogey was buried in the town's water. Has a long history here, cultural atmosphere, and there are many old houses, and left many people with lofty ideals. Business flourished here, is the hub of four townships of agricultural and sideline products, wine culture has a long history. The outskirts of the town has left, "Huang Chi", originally Yue water hides
to West rear, to County Shen Liqun report guerrillas breakout Hou of action situation, boat via Zhejiang wuxing daughter town Shi, six people has a NI surname "spies" (enemy) midway tuogu landing tipsters, away from small town three in Xu, was day Elves Li Taishan Department captured, five people all killed, broken corpse sank Yu River in the. On January 18, 1943, when the Japanese army militiamen arrested 53 people in Wuzhen, transferred to the tomb of the former Japanese military police command (in the "Tai" Jiang Yuan), the 28th in Shenyang North of jade bang massacred them. Hu Maosheng knife wounds woke up in the middle of them, crawling out from the dead, in the tomb of Gao Changhai residents, saved by bing. Such as Hu Maosheng, Gao Changhai is a witness to this tragedy. (B) in memory of "massacre" Xu Youyong yan tomb is the copper law. Copper originally was called Luo yan Tomb, because Eastern Han dynasty distinguished prose poems my father yan Tan bogey was buried in the town's water. Has a long history here, cultural atmosphere, and there are many old houses, and left many people with lofty ideals. Business flourished here, is the hub of four townships of agricultural and sideline products, wine culture has a long history. The outskirts of the town has left, "Huang Chi", originally Yue water hides数据库应用技术试题第 9 页（共 9页）
to West rear, to County Shen Liqun report guerrillas breakout Hou of action situation, boat via Zhejiang wuxing daughter town Shi, six people has a NI surname "spies" (enemy) midway tuogu landing tipsters, away from small town three in Xu, was day Elves Li Taishan Department captured, five people all killed, broken corpse sank Yu River in the. On January 18, 1943, when the Japanese army militiamen arrested 53 people in Wuzhen, transferred to the tomb of the former Japanese military police command (in the "Tai" Jiang Yuan), the 28th in Shenyang North of jade bang massacred them. Hu Maosheng knife wounds woke up in the middle of them, crawling out from the dead, in the tomb of Gao Changhai residents, saved by bing. Such as Hu Maosheng, Gao Changhai is a witness to this tragedy. (B) in memory of "massacre" Xu Youyong yan tomb is the copper law. Copper originally was called Luo yan Tomb, because Eastern Han dynasty distinguished prose poems my father yan Tan bogey was buried in the town's water. Has a long history here, cultural atmosphere, and there are many old houses, and left many people with lofty ideals. Business flourished here, is the hub of four townships of agricultural and sideline products, wine culture has a long history. The outskirts of the town has left, "Huang Chi", originally Yue water hides
得 分 评卷人
得 分 评卷人
得 分 评卷人
得 分 评卷人
Command1