问题 单项选择题

设U为所有属性的集合,X、Y、Z为属性集,Z=U-X-Y。下列关于多值依赖的叙述中,正确的是( )。

A.若X→→Y则X→→Z

B.若X→→Y,则X→Y

C.设

,若X→→Y在R(W)上成立,则X→→Y在R(U)上成立

D.若X→→Y在R(U)上成立,且

,则X→→Y,在R(U)上成立

答案

参考答案:A

解析: 若X→→Y,而Z=Φ,则称X→→Y为平凡的多值依赖。 若X→→Y在R(U)上成立,用Y'∈Y,我们不可以断言X→→Y'成立。 设R是属性集U上的一个关系模式,X、Y是U的子集,Z=U-X-Y,多值依赖的性质有: ①若X→→Y,则X→→Z,其中Z=U-X-Y,即多值依赖具有对称性。 ②若X→Y,则X→→Y,即函数依赖可以看作多值依赖的特殊情况。 ③设属性集之间的关系是XY∈W∈U,那么当X→→Y在R(U)上成立的时候,X→→Y在R(W)上也成立:反过来当X→→Y在R(W)上成立时,X→→Y在R(U)上不一定成立。 ④若X→→Y,且Y'∈Y,但不能断言X→→Y'也成立。因为多值依赖的定义中涉及了U中除X、Y之外的其余属性Z,考虑X→→Y'是否成立时涉及的其余的属性Z'=U-X-Y'比确定X→→Y成立时的其余属性Z=U-X-Y包含的属性列多,因此X→→Y'不一定成立。

完形填空
In 2002, when my father was transferred(调动)to the US to work there for seven months,
I had to attend school there, so I was upset. How would I, an eight-year-old girl from India, make
Friends in America?
On my first day at Anna Silver Public School, I      Miss Alice McNally, my class teacher, who couldn’t get my name      --- although she tried hard, she usually called me Diya or Diva instead of Divya. But she      to speak to me in a way that was easy for me---slowly,       words clearly---to get me used to the American   . When discovering that I enjoyed     , she took me to meet the art teacher. Miss McNally made sure that I was in perfect harmony with her class, and I had as much      as any schoolgirl could have from school.
When my father was transferred back to India, I had to    Anna Silver Public School. I was going to leave before a scheduled fishing trip, and I’d      the class photo session(集会) too. Therefore, with a heavy heart, I left my school and the US. Back in Kerala, I received a        
Surprise one day---a package in which Miss McNally and my twenty-four former classmates had written me a letter each,      me about the fishing trip and interesting things that happened while taking the class photo. Miss McNally added, “Keep up with your drawing, since you love it so much.” Miss McNally not only made a     little girl feel at home in a faraway country, but also taught me and the others, at an early age, the importance of being kind to others.
小题1:
A.recognizedB.puzzledC.metD.hurt
小题2:
A.right B.smartC.briefD.similar
小题3:
A.took overB.took careC.took backD.took control
小题4:
A.spellingB.shoutingC.sayingD.writing
小题5:
A.ceremony B.customC.educationD.accent
小题6:
A.drawingB.musicC.advertisingD.sports
小题7:
A.funB.luckC.patienceD.pride
小题8:
A.disturbB.leaveC.chooseD.begin
小题9:
A.supportB.enjoyC.planD.miss
小题10:
A.lastingB.mildC.hopefulD.pleasant
小题11:
A.advisingB.teachingC.tellingD.asking
小题12:
A.sweetB.shyC.braveD.beautiful
解答题