关系模式R(U,F),其中U=A,B,C,D,E,F=AC→E,E→D,A→B,B→D。关系模式R的候选键是(21),(22)是无损连接并保持函数依赖的分解。 (22)处填()。
A: ρ={R1(AC),R2(ED),R3(AB)}
B: ρ={R1(ABC),R2(ED),R3(ACE)}
C: ρ={R1(ABC),R2(ED),R3(AE)}
D: ρ={R1(ACE),R2(ED),R3(AB)}
A: ρ={R1(AC),R2(ED),R3(AB)}
B: ρ={R1(ABC),R2(ED),R3(ACE)}
C: ρ={R1(ABC),R2(ED),R3(AE)}
D: ρ={R1(ACE),R2(ED),R3(AB)}
举一反三
- 设关系模式R(U,F),其中R上的属性集U={A,B,C,D,E},R上的函数依赖集F={A→B,DE→B,CB→E,E→A,B→D}。______为关系R的候选关键字。分解______是无损连接,并保持函数依赖。 A: ρ={R1(AC),R2(ED),R3(B)} B: ρ={R1(AC),R2(E),R3(DB)} C: ρ={R1(AC),R2(ED),R3(AB)} D: ρ={R1(ABC),R2(ED),R3(ACE)}
- 设关系模式 R (U , F ),其中 : U= {A , B,C,D,E } , F={A → B , DE → B , CB → E , E → A , B → D}()为关系模式 R 的候选关键字。分解(此空作答)是无损连接,并保持函数依赖的 A: ρ={ R1(AC),R2(ED),R3(B) } B: ρ={ R1(AC),R2(E),R3(DB) } C: ρ={ R1(AC),R2(ED),R3(AB) } D: ρ={ R1(ABC),R2(ED),R3(ACE) }
- 关系模式R(U,F),其中U={A,B,C,D,E},F={AC→E,E→D,A→B,B→D}。关系模式R的候选键是 (45) , (46) 是无损连接并保持函数依赖的分解。 (46)处填()。 A: ρ={R1(A,R2(E,R3(A} B: ρ={R1(AB,R2(E,R3(AC} C: ρ={R1(AB,R2(E,R3(A} D: ρ={R1(AC,R2(E,R3(A}
- 设α,β,r1,r2,r3都是4维向量,A=(α,r1,r2,r3),B=(β,r1,2r2,3r3),如果已知|A|=2,|B|=1,求出|A+B|的值
- A.ρ={R1(AC),R2(ED),R3(B)}B.ρ={R1(AC),R2(E),R3(DB)}C.ρ={R1(AC),R2(ED),R3(AB)}D.ρ={R1(ABC A: ρ={R1(AC),R2(ED),R3(B)} B: ρ={R1(AC),R2(E),R3(DB)} C: ρ={R1(AC),R2(ED),R3(AB)} D: ρ={R1(ABC),R2(ED),R3(ACE)}