重庆大学试卷
教务处06版
第1页共5页
Problem210poi
ts
重庆大学
数据库系统
20082009学年
课程试卷
第一学期
考试日期：20081222考试时间：120分钟总分
开课学院：
计算机学院
考试方式：
题号
姓名密
一
二
三
四
五
六
七
八
九
得分
注：1大标题用四号宋体、小标题及正文用小四号宋体；2按A4纸缩小打印
O
ewaytoreprese
tstude
tsa
dthegradestheygeti
coursesistousethee
titysetscorrespo
di
gtostude
tstocoursesa
dto“e
rollme
ts”注册E
rollme
tse
titiesforma“co
ecti
g”e
titysetbetwee
stude
tsa
dcoursesa
dca
beusedtoreprese
t
oto
lythefactthatastude
tistaki
gacertai
coursebutthegradeofthestude
ti
thecourseEverystude
thasadiffere
tida
dthereisau
ique
umberforeachcourseDrawa
ERdiagramforthissituatio
i
dicati
gweake
titysetsa
dthekeysforthee
titysetsIsthegradepartofthekeyfore
rollme
ts
命题人：曾令秋杨广超组题人：朱征宇审题人：罗军命题时间：
20081127
NOTESTheexamisclosedbooka
dclosed
otesPleasewriteyoursolutio
si
thespacesprovidedo
theexamMakesureyoursolutio
sare
eata
dclearlymarkedYoumayusethebla
kareasa
dbacksoftheexampagesforscratchworkPleasedo
otusea
yadditio
alscratchpaper
封
学号
Problem110poi
ts
Asiswellk
ow
ADBMSsuppotsco
curre
taccesstodataItca
beaccessedsimulta
eouslybyma
ydisti
ctprocesseswhicharecalledtra
sactio
sPleasedescriptthefourpropertiesACIDofTra
sactio

年级线专业学院
f重庆大学试卷
教务处06版
第2页共5页
Problem315poi
ts
Co
vertthefollowi
gERDiagramtoarelatio
aldatabaseschema
Problem415poi
tsCo
sidertherelatio
schemaRABCDEwithfu
ctio
aldepe
de
ciesABCCDCEDAEB
m


aFi
dallthekeysforRbWhichofthegive
depe
de
ciesviolate3NF
m
1



f重庆大学试卷
教务处06版
第3页共5页
R1ABCa
dR2CDETwoge
eralqueryexpressio
sofrelatio
alalgebraare
Problem510poi
ts
Hereisarelatio
RAB12146796Pleaseshowhowtoexpressthetwoqueriesi
SQLC35103D4795E8689
a
dthereisa
expressio
ofrelatio
alalgebrao
R
ABD5
a
dE8
R
iDescriptthemea
i
goftheexpressio
iiWritetheresultoftheexpressio
whe
itisusedo
R
Problem710poi
ts
Usi
gthetwobasetablesDeptdeptiddept
amedeptdescriptio
Employeeempidemp
amejobhiredatedeptidiDefi
eaviewCou
tEmpthatgivesforeachdepartme
titsdept
amea
dthe
umberofitsemployeesiiWriteaqueryusi
gyourviewfromiaski
gfor“dept
ame”ofthedepartme
ti
whichthe
umberofemployeesismoretha
10
Problem68r