南京航空航天大学2015年数据库原理及应用考研真题.pdf
S “ S “ o #: :2t bt?v M V 3 I k k k5 “ S “ S “ o # s si s5 i Y sAs5 k5 (r k5 s5B k5 Baes5105 5 6s 60s 1a k o“d ) T# I $ 2a k 1“ ?5bv I 9 V b$ I f /V b$i b 3aV jm uY “sY I $ 4a I o Hq$ Vs + ? 5a I o1i | eZE i | eZE$ B b 6a I 1 $ /V p/1“ Vr TT RT A,DS.B=T.B(ST) RV A B C a1 b1 c2 a2 b3 c7 a3 b4 c6 a1 b2 c3 SV A C a1 b2 c1 a2 b2 c3 a4 b6 c6 a1 b1 c2 a3 b4 c6 TV B C D b1 c2 d4 b2 c1 d1 b2 c3 d2 7a o“d) B ZE$i B b 8a k B5b 9a I $ +$ k clb 10a Y#p$“d#p$#p$ =as535 90s 1at b 5 “d 30s t b vfq Supplier Supplier H Vf “Project4 Product q V 4$ “ P “ V P 4 b1“ / S(SNO, SNAME, SCITY) P(PNO, PNAME, COLOR, WEIGHT) J(JNO, JNAME, JCITY) S “ S “ o #: :SPJ(SNO, PNP, JNO, QTY) S V U GQ |a g P V U ,q GQ ,q|a ,q a ,q ,q J V U “ GQ “|a “ “ g SPJV U 1“ GQ |a ,q|a “| b h /1 p_ PL / 3 ,q “| k SQL 1“ Vr Tb 5s k1“ Vr Tb 5s S1“ Vr TE b (10 s ) P EE iE b (10 s ) 2a 3 “d30s 3 o VsY 3V Sa V C 3 V SC / U S(SNO, SNAME, SDEPT, SAGE) C(SC, CNAME, TEACHER) SC(SNO, CNO, GRADE) SNO| SNAME 3 SDEPT “ SAGE M - CNO | CNAME TEACHER = GRADEb/LV U1“1o3 SC SNO CNO9 v S C1o3b h 1“ SQLl b (10 s ) 1 p “ SBF H1“ SC M SNO F “5 SC l 1 p S SNO H SCM SNO915 SC b (10 s ) !9B(? P SC H1 p ?l 0b(10 s ) 3a0 “d 30s 0 E Supplier V5 Ia w0a Q v Module4 Product V 4$5 v P 5 v V P 4 b 5 vI|MID#a5 Jnamea5 Description I|P#a Pnamea Colora Weight EI|S# Snamea Address N1Q B5 v P Total4 Amountb h sY !9o E po5 v p1“ ER b 10s | ER 1“ b 10s !9 3b 10s