《数据库系统概论_期末考试复习题(附答案)》

《《数据库系统概论_期末考试复习题(附答案)》》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

ᦪ
ᭆ2011ὃ⚪ஹ⌱⚪•(1)(3)⚪Ḅᨵᐵ"#A(C,T,H,R,S),$ᔜ&ឋḄ()*C+,TᦟᕒH/+01Rᦟ2S34•᪷
6)ᨵ᝞8ᦪ9:;F={CfT,(H,R)-C,(H,T)fR,(H,S)-R}•1ஹᐵ"#AḄṹ*(D)•A.CB.(H,R)C.(H,T)D.H,S)•2ஹᐵ"#AḄ=ᓄ,@ᨬBCᑮ(B)•A.1NFB.2NFC.3NFD.BCNF3ஹEFᐵ"#AᑖHIJKᐵ"#A1(C,T),A2(H,R,S),ᑣᐸ$A1Ḅ=ᓄ,@Cᑮ(D)•A.1NFB.2NFC.3NFD.BCNF•4.OᨵᐵR(A,B,C)PS(C,D)oQSQL6R•selectA,B,DfromR,SwhereR.C=S.C•STḄᐵUᦪ⊤C#*(B)•A.oR.C=S.C(nA,B,D(RXS))•B.“A,B,D(஺R,C=S.C(RXS))•C.oR.C=S.C((nA,BR)X(nDS))-D.஺R,C=S.C(nD((“A,BR)XS)•5ஹOᐵRPᐵSḄᐗᦪᑖY*3P4,ᐵT*RQSḄZ)[ᓱ]^_ᓽT=RXS,ᑣᐵTḄᐗᦪ*(C)•A.7B.9C.12D.166ஹᦪ
Oa▤cᑖI(B)•A.ᱥᳮOa▤cஹfgOa▤cஹh,Pi▤c•B.ᭆjOa▤cஹfgOa▤cஹᱥᳮOa▤cஹklPi▤c•C.mᫀOa▤cஹopOa▤cஹKYOaPh,▤c•D."qOa▤cஹ,rOa▤cPst▤c•7ஹOU*ᡠᨵ&ឋḄ;ᔠ_XஹYஹZw*UḄx;_yZ=U-X-Y஺☢ᐵ{|9:Ḅ$_}~Ḅ*(C)•A.X--Y,ᑣX--ZB.X-_ᑣX-YC.X--►_yY'UY,ᑣX—-'D.Z=SᑣX--Y8ஹᓄᶍ$_~Ḅᶍ*(D)A.ᙢ᡻t[ᓱ]^B.ᙢ᡻tC.ᙢ᡻tD.ᙢ᡻t⌱•9ஹ6Rdeletefromsc⊤(A)A.ᑤ◀sc$ḄᐰB.ᑤ◀⊤scC.ᑤ◀⊤sc$Ḅᑡᦪ
D.ᑤ◀⊤sc$Ḅᑖt•10ஹᙠDBᵨ$_ᩩSQL6R4ᡈᜐᳮ£_¤DB¥6¦6R§¨ᜐᳮᩩ_ᐸ©iª«¬ᢈ¯kE(B)•A.ᢣ┐B.²᪗C.ᦪ£D.᪘11ஹµᐵUᦪs¶*(A)•A.U,X,JTP஺B.U,X,JTP஺•C.u,n,x,JiP஺D.u,n,x,JTP஺12ஹᑡ·ᔠ8ᦪ$}¸ᶍ¹|(null)Ḅ*(C)•A.SUM(ᑡº)B.MAX(ᑡº)•C.COUNT(*)D.AVG(ᑡº)•13ஹᙠᦪ
Oa$_FER¼½ᣚᡂᐵᦪ
"qḄ«,&(B)•A.◤Áᑖ᪆▤cB.fgOa▤cC.ᭆjOa▤cD.ᱥᳮOa▤c(14)(16)⚪*᝞JKᐵ_ᐸ$ÃᕒÄÅ⊤ᐵEMPḄ¥Æ*ÃᕒÇ_ÈÄÅ⊤ᐵDEPTḄ¥Æ*ÈÇ஺

1ÃᕒÇÃᕒºÈÉÊÈÇȺᙢᙬ1,1001Ëill02200001ÒÓ1ÇÔ010/ÌC01120002├Ö2ÇÔ056Í᪍402100003×Ó3ÇÔ101ÏÐ04150004ØÓ4ÇÔ•14.᡻t☢ᑡÙḄ_¬K}ᡂÚ᡻tÛÜD•A.ÝEMP$ᑤ◀t
'010','ÞÌC','01',1200•B.ᙠEMP$ßᐭt
'102','ÏÐ,'01',1500•C.FEMP$ÃᕒÇ=’056’ḄÉÊᦋI1600ᐗ•D.FEMP$ÃᕒÇ='101'ḄÈÇᦋI‘05'•15ஹ᡻t☢ᑡÙḄ_¬K}ᡂÚ᡻tÛÜC•A.ÝDEPT$ᑤ◀ÈÇ='03'ḄtB.ᙠDEPT$ßᐭtÜ'06','aᑜ'_'6ÇÔ'æ•C.FDEPT$ÈÇ='02'ḄÈÇᦋI‘10'•D.FDEPT$ÈÇ='01'ḄᙢᙬᦋI‘5ÇÔ’16ஹᙠÃᕒÄÅ⊤ᐵEMP$_¬K&ឋ*᜜Æ
foreignkey?
CA.ÃᕒÇB.ÃᕒºC.ÈÇD.ÉÊ•17ஹᙠSQL6¦ḄSELECT6R$_kEᢗéḄ*¬KxRÛÜA•A.selectB.fromC.WhereD.groupby•18ஹO&ឋA*ᐵRḄ¥&ឋ_ᑣ&ឋA}ê¹|ÜNULL஺ë*ÜA•A.kpì᦮ឋ=ᑣB.î᯿ì᦮ឋ=ᑣ•C.ᵨᡝñ)ì᦮ឋ=ᑣD.òì᦮ឋ=ᑣó¹⚪•1ஹᵨ᪛qõ᪀⊤÷kpøqùkp1ὶḄᦪ
"qûIü§"q஺•2ஹᐵᦪ
Ḅᐵý¶6¦*ªþ¶IẠḄDML
஺•3ஹᦪᳮᦪᵨ᪀ᓽᦪᵫᑁஹ᜜ᡂ஺•4ஹRDMBS"#ᜐᳮ%ᑖ'"#ᑖ᪆ஹ"#)"ஹ"#*ᓄ"#᡻-./▤1஺•5ஹᭆ3᪀456789:;Ḅ<=>?<@ᨵᑖ᪆ஹBCஹᭆDᐳ=>?Fᑴ஺•6ஹᱥᳮ*ᓄI6⌕⌱LMᦔᔠᳮḄPQRSᡈUVWXYZ[*ᓄḄ"#5ᑜ஺•7ஹ]◤Zᑖ᪆[ᑮḄᵨᡝ◤Z>?'ab᪀ᓽᭆ3cḄdeI6ᭆ3᪀45ᭆ3᪀45ᨵ.fgShi⚔ᔣlஹimᔣnஹ⌲p᡽rsᔠtᶍ஺•8ஹᙠᐵRvU,FxyzUᙠ{᪵ḄṹX,~ឋY~ឋZ
Zz6YḄC[X-Y-Zᡂᨴ.X,ᑣRG3NF஺⚪1ஹᦪeḄᱥᳮឋᦪeḄឋ'ᦪᐹᨵᦪeḄឋhᦪeḄឋhᦋ᝞¡Ḅᐵஹ¡Ḅ~ឋஹᦋ~ឋḄᦪfc¢,ᵫᦪᳮᕒ7ᔜ/᜜/Ḅ᧜¨©ª«ᦋ%Y᜜¬ᢝz஺«ᵨe6®ᦪḄ᜜¯ᑏḄ±«ᵨez²³ᦋ¬´µᦪeḄឋᦪḄឋ஺ᦪeḄᱥᳮឋhᦪḄU¶᪀ᦋµᵫᦪᳮᕒ7/ᑁ᧜¨©ª«ᦋ%Y¬ᢝz±«ᵨe·z²ᦋ¬´µᦪeḄᱥᳮឋᦪḄᱥᳮឋ஺ᦪᳮᙠ¸¹º»Ḅ¼½᧜¨¬´µᦪxḄᦪ¾¿ᐹᨵÀMḄឋᱥᳮឋ஺2ஹᦪḄÁ᦮ឋᭆ3ᦪḄÃᐰឋᭆ3ᨵÅÆὶ:ᦪḄÁ᦮ឋÃᐰឋ6¼/zÉḄᭆ3Ê6ᨵ<ËḄὶ஺Ìὅ6'µ■ÏᦪxUᙠzÐ

2ᔠ
ÒḄᦪ■Ï┯ÔabḄÕᐭÕ×ᓽᡠÙᚗÛÜᚗÛ×Garba:eInGarba:eoutᡠ⌼ᡂḄÞᦔPQ┯Ôß஺àὅ6¬áᦪ■ÏូãḄẚåSḄUV஺·I6æÃᐰឋçèḄ■7?6SᵨᡝSPQÁ᦮ឋçèḄ■7?6zᔠ
ÒḄᦪ஺•3ஹêë×ìí®îஹ4NFḄËÒ஺•4ஹêë×ïᦪ®îஹBCNFḄËÒ஺•5ஹðñᐭSQL
òó
¸¹Ḅa஺✌ᐜᵨSQLaÅSQLCommunicationArea,SQLCAᔣó
ö⌴SQL
òḄ᡻-ø᝱abó
¾¿úûᑴeüeýᙠeþ-xó
ᔣSQL
òº»ÿᦪ
ᵨhostvariableᐭᦪ
SQLᦪḄᜐᳮ
ᐸᵨ!"᪗cursorᔣ%ᦪ
&'()*SQLḄ,ᓄ./஺SQL᡻23
45⌕7✄9:ᵨ;<=>
⌕ᒹ@AB45CD./E᝱!G2H᛻ḄᔜKᦪ
LM=>N〈ᑮSQLQ=RSQLCA஺:ᵨ&SQLCAS%LME᝱=>
TUVWXᩭ᡻2Ḅ஺•6ஹ[BRDBMS\ᓄḄ]^஺
1_`ᣚᡂcKᑁe⊤g
QhᵨḄᑁe⊤gij᪛஺l2_j᪛`ᣚᡂ᪗ml\ᓄ_no஺ᓽᑭᵨ\ᓄrj
stḄj᪛`ᣚᡂ\ᓄḄno஺l3_⌱vwxḄySz{஺l4_|ᡂ}ᑜ
⌱vᨬḄ஺7ஹ[BRDBMS\ᓄḄ]mᑣ஺X☢Ḅ\ᓄᶍ]ᦔ᳛l1⌱vGr:ᐜl2ᢗGr!⌱vGr2l3_ᢗᐸDᡈᐸ3ḄGrᔠᩭ᡻2l4_cM⌱vᙠD☢⌕᡻2Ḅᓱᔠᩭᡂ¡WGrl5_¢%£ᐳ¥⊤¦ol6_⌱Sᔠ〉Ḅ¡Wrj஺8ஹ¨©iᦪḄª«᪀}®[Bᐸ}^஺ᦪḄª«᪀}¯iᭆ±᪀}▤³}´Ḅµ¶E-R·`ᣚ¸⌱ᵨḄDBMS¹ºᡠ¼ᢝḄᦪ¾¿ÀÁᔠḄª«᪀஺}^l1_Nᭆ±᪀`ᣚ]Ḅᐵ4ஹÃEஹxľ¿l2N`ᣚᩭḄᐵ4ஹÃEஹxľ¿ᔣᱯVDBMS¼ᢝXḄᦪ¾¿`ᣚl3_Æᦪ¾¿2\ᓄ஺9ஹᦪÇᐺḄᑁÉ!/ᵨi¨©®ᦪÇᐺi45ᔜÊᦪABḄËᔠ஺ᦪÇᐺḄᑁÉQhᒹ@l1_ᦪ⚗l2_ᦪ᪀l3_ᦪÍl4_ᦪyÎl5ᜐᳮ,Ïeᑖ஺ᐸᦪ⚗iᦪḄᨬÑᡂᓫÓ
;<ᦪ⚗ÔÑᡂᦪ᪀஺ᦪÇᐺQ,Æᦪ⚗!ᦪ᪀ḄVÕᩭABᦪÍ!ᦪyÎḄª«ᑁÉ஺ᦪÇᐺḄ/ᵨᦪÇᐺiᐵÖᦪᦪḄAB
ᙠ◤Øᑖ᪆▤³ÚÛ
iX2ᭆ±}ḄµẠ
Ýᙠᦪ},Þßàᦋஹᐙ(ஹãä஺}⚪1ஹæᨵèᐵ4¾oé.lé.ê,ìí,îï
éð
.ñ
eòê_Person
pno,pname,page,ptitle,psal,dnoeòleòê
íó
ôᳮí
ᙢᙬ
ᵯøê_Depart
dno,dname,dmanager,daddress,dtelùᵨSQLḄGRANT!REVOKElúûü·ýᑴ_ãᡂÔXᣴᩗ
ᡈᑴপᵨᡝyong⊤ᨵINSERTDELETEᩗ஺GRANTINSERT,DELETEONPerson,DepartTOyong
2ᵨᡝliu⊤ᨵSELECTᩗᐹᨵᩗ஺GRANTSELECT,UPDATEpsalONPersonTOliuবᵨᡝzhangᐹᨵᦋ"⊤Ḅ$᪀Ḅᩗ஺GRANTALTERTABLEONPerson,DepartTOzhang;
4ᵨᡝyangᐹᨵ&'()*SELECTᨬ,ஹᨬ.ஹ/ᙳḄᩗ1234'5

3Ḅ7ᐹᨵ8ᐸ1ᵨᡝᣴᩗḄᩗ஺CREATEVIEWpsalASSELECTDepart,dname,MAX(psal),MIN(psal),AVG(psal)FROMPerson,DepartWHEREPerson.dno=Depart.dnoGROUPBYPerson,dnoGRANTSELECTONpsalTOyangwithgrantoption;(5)g├ᔜᵨᡝyangᡠᣴkḄᩗREVOKEALLPRIVILIGESONPerson,DepartFROMYANG;2ஹᎷnᨵo☢ᐵrst(uvwxyz()u)ᐸ*u{|ṹ~()(()uwᳮwᵯ)ᐸ*()u{|ṹ஺ᵨSQL
"ᐵrst⌕ᙠst*ᡂo᦮ឋᩩḄ

'stḄ|ṹ~
᯿᦮ឋ~
xy260஺CREATETABLEDEPT(DeptnoNUMBER(2),DeptnameVARCHAR(IO),ManagerVARCHAR(10),PhoneNumberChar(12)CONSTRAINTPK_SCRIMARYKEY(Deptno));CREATETABLEEMP(EmpnoNUMBER(4),EnameVARCHAR(10),AgeNUMBER(2),CONSTRAINTClCHECK(Aage<=60),JobVARCHAR(9),SalNUMBER(7,2),DeptnoNUMBER(2),CONSTRAINTFK_DEPTN0FOREIGNKEY(Deptno)REFFERENCESDEPT(Deptno));•3ஹn¥ᖪ§¨©ᐵªᖪ«├¬ᖪḄᦪ¯°*ᨵ±²³⊤•ᖪ«SHOP(S#,SNAME,AREA,MGR_NAME)ᐸµឋ¶ᖪ«·uᖪ«w¸¹wᳮvw஺├¬SALE(S#,G#,QUANTITY)ᐸµឋ¶ᖪ«·uᖪ·u├¬ᦪº஺ᖪGOODS(G#,GNAME,PRICE)•ᐸµឋ¶ᖪ·uᖪwᓫ¼஺•(1)½ᑏ¿oᑡ3ÁḄᐵrÂᦪ⊤ÃtஹᐗÅ⊤ÃtᐵrÆÇÈᑣÊË├¬“ÍΔḄᖪ«Ḅ·uᖪ«w஺ÐᐵrÂᦪ⊤ÃtnS#,SNAME(஺GNAME='ÍÎ’(SH0P^SALE>

4ᐗÅᐰ(ᑤ◀஺ÐDELETEFROMSALEWHERES#IN(SELECTS#FROMSHOPWHERESNAME='èèᖪ«')ANDG#IN(SELECTG#FROMGOODSWHEREPRICE>1OOO)4(4)ᑏìí⌕¸¹w{“EAST”Ḅᖪ«î├¬ᖪḄᓫ¼2.ª100ᐗ஺ÐCREATEASSERTIONASSE8CHECK(100<=ALL(SELECTPRICEFROMSHOPA,SALEB,GOODSCWHEREA.S#=B.S#ANDB.G#=C.G#ANDAREA='EAST'))4ᡈCREATEASSERTIONASSE8CHECK(NOTEXISTS(SELECT*FROMSHOPA,SALEB,GOODSCWHEREA.S#=B.S#ANDB.G#=C.G#ANDAREA=*EAST'ANDPRICE<100))4•(5)½ᑏ¿oᑡåæḄSQLá•ïð¸¹w{“EAST”Ḅᡠᨵᖪ«├¬Ḅ'ìñᖪḄòᦪºò¼ó஺•⌕ôõ(G#,GNAME,SUM_QUANTITY,SUMìVALUE),ᐸµឋ{ᖪ·uஹᖪwஹ├¬ᦪºஹ├¬¼ó஺ÐSELECTC.G#,GNAME,SUM(QUANTITY)ASSUM_QUANTITY,PRICE*SUM(QUANTITY)ASSUM_VALUEFROMSHOPA,SALEB,GOODSCWHEREA.S#=B.S#ANDB.G#=C.G#ANDAREA='EAST"GROUPBYC.G#,GNAME4(öSELECT÷á*ḄµឋC.G#,GNAMEøᙠᑖÅ÷á*¿ú)4ஹûᨵìüýᦪ¯°þÿ
ᵨ᝕ᐘᑡḄ᪀஺D2M1>1

5
᝕ᐘ:5ஹ!✂ᦪ$%&ᦪ$%'()*▅ὅ-.ὅ/0ᒹ23.ὅ456ᙢᙬឋ:;<ᓫ>஺()?!ᨵ3!4!6Aὅ᱐C஺()?D*Ḅ!ᨵ.ὅ4ஹ*EFGHEF஺⌕J3KE—RLMᐸOᣚQᐵSTU஺V3ᐵSTUQ3.ὅW.ὅ456,ᙢᙬ,ឋ:!W!4!6Aὅ᱐Ca*!W.ὅ4!4*EF;<,ᓫ>aGHEFa•6ஹᨵSPJᦪ$%ᒹ2S,P,J,SPJbᐵSTc3\GᖪW\Gᖪdṹ\Gᖪ56\GᖪZ᝱\Gᖪᡠᙠ_`aS
SNO,SNAME,STATUS,CITY•ghWghdṹgh6i⁐kla

6•P(PNO,PNAME,COLOR-WEIGHT)•no⚗q(no⚗qdṹno⚗q6no⚗qᡠᙠ_`)•J(JNO,JNAME,CITY)•\Gtu(\Gᖪdṹghdṹno⚗qdṹ\Gᦪl)•SPJ(SNO,PNO,JNO,QTY)•
ᵨᐵSdᦪSQLvwxᡂzᑡ{|஺•(1)J\GnoJ1ghḄ\Gᖪ4ṹSNO3SELECTDISTSNOFROMSPJWHEREJNO=Jl'•(2)J\GnoJ1ghP1Ḅ\Gᖪ4ṹSNO3SELECTDISTSNOFROMSPJWHEREJNO='J1'ANDPNO='P1'4•(3)J\GnoJ1ghQ}⁐Ḅ\Gᖪ4ṹSNO3SELECTSNOFROMSPJ,PWHEREJNO='JI'ANDSPJPNO=PPNOANDCOLOR=A}'•(4)Jᨵᵨᜩ\GᖪḄ}⁐ghḄno4JNO3SELECTDISTJNOFROMSPJWHEREJNONOTIN(SELEJNOFROMSPJ,P,SWHERES.CITY=ᜩ'ANDCOLOR='}'ANDS.SNO=SPJ.SNOANDP.PNO=SPJ.PNO)4•(5)Jᵨ\GᖪS1ᡠ\GḄᐰghḄno4JNO3ᵫVFPᐕ{|ᝅM{|ᑖQAஹ{|S1\Gᖪ\GḄgh4SELECTDISTPNOFROMSPJWHERESNO='S1'(Pl,P2)4Bஹ{|noᵨPlghᵨP2gh஺SELECTJNOFROMSPJWHEREPNO=Pl'ANDJNOIN(SELECTJNOFROMSPJWHEREPNO='P2')4-7ஹᨵSPJᦪ$%ᒹ2S,P,J,SPJbᐵSTc3•\Gᖪ(\Gᖪdṹ\Gᖪ56\GᖪZ᝱\Gᖪᡠᙠ_`)•S(SNO,SNAME,STATUS,CITY)•gh(ghdṹgh6i⁐kl)•P(PNO,PNAME,COLORoWEIGHT)•no⚗q(no⚗qdṹno⚗q6no⚗qᡠᙠ_`)•J(JNO,JNAME,CITY)•\Gtu(\Gᖪdṹghdṹno⚗qdṹ\Gᦪl)•SPJ(SNO,PNO,JNO,QTY)•
ᵨSQLvwxᡂzᔜ⚗A3•(1)ᡠᨵ\GᖪḄ56ᡠᙠ_`஺SELECTSNAME,CITYFROMS•(2)ᡠᨵghḄ6ஹi⁐ஹkl஺SELECTPNAME,COLOR,WEIGHTFROMP•(3)ᵨ\GᖪS1ᡠ\GghḄno4ṹ஺SELECTDISTJNOFROMSPJWHERESNO=SI*•(4)no⚗qJ2ᵨḄᔜ¡ghḄ6¢ᐸᦪl஺SELECTPNAME,QTYFROMSPJ,PWHEREP.PNO=SPJ.PNOANDSPJ.JNO='J2'•(5)£¤ᔆᖪ\GḄᡠᨵgh4ṹ஺SELECTPNOFROMSPJ,SWHERES.SNO=SPJ.SNOANDCITY=£¤'C(6)ᵨ£¤ḄghḄno6஺SELECTJNAMEFROMSPJ,S,JWHERES.SNO=SPJ.SNOANDS.CITY='£¤'ANDJ.JNO=SPJ.JNO•(8)¦ᐰ}⁐ghḄi⁐ᦋᡂ¨⁐஺UPDATEPSETCOLOR©¨'WHERECOLOR='}'

7•(9)ᵫS5\KJ4ḄghP6ᦋQᵫS3\G஺UPDATESPJSETSNO='S3'WHERESNO='S5'ANDJNO='J4'ANDPNO='P6'(10)M(S2,J6,P4,200)ªᐭ\GtuᐵS஺INSERTINTOSPJVALUES('S2','J6','P4',200)¬ᔠ⚪ஹᎷ°ᖪ±²³ᦪ$%'ᨵᐵSTcR᝞z3•R(ᖪµ¶4ᖪ·¶4ᦪl¸¶4¹º»)•᝞¼½3•(1))ᖪµḄ)¡ᖪ·¾ᙠ¸├À•(2))ᖪµḄ)¸¾ᨵ¹º»•(3))ᖪµḄ)¡ᖪ·¾ᨵ%ᦪl஺•
ÁVzᑡÂ⚪3•(1)᪷$£Ä¼½ᑏᐵSTcRḄÆ?ÇᦪÈÉ(ᖪµ¶4ᖪ·¶4)-¸¶4(ᖪµ¶4ᖪ·¶4)ᦪl(ᖪµ¶4¸¶4)¹º»•(2)ᐵSTcRḄ᎛⌱ṹ᎛⌱ṹ(ᖪµ¶4ᖪ·¶4)•(3)
ÂᐵSTcRᨬÎÏÐÑᑮÓÔcÖQ×ØÖ1NF,ᙠᑖÇᦪÙ⌴ÇᦪÈÉ஺•(4)᝞RÛ3NF,MRᑖÜᡂ3NFTc²஺R1(ᖪµ¶4ᖪ·¶4ᖪ·%ᦪl¸¶4)R2(ᖪµ¶4¹º»)2ஹÝÞᐵSஹßஹàáஹßâãäåæḄᐵSᦪ$%஺ß3ß4ஹ56ஹ;ᨴஹS6ஹà4ஹèéê஺•àá3à4ஹë±6ஹS6ஹ»ᦪஹᐭ᪥;í஺•S3S6ஹS4ஹSîïᙢðஹ»ᦪ஺•ßâ3ßâ6ஹᡂÞ;íஹîïᙢðஹ»ᦪ஺•vñ᝞z3Sᨵòóë±)ë±);¾ôà)àᨵòóß஺SḄßõᙠöèéê஺)ß÷øùòóßâ)ßâᨵòóß஺ßøù°ßâᨵᐭâ;í஺•KᐵSTcᑏ)ᐵSTcḄ᩽ûÇᦪÈɲᢣᔲᙠÙ⌴ÇᦪÈÉ(ÇᦪÈÉþÿឋḄᦪᐰᦪᑖᦪ஺ᢣᔜᐵḄ᎛⌱ṹஹ᜜ṹᨵᨵᐰṹ!ᙠ#$%(1)ᐵ᝞'%()%S(Sno,Sname,Sbirth,Dept,Class,Rno)*+%C(Class,Pname,Dept,Cnum,Cyear)%D(Dept,Dno,Office,Dnum)(,%M(Mname,Myear,Maddr,Mnum)(2)-.ᐵḄᨬ0ᦪ1᝞'%Aஹ()S(Sno,Sname,Sbirth,Dept,Class,Rno)Ḅᨬ0ᦪ1᝞'%SnoSname,SnoSbirth,SnoClass,ClassDept,DEPTRno2⌴᝞'%ᵫ5SnoDept,6DeptSno,DeptRno(89:)ᡠ=Sno>Rno?@!ᙠḼ2⌴ᦪ஺ᵫ5ClassDept,DeptClass.DeptRnoᡠ=Class>Rno?@!ᙠḼ2⌴ᦪ஺

8ᵫ5SnoClass,ClassSno,ClassDeptᡠ=Sno>Dept?@!ᙠḼ2⌴ᦪ஺Bஹ*+CPClass,Pname,Dept,Cnum,CyearVḄᨬ0ᦪ1᝞'%ClassPname,ClassCnum,ClassCyear,PnameDept.ᵫ5ClassPname,PnameClass.PnameDeptᡠ=Class>Dept?@!ᙠḼ2⌴ᦪ஺CஹDPDept,Dno,Office,DnumVḄᨬ0ᦪ1᝞':DeptDno,DnoDept,DnoOffice,DnoDnum᪷^_`ᦪabDepl>Office,Dept>Dnum?@c!ᙠ2⌴஺Dஹ(,MPMname,Myear,Maddr,MnumVḄᨬ0ᦪ1᝞':MnameMyear,MnameMaddr,MnameMnumfc!ᙠ2⌴஺P3VᔜᐵḄ᎛⌱ṹஹ᜜ṹᐰṹ᝞'%Aஹ()S᎛⌱ṹ%Snoi᜜ṹ%DeptஹClassijᐰṹBஹ*+C᎛⌱ṹ%Classi᜜ṹ%DeptijᐰṹCஹD᎛⌱ṹ%DeptᡈDnoij᜜ṹijᐰṹDஹ(,M᎛⌱ṹ%Mnameij᜜ṹijᐰṹ•3ஹmᨵn.opᓄḄ⊤ᒹuv⚗xஹyzyᔣ⚗x|}~Ḅᦪ஺ᵨpᓄ,f⊤pᓄᑮ3NF⌕஺⚗x⚗xᑁ⚗x}~ᦪyymᨵᦪ12AAA0110205CAM3020BBB021512AAA0130210COG15525CCC112530DDD1215%⊤!ᙠḄᦪᐵ%ynyynmᨵᦪ⚗xf⚗xᑁ⚗x~⚗xP⚗xyVn}~ᦪ஺ᐵP⚗xyV஺P2ᑖV!ᙠᑖᦪ%P⚗xyVPnyP⚗xyVp~mᨵᦪP⚗xyVP-⚗xᑁP⚗xyVpf⚗x஺P1ᑖV◀ᑖᦪᑖ$ᑮ='Ḅ¡.ᐵ%yPyymᨵᦪV

9⚗xP⚗x⚗xᑁ⚗xV}~P⚗xy|}~ᦪVfᐵ¢ᑮ2NF஺ᵫ5c!ᙠ2⌴ᦪ£¢ᑮ3NF஺P3ᑖV•4ஹ¤¥ᑮ()ஹᦟ§z¨©ḄᐵSTC
SNo,SN,SA,TN,CN,G,ᐸ«6.ឋᑖ¬()Ḅ(ஹஹ®¯ஹᦟ§Ḅஹ¨©=¥()Ḅᡂ±஺Ꮇ³()ᨵ´¨©£aµᨵ´஺¶Ꮇ³-.ᦟ§·ᦟn¸¨¹n¸¨aᨵº.ᦟ§»³஺¼½.()⌱¾½¸¨¿ᐸ_¨ᦟ§ÀÁ¾v஺•
1ᑏṹzᦪi•P2ᑖ$ᐵÃ?5BC஺%1Vṹ:{SNo,CN}z{SNo,TN}ᦪ%SNo—►SN,SAPBCÈÉVTN—►CNPBCÈÉVSNo,CN—►TN,Ga)SNo,CË►SN,SASNo,TN—►Gb)SNo,TN-^CNc)SNo,SN,SAPa,b,cᑖacᑏV2)STC1(SNo,SN,SA)STC2(TN,CN)STC3(SNo,TN,G)nஹᓫ⚗⌱Ï⚪PÑᜧ⚪ᐳ100⚪ᐳ30ᑖV1.ᦪ^Ô«ᦪ^Ḅᱥᳮ×ØឋᢣPV□

10A.ᦪ^Ô>ᦪ^ÔÚᳮÛḄÜÝ×ØB.ᵨᡝ©ß>DBMSḄÜÝ×ØC.ᵨᡝḄàᵨ©ß>!áᙠâã_ᦪ^Ô«Ḅᦪ^ÜÝ×ØḄD.àᵨ©ß>ᦪ^Ô«Ḅᦪ^Ḅäåæ᪀ÜÝ×Ø2.èE-Réᐵᔣᐵêᣚìn.M%NὶêᣚᐵìfᐵḄᐵîA.MïðñḄᐵîB.NïðñḄᐵî)C.Mïðñᐵî>NïðñᐵîòᔠD.´ô⌱õᐸöឋ3.÷øᦪ^Ô■úoûᣴᩗḄᡈcᔠḄÃᵨ⌼ᡂḄÿᧇ
ஹᦋẚ஺ᢣᦪḄA.ᐰឋB.᦮ឋC.ᑴD.ឮ4.ᐵḄᔜ"#$Ḅᐵ%஺A.3NF2NF1NFB.3NF1NF2NFC.1NF2NF3NFD.2NF1NF3NF5.'()*ᐵ+ᦪ,-)A.U,x,TT.஺B.U,8,JT.஺C.U,A,X,TT.OD.U,A,8,rr.஺6.ᙠᦪ01234ER56ᣚᡂᐵᦪ9Ḅ:;<=()A.◤?ᑖ᪆▤CB.DE12▤CC.ᭆG12▤CD.ᱥᳮ12▤C7.SQL3JᑡLMNOḄPQ3RSTḄA.AGEISNULLB.AGEISNOTNULLC.AGE=NULLD.NOT(AGEISNULL)8.ᐵᦪ0Vᓄ%YZᐵᦪ0[⚪]^ᐭḄ஺A.`ᐭஹᑤ◀.ᦪᑍdB.efghijC.klᦪPQḄᩖឋD.noᦪḄᐰឋ.᦮ឋpஹqN⚪*ᜧ⚪ᐳ5t⚪3uN1ᑖ3ᐳ10ᑖ1.v=wVᓄḄ3x:y<ឋz{%|ᓫz6{%1NF,41NF~:◀w<ឋvṹḄ.6{%2NF,42NF~:◀w<ឋvṹḄ.6{%3NF஺2.ᙠᐵA
S,SN,D.B
D,CN,NM3AḄS,BḄD,ᑣDᙠS%3.ᦪ9ᵫஹ.ᑖᡂḄ஺4.ᦪ0x᪀ᢥ᯿ஹ.x᪀஺5.E—R5ᔣᐵ96ᓄ⌕YZḄ[⚪᝞4.#$Ḅὶ6ᣚᡂᐵ3᝞TᐵḄ஺ஹ2-⚪*ᜧ⚪ᐳ5t⚪3ut⚪2ᑖ3ᐳ10ᑖ

111ᨵ᝞J5ᡠḄᐵR,S.T,2-পR1=RUSRST(2)R2=R-SবR3=RT(4)R4=RTমR5=ஹ12⚪(*ᜧ⚪ᐳ5t⚪3ut⚪4ᑖ3ᐳ20ᑖ)1ᦟ¤ᦪ0ᨵ¥)*⊤¤§⊤S(SNO,SNAME,SEX,AGE,DEPT)¨;⊤C(CNO,CNAME,TEACHER)¤§⌱¨⊤SC(SNO,CNO,GRADE)ᐸSNO%¤«3SNAME%¬3SEX%ឋ®3AGE%¯°3DEPT%®3CNO%¨;CNAME%¨;3TEACHER±¨ὁ³3GRADE%ᡂ´஺µᑏ·JᑡPQḄSQL¸¹1º»¤§¬Mᐸᡠ⌱¼¨;«.ᡂ´஺2º»⌱¼¨;“C2”Ḅ¤§Ḅᨬfᡂ´஺3º»ᡠᨵ¾“ÀÁ”¯°ᜧḄ¤§¬ஹ¯°.ឋ®஺4º»⌱¼ÃÄŨ;Ḅ¤§Æᡂ´(RÇ2RMÈḄ¨;)3⌕?ᢥÆᡂ´ḄÉÊ᣸ᑡ·ᩭ஺5ÍWuὁ³Ḅ᝕Ϥ⌱¨ᡂ´ÐÑ5%'ஹÒᔠ⚪(*ᜧ⚪ᐳ2t⚪3ut⚪15ᑖ3ᐳ30ᑖ)1.Ꮇ1Õᖪ×ØÙᦪ0ᨵÚᐵR᝞JR(ᖪÛÜ«3ᖪÝÜ«3ᦪÞ3ÃÜ«3ßàá)᝞âV(1)u¥ᖪÛḄu(ᖪÝãᙠÚ¥Ã├åæ(2)u¥ᖪÛḄu¥ÃãᨵÚ¥ßàáæ(3)u¥ᖪÛḄu(ᖪÝãᨵÚ¥0çᦪÞ஺µèéJᑡ[⚪(1)᪷ÅëV3ᑏ·ᐵRḄ)*ìᦪíîæ(2)ï·ᐵRḄ᎛⌱ṹæ(3)µ[ᐵRᨬfñ~òᑮôõö%÷øö(4)᝞âRR<=3NF,ù4RᑖYᡂ3NFØ஺2.ᎷÚ¥ÃḄᦪ0ᒹûÄJḄüý:

12ÿḄஹஹᙬᡠᙠ஺Ḅᡠᨵஹᳮ├Ḅ஺Ḅஹᑴ⌼ᖪஹஹᑁ!஺ᑴ⌼ᖪḄᑴ⌼ᖪ"ஹᙢᙬஹ$Ḅ஺%ᡂ᝞()*(1))*.*/01ᳮ23ḄE-R78(2)ᑏ;ᐵ2=>?@Aᵨ(ᑜDEFD᪗H;IJ=>ḄKṹ᜜ṹ஺(3)ᙠOPᦪRST@ᑏ;Kṹ᜜ṹḄUᦪVWJᦪX஺

13ᦪ
ᭆᧇ123Z⌱\⚪1.ᙠᦪR1ᳮᢈ`ḄabcdT@ᔊfg1ᳮ▤iஹᦻk23▤iᦪRS23▤i஺ᙠVlJ▤iT@ᦪRmnឋᨬqḄr▤i஺A.ᦪRS23B.ᦻk23C.g1ᳮD.ᦪR⚗1ᳮᫀA2.ᦪRSḄᭆy=mnz________________________oA.ᐹ~Ḅ0ᘤDBMSB.E-R7C.D.ᫀA3.ᦪRSḄᱯr____________________oA.1ᦪRᐳᡈᦪR᪀ᓄ2ᦪRmnឋ3ᦪRᑍᜧ@᧕43Z1ᳮᑴB.1ᦪRᐳᡈᦪR᪀ᓄ2ᦪRmnឋ3ᦪRᑍ@᧕᡽ᐙ43Z1ᳮᑴC.1ᦪRᐳᡈᦪR᪀ᓄ2ᦪR¡ᣚឋ3ᦪRᑍ@᧕᡽ᐙ(4)3Z1ᳮᑴD.1ᦪR£᪀ᓄ2ᦪRmnឋ3ᦪRᑍ@᧕᡽ᐙ(4)3Z1ᳮᑴᫀB4._________________r¤¥ᙠ*/0ᑁᨵ᪀ḄᦪRḄ?ᔠ஺A.ᦪRS23B.ᦪRSC.ᦪRS1ᳮ23D.ᦪR᪀ᫀ5.ᦪRST¤¥Ḅr.A.ᦪRB.ᦪR=C.ᦪRᦪR¨©Ḅὶ2D.ᫀc6.ᦪRST@ᦪRḄᱥᳮmnឋrᢣ____________________஺A.ᦪRS¯ᦪRS1ᳮ23Ḅ°¡mnB.ᵨᡝd²¯DBMSḄ°¡mnC.ᵨᡝḄ³ᵨd²¯¤¥ᙠ´µOᦪRSTḄᦪRr°¡mnḄD.³ᵨd²¯ᦪRSTᦪRḄ¶·᪀°¡mnᫀC7..ᦪRSḄᱯ¨ZrᦪRḄᐳ@¹ᙢº@V»ḄᦪRᐳrᢣ஺A.¼ZJ³ᵨTḄ½Jd²ᐳZJᦪR?ᔠB.½Jᵨᡝஹ¼Z¾¿ÀᐳᦪRC.½JᵨᡝᐳZJᦪRᦻkD.½¾³ᵨஹ½¾¿Àஹ½Jᵨᡝ°¡⌚ÂᙢÃᵨᦪR?ᔠᫀD8.RS23Ḅ᪶ÆroA.ᦪRSB.ᦪRS1ᳮ23C.ᦪR=D.Çkᐹ

14ᫀB9.(PᐵzᦪRS23ḄÉÊËProA.ᦪRS23ÌÍfᦪRᑍB.ᦪRS23ÎÏfZᑗᑍC.ᦪRS23TᦪRḄZÑឋrᢣᦪRÒZÑD.ᦪRS23Óᦻk23Ô1ᳮÕ½ḄᦪRᫀA10.ᦪ×ᦪRSḄ᪀ᑜᑖᡂ½JÙÚ@rÛfÜqᦪRSḄজঝ஺জA.ᦪRmnឋB.¶·mnឋC.1ᳮßឋD.ᦪRḄᐳঝA.ᦪRmnឋB.ᱥᳮmnឋC.¶·mnឋD.1ᳮßឋᫀজBঝB11.ᦪRS(DB)ஹᦪRS23(DBS)ᦪRS1ᳮ23(DBMS)áὅ¨©Ḅᐵ2r஺A.DBSᒹäDBDBMSB.DDMSᒹäDBDBSC.DBᒹäDBSDBMSD.DBSårDB,çårDBMSᫀA12.ᙠᦪRST@$ᦪRèZÑḄ᪷êër஺A.ᦪR¤¥ìíᜧB.îᨵ¹ïðᦪRC.ñòᦪRóô%᦮ឋᑴD.ᦪRᑍᫀD13.ᦪRS1ᳮ23(DBMS)roA.ᦪöÇkB.³ᵨÇkC.*/0÷ø)*D.23ÇkᫀD14.ᦪRS1ᳮ23(DBMS)ḄK⌕úÔrA.ûᦋᦪRSB.ýþᦪRSC.³ᵨᦪRSD.ïðᦪRSᫀB15.ᦪRS23ḄᱯrஹᦪRmnஹÌÍᦪRᑍஹÎÏᦪRèZÑÿ
ᦪ஺A.ᦪᐳB.ᦪC.ᦪᵨD.ᦪᫀA16Ḅᨬᜧᱯ!oA.ᦪḄ#$%&'($)*ឋB.ᦪᐳឋC.ᦪḄ,᪀ᓄD.ᦪ)*ឋᫀA17.ᦪ0ᳮ2345ᦪ6ᦪḄ78ஹ:ᐭஹ<ᦋ'ᑤ◀@ABCDEF2GH஺A.ᦪIJF2B.ᦪ0ᳮF2C.ᦪAKF2D.ᦪLᑴF2ᫀC18.ᦪ0ᳮ!oA.ABḄOPᑖB.ᙠABSᢝUḄVWC.OEXYZ[D.OEABᫀB19.Ḅ#$]^,᪀6C_`ᦪ6ᐰbᦪḄᐰcde,᪀'ᱯfḄ!()A.᜜]^B.ᑁ]^C.]^D.]^ᫀD

1520Ḅᦪ)*ឋ!ᢣ஺A.nopHᦪḄqᓄrstᵨZ[B.nopHᦪ,᪀uᦪde,᪀ḄqᓄrstᵨZ[C.nopHvᶍḄqᓄrst,᪀D.nopHxy,᪀Ḅqᓄrstᐸ{Ḅ,᪀ᫀB21.|}~6ḄCu5ḄᦪHoA.ᦻWB.ᦪC.D.ᫀD22ஹ'ᐵᦪᑜᑖᑣ!஺A.B.ᦻWḄᜧC.ὶḄᩖZD.ᦪḄὶᫀD23.Ḅᦪ]ᑖCᦪᑖH#EoA.ᜧஹ6'B.ᦻஹ6ᦻ'C.ஹ'ᐵD.ᦪஹ¡'¢£bᫀC24.]n2¥¦⊤¨oA.11ᐵB.1mᐵC.mnᐵD.11'1mᐵᫀC25.ᦪᢈḄᝈ®¯OE.F.Codd³1970´µ¶⊤·¢¸¹ᦻCº⌕¹`Ḅ!஺A.ᦪ]B.ᦪ]C.ᐵᦪ]D.☢ᔣ5&ᦪ]ᫀC(ஹ¾¿⚪1.ᦪ0ᳮᢈÁᔊ
জஹঝ'ঞ#Æ▤஺ᫀজ¯È0ᳮঝᦻWঝᦪ2.ᦪ!ÉᙠÊËÌᑁஹᨵজḄஹঝḄᦪÎᔠ஺ᫀজÐÑঝᐳ3.DBMS!ᢣজÔ!ÕÖঝ'ঞḄO0ᳮVW஺ᫀ:জᦪ0ᳮঝᵨᡝঞAB4.ᦪ0ᳮḄº⌕F2ᨵজஹঝஹᦪḄÙÚ0ᳮ'ᦪḄÛ*ÜÝ@4ÆÞ☢஺ᫀজᦪIJF2ঝᦪAKF25.ᦪ)*ឋßᑖHজ'ঝ஺ᫀজdeᦪ)*ឋঝᱥᳮᦪ)*ឋ6.áᦪḄᱥᳮᦋq
CᵨZ[nqCrᵫDBMSᜐᳮDEᦋqCD!ᢣᦪḄoᫀᱥᳮ)*ឋ

167.ᦪ]!ᵫজஹঝ'ঞ#PᑖÐᡂḄ஺ᫀজᦪ,᪀ঝᦪABঞå᦮ឋçè8.জ!5ᦪḄ☟᝱ᱯឋḄ_`,ঝ!5ᦪḄì᝱ᱯឋḄ_`஺ᫀজᦪ,᪀ঝᦪAB9.ᦪb,᪀ᢥ᯿জஹঝ'ঞ#$,᪀ïÚÐÑ஺ᫀজ]^ঝ᜜]^ঞᑁ]^10.3bḄὶ%&H#CÔð!জஹঝ'ঞ஺ᫀজ11ঝ1mঝm:n11.ᦪᑍò2óôḄõ⚪ᨵজ'ঝ஺ᫀজö÷¿Ü<ᦋøùঝúᙠḄᦪnOôឋ#û⚪1.üý!ᦪþᦪ!ÉᙠÊËÌᑁஹᨵÐÑḄஹᐳḄᦪÎᔠ஺ᦪ!ᢥxEᦪ]ïÚÐÑḄஹÿᙠ᜜ᘤᵨᡝᵨ஺ᦪᐹᨵḄᑍḄᦪ!ឋ#᧕᡽&ឋ஺2.*+,ᦪḄᦪ!ឋ-./ᦪ!ឋ⊤12ᵨ345ᦪ6Ḅᦪ7ᙠ89ᐵ;ᒹ=>?ᦪ!ឋ#ᱥᳮᦪ!ឋ஺>?ᦪ!ឋ,ᢣCD>?ᦪE᪀G᜜HIᓽᵨᡝḄ>?ᦻLM5ᐰC>?ᦪE᪀GᭆPHIMQRḄ!ឋ஺SᦪḄᐰC>?ᦪE᪀GᭆPHIMTUVᓄGᦪXYḄZᦋஹᦪQRὶ;ḄV^ᡈ`abḄᦪcdeMf7ghijCDḄ>?E᪀Ḅឋk2ᵨ347lZᦋ஺ᱥᳮᦪ!ឋ,ᢣᦪḄE᪀5mnoGᑁHIMᦋVqᦪḄᐰC>?E᪀GᭆPHIM#2ᵨ347lrZᦋḄstᱯឋvw,xᦪᦪḄE᪀5mno!஺3.*+,ᦪzᳮ;{-:ᦪzᳮ;{GDBMSM,#zᳮᦪḄsLf,ᦪ;{GDBSMḄ⌕ᡂDᑖ஺7Ḅᦪ;{ᨵᔜḄDBMS,7ḄDBMSᔜᢝstᦪdᯠfḄ7ᜧᦪDBMSḄ᪀ᡂ஺sxᩭDBMSᐹᨵXYஹ!ஹ#ᵨᦪḄf¡¢ᵫ¤Dᑖ᪀ᡂ/ᦪ¥¦§¨©ᐸ«¬34ஹᦪ§¨©ᐸᜐᳮ34#ᦪzᳮḄ®¯34஺4.*+,ᦪ±ᐺ?ᦪ±ᐺᒹ´µj¶·ᑁ¸-./ᦪ±ᐺ,ᦪ;{6ᔜt¥¦¹º#»ᑴ¹ºḄ½ᔠf,ᦪ¿À5zᳮḄᨵÁÂᐹ,ïÄÅᦪᦈ½#ᦪᑖ᪆ᡠÉÊḄË⌕ᡂÌ஺ᦪ±ᐺḄ¶·ᑁ¸ᨵ/ᦪ⚗ஹᦪE᪀ஹᦪÎஹᦪ#ᜐᳮÏ35Dᑖ஺

17ÑsÒ⊡ᐙrÕDᑖ:Ꮇ¿ᦟÙzᳮÚX:জsÙU⌱ZÝÞsÝÞᨵßàÙU⌱ZáঝsᦟãäᣴÝÞsÝÞæᨵsᦟãäᣴáঞsÙU⌱ZsÝÞèᨵsᡂé஺ÙUḄêឋᨵÙëஹÙUìíáᦟãḄêឋᨵᦟãîëᦟãìíáÞ3ḄêឋᨵÞ3ëஹÞ3í஺⌕ï/᪷¦§YñòERI⌕ïᙠI6ñòõöḄêឋ÷øùὶ;Ḅcdá1Ñ2Òᐵ;ᦪsஹ⌱ú⚪1ஹᐵ;ᦪzᳮ;{2õýḄþÝᐵ;ÿᒹ஺A.᣸ஹஹB.⌱ஹᢗஹC.ᐵὶஹஹ᣸D.ஹᡭᓺஹᑴ⊤ᫀ"B2ஹᐵ$%&'()*ᐵ+,-oA./ᵫ1*234ឋ6ᡂB.81ᵫ)*4ឋ6ᡂC./ᵫ)*ᡈ1*ᐸ;<=)᪗?@ᐵ$%A'2Bᐗ6Ḅ4ឋ6ᡂD.EFGH-ᫀ"C3ஹJᯠ-᪀ᡂᐵ$ḄᨵᦔOP஺)RSTU(VWᐵ$RYS[ᵨJᯠ](⌕_RYS`ᨵ)*ᡈ1*ᐳᨵḄ஺A.ᐗ6B.bC.cdD.4ឋᫀ"D4ஹᐵ$f'gh]i/<ᨬkḄf-஺A.ᢗB.⌱C.lᓱnoD.◀ᫀ"C5.ᐵ$%AḄ2B4ឋoA.H/rᑖB./rᑖC.tuᙠ@ᐵ$%A'/EH=)D.EFGH-ᫀ"A

186.ᙠᐵ$wᦪf'(yz{|f}஺A.~ஹஹ⌱ஹᢗஹJᯠB.~ஹஹஹ⌱ஹᢗC.~ஹஹ⌱ஹᢗஹoD.~ஹஹஹ⌱ஹoᫀ"C7ஹᨵᐵ$R,ᢥᩩfWᐵ$Rb⌱(Ḅ-oA.RxRB.RX3RC.of(R)D.nf(R)Fᫀ"C8ஹ᝞ᡠ(*ᐵ$RIYR2,bfᑮR3஺R3ABCDEA1XMIC1YMIC2yNJA.B.~C.lᓱnoD.ᫀ"Dஹ⚪1ஹ)*ᐵ$%AḄA}oᫀ"ᐵ$u(4ឋu1,4ឋu2,…(4ឋun)2ஹ.)*ᐵ$%AḄ⌕ᒹজஹঝஹঞஹটYঠ஺ᫀ"জᐵ$uঝ4ឋuঞ4ឋ¡&ট4ឋk¢ঠᐵ+,3ஹ.ᐵ$wᦪf'(£Ḅ¤ᔠfᨵজஹঝஹঞYট஺ᫀ"জlᓱnoঝ~ঞট4ஹᐵ$wᦪf'({|Ḅf-জஹঝஹঞஹটYঠ஺ᫀ"জ~ঝঞlᓱnoটᢗঠ⌱5ஹᐵ$wᦪf'(¦§Ḅᐵ$fᨵজஹঝYঞ஺ᫀ"জ⌱ঝᢗঞ6ஹᐵ$ᦪ¨©'{ªᦪ«F¡f-জYঝ஺ᫀ"জᐵ$wᦪঝᐵ$

19¬7ஹ.®¯$($°±($u²($2(ᵯ´(ᙢ¶)Y«¸(«±(¹u(ឋº(ᐭ«¼½(¦¾($°±)*ᐵ$($ᐵ$Ḅᐵ+,-জ($ᐵ$Ḅ᜜ᐵ+,ঝ(«¸ᐵ$Ḅᐵ+,-ঞ(᜜ᐵ+,টᫀ"জ$°±ঝÀঞ«±ট$°±ÁஹÂᵨ⚪"ᨵ᝞UᡠḄᐵ$S(S#,SNAME,AGE,SEX)ஹC(C#,CNAME,TEACHER)YSC(S#,C#,GRADE),Ìᵨᐵ$wᦪ⊤ÍA⊤UᑡÏÐÑÒ"(1)Ô“Ö×”ὁÚᡠᣴÜÖḄÜÖ±(C#)YÜÖu(CNAME)஺(2)ÔÝÞᜧª21Ḅᵱ«¸«±(S#)Y¹u(SNAME)஺(3)Ô8á⌱â“Ö×”ὁÚᡠᣴᐰäÜÖḄ«¸¹u(SNAME)஺(4)Ô“åæ"è«H«ÜÖḄÜÖ±(C#)஺(5)Ô8á⌱â§ÜÖḄ«¸«±(S#)஺(6)Ôᐰ䫸G⌱âḄÜÖḄÜÖ±(C#)YÜÖu(CNAME)஺(7)Ô⌱âÜÖᒹ`“Ö×”ὁÚᡠᣴÜÖê)Ḅ«¸«±(S#)஺(8)Ô⌱âÜÖ±}klYk5Ḅ«¸«±(S#)o(9)Ô⌱âᐰäÜÖḄ«¸¹u(SNAME)o(10)Ô⌱âÜÖᒹ`«±}2Ḅ«¸ᡠâÜÖḄ«¸«±(S#)஺(11)Ô⌱âÜÖu}“CÑð”Ḅ«¸«±(S#)Y¹u(SNAME)஺ñ"|⚪ᔜ*ÏÐÑÒWÂḄᐵ$wᦪ⊤ÍA⊤᝞U"(1).nc#,CNAME(OTEACHER='Ö×'(0)(2).RS#,SNAME(oAGE>21ASEX=?,ᵱ”(0)(3).nSNAME(sM[HStt,C#(sc)+TIC#(஺TEACHER='Ö×'(C))]}(4).nc#(c)-nc#(oSNAME=''(S)XISC)(5).ns#(஺=ফW[5](SCXSC))(6).nc#,CNAME(CX(HS#,C#(sc)4-ns#(s)))(7).ns#(sexnc#(oTEACHER=''('(c)))(8).ns#,C#(sc)4-nC#(oC#=,kl'VC#='k5'(0)0).nSNAME{sxi[ns#,c#(sc)+nc#(c)]}(io).ns#,c#(sc)+nc#(os#='2'(so)(11).ns#,SNAME{six[ns#(SCX1OCNAME='C45'(C))]}ᐵ7R8S᝞:;ᡠ=>?@AR4-SoRABCD

20abcdabefabhkbdefbdd1ckcdckefI3Jᐵ7ᦪLM᪗O45SQLPஹ⌱S⚪1ஹSQL45WḄ45>᧕Z[஺A.\'ᓄB.^\'ᓄC._`ᓄD.ab`cᫀeB2ஹSQL45W45oA.fgᦪLMB.hiᦪLMC.ᐵ7ᦪLMD.^ᦪLMcᫀeC3ஹSQL45ᐹᨵḄmn஺A.ᐵ7oᓄஹᦪLqrஹᦪLsᑴB.ᦪLuvஹᦪLqrஹᦪLsᑴC.ᦪLuvஹᐵ7oᓄஹᦪLsᑴD.ᦪLuvஹᐵ7oᓄஹᦪLqrcᫀeB4ஹSQL45ᐹᨵwxyᵨ{`>ᑖ}~`SQL80A.=`SQLB.ᵨᡝSQLC.ᐭ`SQLD.`SQLcᫀeC5ஹᎷuZᐵ7WS(S#,SNAME,SEX,AGE),'ᐵ7WC(C#,CNAME,TEACHER),Z⌱ᐵ7WSC(Sit,Ctt,GRADE)□⌕⌱COMPUTER”'Ḅ᝕”Z>ᑮᐵ7oA.SB.SC,CC.S,SCD.S,C,SCcᫀeD6ஹ᝞:☢ḄᦪLMḄ⊤>¡¢£⊤Ḅ¤ᐵ¥¦W¢£§>¨©⊤Ḅ¤ᐵ¥¦W¨©§>SQLqª«n᡻஺A.®¢£⊤ᑤ◀(‘025',‘²³‘>'03',720)B.('005,',‘´ᐶ'>'04',750)¶ᐭᑮ¢£⊤C.¢£§>’001'Ḅ£¸ᦋ700D.¢£§>'038)Ḅ¨©§ᦋ‘03'cᫀeB7ஹ¡ᵨ᝞:ḄSQL4º»¼P½student⊤eCREATETABLEstudent(NOC(4)NOTNULL,NAMEC(8)NOTNULL,SEXC(2),AGEN(2))

21¿À¶ᐭᑮstudent⊤ḄW஺A.ÁÂ031',>ÃÄ'>ᵱ>23ÆB.ÁU031',>ÃÄ'>NULL,NULLÆC.ÁNULL,'ÃÄ'>'ᵱ'>'23'ÆD.Á'1031',NULL,'ᵱ'>23ÆcᫀeBI8ᑮI11⚪ÇÈÉ᪵Ḅ˽⊤ᓽZ⊤Sஹ'⊤C8Z⌱⊤SC,ÍÎḄÏ᪀᝞:eSÁS#,SN,SEX,AGE,DEPTÆC(C#,CN)SC(S#,CCGRADE)ᐸeS#Z§>SN>SEXឋ}>AGEÓÔ>DEPT7}>C#'§>CN',GRADEᡂÖ஺8ஹ×ØᡠᨵٲĔÓÔᜧḄZஹÓÔ8ឋ}஺ÛÜḄSELECT4ºWA.SELECTSN,AGE,SEXFROMSC.SELECTSN,AGE,SEXFROMSWHEREAGE>(SELECTAGEFROMSWHEREAGE>(SELECTAGEWHERESN=²Ä”)WHERESN=²Ä”)B.SELECTSN,AGE,SEXD.SELECTSN,AGE,SEXFROMSFROMSWHEREAGE>²Ä.AGEWHERESN=²Ä”cᫀeA9ஹ×Ø⌱'C2”ḄZᡂÖᨬáḄZḄZ§஺ÛÜḄSELECT4ºWA.SELECTS#FORMSCWHEREC#="C2”ANDC.SELECTS#FORMSCGRAD>=WHEREC#="C2"ANDGRADENOTIN(SELECTGRADEFORMSC(SELECTGRADEFORMSCWHEREC#="C2”)WHEREC#="C2”)B.SELECTS#FORMSCD.SELECTS#FORMSCWHEREC#="C2”ANDGRADEINWHEREC#="C2”ANDGRADE>=ALL(SELECTGRADEFORMSC(SELECTGRADEFORMSCWHEREC#="C2”)WHEREC#="C2”)cᫀeD10ஹ×ØZᐸᡠ⌱'Ḅ'§8ᡂÖ஺ÛÜḄSELECT4ºWoA.SELECTS.SN,SC.C#,SC.GRADEB.SELECTS.SN,SC.C#,SC.GRADEFROMSFROMSCWHERES.S#=SC.S#WHERES.S#=SC.GRADE

22C.SELECTS.SN,SC.C#,SC.GRADED.SELECTS.SN,SC.C#,SC.GRADEFROMS,SCFROMS.SCWHERES.S#=SC.S#cᫀeC11ஹ×Ø⌱ã©Àä'ḄZåᡂÖÁ«æ@«_Ḅ'Æ>ç⌕èᢥåᡂÖḄêë᣸ᑡîᩭ஺ÛÜḄSELECT4ºW஺(SELECTGRADEFORMSCSELECTS#,SUM(GRADE)FROMSCWHEREC#="C2”)WHEREGRADE>=60C.SELECTS#FORMSCGROUPBYS#WHEREC#="C2"ANDGRADENOTINORDERBY2DESC(SELECTGRADEFORMSCHAVINGCOUNT(*)>=4WHEREC#=WHEREC#="C2”)ANDGRADE>=D.SELECTS#FORMSC(SELECTGRADEFORMSCWHEREC#="C2”ANDGRADE>=ALLWHEREC#="C2”)(SELECTGRADEFORMSCSELECTS#FORMSCWHEREC#="C2”WHEREC#="C2”ANDGRADEINcᫀeDòஹóô⚪1ஹSQLWocᫀeÏ᪀ᓄõ452ஹö;WP½÷⊤>ÍW®জaîḄ⊤஺ᙠᦪLM>úûüö;Ḅঝ>«ûüö;Ḅ_ÿ஺
ᫀজᡈ⊤ঝঞḄᦪ3ஹᨵ᝞ᐵ⊤RRNo,NAME,SEX,AGE,CLASS-.ᐵ/01NOᐸ4NO5678NAME59:8SEX5ឋ<8AGE5=>8CLASS5?7஺ᑏABCᑡEFḄSQLHI஺জJᐭLM25,“QR”8“ᵱ”821,“95031"-Y0ঝJᐭ“95031”?67530ஹ9:5“Z[”Ḅ6\LMYoঞ]67510Ḅ6\9:ᦋ5“_`"YOট]ᡠᨵ“95101”?7ᦋ5“95091”Yoঠᑤ◀67520Ḅ6\LMYoডᑤ◀9“_”Ḅ6\LMY஺

23
ᫀজINSERTINTORVALUES(25,“QR”8“ᵱ”821,“95031”)ঝINSERTINTOR(NO,NAME,CLASS)VALUES(30,“ᐵE[”8“95031”)ঞUPDATERSETNAME=“_`”WHEREN0=10©UPDATERSETCLASS="95091”WHERECLASS="95101”ঠDELETEFROMRWHEREN0=20ডDELETEFROMRWHERENAMELIKE“_%”v3wx☢z{1ஹ6\|}ᦪ~4ᨵᐵ6\ᐵS(S#,SNAME,AGE,SEX)6ᐵSC(S#,C#,GRADE)|}ᐵC(C#,CNAME)ᐸ4S#ஹC#ஹSNAMEஹAGEஹSEXஹGRADE.CNAMEᑖ<⊤67ஹ|}7ஹ9:ஹ=>ஹឋᡂ[|}:஺ᵨSQLHI⊤ᑡz(1)⌱|}:5“MATHS”Ḅ6\Ḅ679:(2)6|}75“C1”[“C2”Ḅ6\Ḅ67(3)=>ᙠ18ᑮ20(18[20)Ḅ᝕\Ḅ67ஹ9:[=>(4)ᙳᡂ80ᑖḄ6\67[ᙳᡂ(5)⌱ᐰ|}Ḅ6\9:(6)⌱|¡Ḅ6\Ḅ9:
ᫀ(1)SELECTSNAME,AGE(3)SELECTS#,SNAME,AGEFROMS,SC,CFROMSWHERES.S#=SC.S#WHEREAGEBETWEEN18AND20ANDC.C#=SC.C#(4)SELECTS#,AVG(GRADE)8ᙳᡂ'ANDCNAME=,MATHS'FROMSC(2)SELECTS#GROUPBYS#FROMSCHAVINGAVG(GRADE)>80WHERECNO='Cl'ANDS#IN(SELECT(5)SELECTSNAMES#FROMSFROMSCWHERENOTEXISTSWHERECNO='(SELECT*C2,)FROMC

24WHERENOTEXISTS)(SELECT*(6)SELECTSNAMEFROMSCFROMS,SCWHERES#=S.S#ANDWHERES.S#=SC.S#c#=c.c#GROUPBYSNAME)HAVINGCOUNT(*)>32ஹ6\|}ᦪ~4ᒹ¯⊤:6\⊤Student(Sno,Sname,Sex,Sage,Sdept)|}⊤Course(Cno,Cname,Ccredit)6\⌱|⊤SC(Sno,Cno,Grade)ᐸ4SnoஹSnameஹSex>SageஹSdeptஹCnoஹCname>CcreditஹGradeᑖ<⊤67ஹ9:ஹឋ<ஹ=>ஹᡠᙠ:ஹ|}7ஹ|}:ஹ6ᑖ[ᡂ஺±ᵨSQLH²³ᡂᑡ⚗z(1)µ¶⌱|}ᒹ¯“1042”76\ᡠ6Ḅ|}Ḅ6\67(2)·¸¹º6\»¼S_CS_VIEW,ᒹ¯Sno67ஹSname9:ஹSexឋ

25v4wᦪ~ḄÂᐰឋஹ⌱Ã⚪1ஹ☢ÄÅ1ᦪ~ÆÇÈÉÊḄᦪËᑴEF஺A.ÂᐰឋB.ÍÎÏឋC.³᦮ឋD.ÑÒËᑴ
ᫀB2ஹÓÔᦪ~8■Ö×ØᣴᩗḄᡈÅᔠÜḄÝᵨ⌼ᡂḄᦪßàஹáᦋẚã஺ä1ᢣᦪḄoA.ÂᐰឋB.³᦮ឋC.ÑÒËᑴDឮç
ᫀA3ஹᦪ~Ḅ1ᢣᦪḄèéឋ[êëឋ஺A.ÂᐰឋB.³᦮ឋC.ÑÒËᑴD.ឮç
ᫀB4ஹᙠᦪÆ48ìíᩗ▲Ḅ5஺A.ïðB.ᣴᩗC.D.ñ¹
ᫀB5ஹᦪ~òᳮƽôÉÊᣴᩗEFᩭËᑴÅöᵨᡝøùᦪḄᩗ▲8ä.⌕15BCᦪ~ḄoA.Í☠ឋB.üឋC.³᦮ឋD.Âᐰឋ
ᫀD6ஹᑡSQLHI48FýBC“ᦈÿᵨᡝZHAO⊤(STUD)(XH)Ḅᦋᩗ”ḄA.REVOKEUPDATE(XH)ONTABLEFROMZHAOB.REVOKEUPDATE(XH)ONTABLEFROMPUBLICC.REVOKEUPDATE(XH)ONSTUDFROMZHAOD.REVOKEUPDATE(XH)ONSTUDFROMPUBLICᫀC7ஹᐵSCḄឋGRADEḄᦋᩗᣴᵨᡝZHAOḄSQLA)GRANTGRADEONSCTOZHAOB)GRANTUPDATEONSCTOZHAOC)GRANTUPDATE(GRADE)ONSCTOZHAOD)GRANTUPDATEONSC(GRADE)TOZHAOᫀC

268ஹᙠSQLServerᑤ◀$%ᘤᵨ'(஺A.ROLLBACKB.DROPC.DELALLOCATED.DELETEᫀB*ஹ+,⚪1ஹ./ᦪ12ᐰឋḄ456oᫀ78ᵨᡝ᪗:;<=ᩗ▲?ᑴ2ஹ2ᐰឋ?ᑴḄ456ᨵজஹঝஹঞஹট;FGḄ./HI2ᐰJK஺ᫀ:জᵨᡝ᪗:␺Nঝ<=?ᑴঞOPটᦪ1QR3ஹ<=ᩗ▲ᒹTU5☢ḄᑁXYZজ[Zᫀজ⌕<=Ḅᦪ1]ঝ^ᦪ1]_`abḄcd4ஹᙠᦪ1ef<=ᩗ▲ḄNghi஺ᫀᣴᩗ5ஹᙠSQLjYikᦪ1eḄ2ᐰឋY78kᦪ1Ḅ<=_`?ᑴḄYᵨᡝᣴᩗlᵨজ,ᦈoᡠᣴḄᩗ▲lᵨঝ஺ᫀ:জGRANTঝREVOKE6ஹDBMS<=?ᑴqᑴr⌕ᒹTUsᑖur<=?ᑴYoᫀvᑴ<=?ᑴ7ஹwx⊤_`y᝞'(ஹ'(ஹ'({ab|YSQLServer}~u᡻`$%ᘤᡠNgḄSQL஺ᫀINSERT,DELETE,UPDATE5ᦪ1e᦮ឋஹ⌱⚪1ஹᙠᦪ1efY.ᦪ1g;ᨵᦔḄ'(A.%?ᑴB.<=?ᑴC.2ᐰ?ᑴD.᦮ឋ?ᑴᫀD2ஹᐵr6┯Ḅ'(A.Z⊤78ZrB.ᐕ,ḄNgrC.ᐕ,ḄNgrD.ஹᒹ¡ZḄ¢ᔠ78irᫀC3ஹᙠ⊤ᡈFG᡻`◀k'(᜜Ḅ¦§¨$%ᘤ஺A.InsertB.DeleteC.UpdateD.Create

27ᫀD4ஹᦪ1eḄ—ᢣᦪ1Ḅឋ;Xឋ஺A.2ᐰឋB.᦮ឋC.%?ᑴD.ឮ³ᫀB5ஹᙠᦪ1eḄ⊤NgY▲ᑴᡂ¶ឋᑡḄ=ᙠ0ᑮ100Ḅ¼ᑁYᦪ1Ḅ஺Aஹ½¾᦮ឋBஹ¿᯿᦮ឋCஹᵨᡝuNgDஹᵨᡝabᫀC*ஹ+,⚪1.ᦪ1eḄ᦮ឋᢣᦪ1Ḅজ.ঝ;ঞ஺ᫀজ½¾᦮ឋঝ¿᯿᦮ឋঞᵨᡝNg᦮ឋ2ஹ½¾᦮ឋᢣᙠÂÃ⊤Y஺ᫀrឋ=,3ஹ¿᯿᦮ឋᢣᙠÂÃ⊤Yoᫀ᜜ṹ,ᡈὅ[ZᐵrṹḄᨵᦔ4ஹik./ᦪ1eḄ½¾᦮ឋYwᵨᡝÈÉrṹ_`ÊËlrṹÌ|YDBMS}oᫀÏÐ^abÑஹ7P⚪ᙠÒÈÓᳮᦪ1eÕÖ$%ᘤYwᔣ⌱Ò⊤ØᐭÚÛ|YÜÝÞÚÛḄᙠ⊤ᔲ<ᙠYÜÝÞÚÛḄÒÈᙠÒÈ⊤ᔲ<ᙠY⌱Òᡂ¶ᔲᙠ0àU100¼Yâᨵ⚗iᔲYᑣᐕØᐭ஺ᫀcreatetriggerstu_ins_trionscforinsertasbegindeclare@s#char(6),@c#char(5),©gradeintselect@s#=sno,@c#=cno,@grade=scorefrominserted

28if(@s#notin(selectsnofromstudent))or(@c#notin(selectenofromcourse))or(©gradenotbetween0and100)rollbacktransactionelseprintᡂØᐭ’end6ᐵᦪ1ᳮýஹ⌱⚪1ஹᐵþᓄḄᑤ◀ᢣজ,ᐭᢣঝoA.ᑤ◀Ḅᦪᑤ◀B.ᐭḄᦪᐭC.ᑤ◀Ḅᦪᑤ◀D.ᐭḄᦪᐭᫀজAঝD2ஹឋḄᐵ!"#$%&ᓄ,&ᓄ)⌕Ḅᳮ,-oA.ᐵ!&ᓄᳮ,B.ᐵ!./ᳮ,C.ᐵ!0ᦪᳮ,D.ᦪᳮ12ᫀA3ஹ&ᓄ34)⌕%56ᦪ7128᪀Ḅᐭ:ᑤ◀;<Ḅ=◍஺A.ᦪḄ@AឋB.8᪀ᔠᳮC.ᑍDEᜧD.ᦪGᜫᫀC4ஹIᐵ!"#R(A,B)JKL3NF,MᑡOPQRḄ஺A.S@TU◀VᐭWᑤ◀B.XYᙠ@TḄᐭWᑤ◀C.@TKLBCNFD.AWC[ᫀB5ஹᐵ!"\Ḅᐵ!"#]^஺A.INFB.2NFC.3NFD.BCNFᫀA6ஹᙠᐵ!DB:_`aᐗᐵ!"#Ḅᨬd#eT஺A.INFB.2NFC.3NFD.BCNFᫀD7ஹᙠᐵ!"#R:fᐸhᦪ-ijᡠᨵ᎛⌱ᐵop[qTrs:ᑣRᨬ

29u#0A.2NFB.3NFC.4NFD.BCNFᫀC8ஹ᎛⌱ᐵopḄKឋ$%஺A.)KឋB.)KឋC.ᔠKឋD.ᐵoKឋᫀB9ஹU◀Vᑖhᦪ-iḄ1NFḄᐵ!"#:eT஺A.INFB.2NFC.3NFD.4NFᫀB10ஹᐵ!"#Ḅ᎛ᐵop;ᨵজ)ᐵopᨵঝ஺A.0B.1C.1ᡈD.ᫀজCঝB11ஹᐵ!"#Ḅᑖ0A.@B.@ᫀB12ஹ᪷ᐵ!ᦪ7&ᓄᳮ,:ᐵ!ᦪ7Ḅᐵ!⌕@#஺M☢“”ᐵ!:rKឋS@#o(::ᡂᕒ:£¤ᳮ)A.£¤ᳮB.ᡂᕒC.D.ᫀBaஹ¦§⚪1ஹᙠᐵ!A(S,SN,D)WB(D,CN,NM:AḄ)oS,BḄ)oD,ᑣDᙠS$%oᫀ᜜o2ஹ¬L&ᓄḄ"#:¤3জ®%1NF,¯1NF¤3_®®%2NF,¯2NF¤3ঞ®%3NFoᫀজKឋ³®%´ᓫ³ঝU◀)Kឋ¬)ᐵopḄᑖ-iঞU◀)Kឋ¬)ᐵopḄ¶⌴-i3ஹᙠᐵ!ᦪ7Ḅ&ᓄᳮ,:ᙠ᡻¹“ᑖ”º:e»⍳½&ᓄ¾ᑣ¿ᢝ¾ᨵḄ-iᐵ!WoᫀÁÂÃÄឋÅஹᭆÇÈ

301ஹÉÊḄhᦪ-iᙠᐵ!"#R(U):¬LUḄÍjXWY,᝞ÑX-Y,ÓY=X,ᑣ$X-YÉÊḄhᦪ-i2ஹÉÊḄhᦪ-iᙠᐵ!"#R(U):¬LUḄÍjXWY,fX-Y,ÓYqX,ᑣ$X-YÉÊḄhᦪ-iÖஹ×ᔠØÙ1ஹJÚÛÜᐵ!"#S(Sno,Sname,SD,Sdname,Course,Grade)ᐸ:SnoÛஹSnameçஹSD!ஹSdname!)_ஹCourseè4ஹGradeᡂé஺(1)ᑏëᐵ!"#SḄìíhᦪ-iW)ṹ஺(2)¾ᐵ!"#S%ï#%ðñᑖᡂd@ò#:óOô%ðñ(3)¯ᐵ!"#ᑖᡂ3NF,óOô%ðñ(1)ᑏëᐵ!"#SḄìíhᦪ-iW)ṹ஺ᐵ!"#SḄìíhᦪ-i᝞MSno-*Sname,SD->Sdname,Sno—SD,(Sno,Course)-*•Gradeᐵ!"#SḄṹ%(Sno,Course).,(2)¾ᐵ!"#S%ï#%ðñᑖᡂd@ò#:óOô%ðñ¾ᐵ!"#SKL1NFḄ:ṹ%(Sno,Course),)KឋḄᡂéùᐰ-iLṹ:ᐸS)Kឋ¬ṹḄhᦪ-i%ᑖhᦪ-i:ᡠ;KL2NFoU◀)Kឋ¬ṹḄhᦪ-i%ᑖhᦪ-i:¯ᐵ!"#ᑖᡂ2NF᝞M:SI(Sno,Sname,SD,Sdname)S2(Sno,Course,Grade)(3)¯ᐵ!"#ᑖᡂ3NF,óOô%ðñ¯ûüᐵ!"#ᑖᡂ3NF᝞Mᐵ!"#S1YᙠSnc>fSD,SDfSdname,ᓽ
ឋSdname⌴Sno,ᡠS13NF஺ᑖ᝞!SI1(Sno,Sname,SD)S12(SD,Sdname)

31ᑖ(Ḅᐵ+,-SUஹS12013NF஺2ᐵ+,-S23ᙠ
ឋ2ṹḄ⌴6ᦑ3NF஺ᡠ68,-S(Sno,Sname,SD,Sdname,Course,Grade)ᢥ᝞ᑖ013NF஺Sil(Sno,Sname,SD)S12(SD,Sdname)S2(Sno,Course,Grade)2ஹAᨵ᝞ᐵ+RQᦟ஺ᦟᙢᙬ஺C1Vᓟ.D1"C2A஺DI"+1D23C஺Dl~(1)DEFG-IEJKI(2)ᔲ3ᙠᑤ◀OPQR?T3ᙠ6ᑣVWᙠJKXYZ[ḄI(3)\DᑖE]^-6ᑖ(Ḅᐵ+᝞_`ᑖabc3ᙠḄᑤ◀OPQRd⚪I(1)DEFG-IEJKI:D2NF஺gERḄ᎛⌱ᐵjkE“mno”஺ᐵ+!mnoᦟro6ᦟromno6ᦟroᦟrᙢᙬ6ᡠmno~ᦟrᙢᙬ஺ᓽ3ᙠ
ឋ“ᦟrᙢᙬ”2᎛⌱ᐵjkmnoḄ⌴wᦪ6gyR3NF஺z!gE3ᙠ
ឋ2᎛⌱ᐵjkḄ{ᑖwᦪ6ᡠR2NF஺(2)ᔲ3ᙠᑤ◀OPQR?T3ᙠ6ᑣVWᙠJKXYZ[ḄI!3ᙠ஺|ᑤ◀}~mnᑤ◀ᑤ◀ḄᦟrḄᨵᐵ஺(3)\DᑖE]^-6ᑖ(Ḅᐵ+᝞_`ᑖabc3ᙠḄᑤ◀OPQRd⚪I!ᑖE]^-᝞ᡠ஺R1᝞!R2᝞!

32Fᦟ஺1ᦟ஺ᦟᙢᙬ஺Cl஻ᓟ“ᓟJC2d♦,஺D"C33஺1)QD2PC"஺ᑖ(6Tᑤ◀mnᦪ62ᐵ+R1OP6ᦟrᙢᙬᙠᐵ+R2ᯠᶇ6ᜫᦟr☢Ḅ஺3ஹA}ᖪᦪᨵᐵ+,-R᝞!Rᖪ6ᖪ6ᦪ6{~6᝞¡¢!1£¤ᖪḄ£¥ᖪ¦ᙠ¤{~├¨©2£¤ᖪḄ£¤{~¦ᨵ¤©3£¤ᖪḄ£¥ᖪ¦ᨵ¤3ᦪ஺ª«¬ᑡd⚪!1᪷¯°¡¢6ᑏ²ᐵ+,-RḄ³´wᦪ©¬!ᐵ+,-SḄ³´wᦪ᝞!ᖪ6ᖪ{~6ᖪ6{~6ᖪ6ᖪᦪ2µ²ᐵ+,-RḄ᎛⌱ṹ©¬:ᐵ+,-RḄṹE!ᖪ6ᖪ6{~஺3ªdᐵ+,-Rᨬ]·¸¹ᑮFG-IEJKI¬!8ᐵ+,-R1NFḄ6ṹEᖪ6ᖪ6{~6
ឋ2ṹḄwᦪᐰE{ᑖwᦪ6ᡠ2NF஺¼◀
ឋ2ṹḄwᦪE{ᑖwᦪ6\ᐵ+,-ᑖᡂ2NF᝞!R1ᖪ6ᖪ6{~6ᦪR2ᖪ6{~64᝞R3NF,¿\Rᑖᡂ3NF,-஺¬!\RᑖER1ᖪ6ᖪ6{~6ᦪR2ᖪ6{~6ᑖ(ḄR3ᙠ⌴Ḅwᦪ6ᡠᑖ(ḄR·¸F3NFF7ÀᦪAÁ

33ஹ⌱Â⚪1ஹᙠᦪAÁ6ᵨE-RᩭÇ°È᪀zÊËᙠÁÌÍḄ⊤6DᦪAÁḄ▤Ð஺A.◤Ôᑖ᪆B.ᭆØAÁC.ÙÚAÁD.ᱥᳮAÁ¬ᫀ!B2ஹᙠᐵ+ᦪAÁ6AÁᐵ+,-ḄÞß஺A.◤Ôᑖ᪆▤ÐB.ᭆØAÁ▤ÐC.ÙÚAÁ▤ÐD.ᱥᳮAÁ▤Ьᫀ!C3ஹᦪᱥᳮAÁàᡂ(6ᐭᦪâã▤Ð6ᑡᔜ⚗âã▤ÐḄæPoA.çèÈ᪀B.᡽ᐙëcC.ìíᦪD.+î窱ᫀ!B4ஹᙠᦪḄᭆØAÁ6ᨬRᵨḄᦪ,ð஺A.ñò,ðB.ᱥᳮ,ðC.ÙÚ,ðD.âóὶ+,ð¬ᫀ!D5ஹöE-R,ðᐵ+ᔣᐵ+,ðøᣚ6¤M!Nὶ+øᣚEᐵ+,ð6ᐵ+,-Ḅᐵjk஺A.MûâóḄᐵjkB.NûâóḄᐵjkC.MûâóᐵjküNûâóᐵjkýᔠD.ÿ⌱ᐸឋᫀC6ஹE-RᔠᡂᐰE-R!ᔠḄ#OA.ឋB.)*C.+᪀D../ᫀB7ஹᭆ12345!oA.E-R23B.789ᜓ;DBMSC.>?@A;DBMSD.DBMSᫀB8ஹᦪDEFGDFDI#ᵨ!KL+᪀ᓄN*O▤QḄRᐹ஺A.Uឋᑖ᪆B.XY9ZC.◤\ᑖ᪆D.F]^ṹᫀC9ஹaᡠcḄE-Rdᣚᡂᐵ@23gdᣚhᐵ@2i஺

34A.1kB.2kC.3kD.4kᫀC1ᦪDo9ZḄpkqr#Oᫀ◤\ᑖ᪆ᭆ19Zst9Zᱥᳮ9Z@Awx@AyU;z{2ஹ“h}~⊤ᙠ}~Q5᪵Ḅ”9Zᑁ!ᦪDo9Z▤Q஺ᫀᱥᳮ3ஹᙠᦪDo9ZOᦪD◤\ᑏᡂᦻ᫏#ᔜᦪDKLḄᔠᒹᦪD⚗ஹᦪD+᪀ஹᦪDEஹᦪD;ᦪDRFḄKL¡¢hoᫀᦪDᐺ4ஹᙠ9ZᑖE-Rᵫ!ᔜk¥@Aᑖ¦ᨵ¨Ḅᵨ©ª««#ᵫ¨Ḅ9Z¬ᕒ9ZḄᡠgᔜkᑖE-R®¯°±ᨵ²ḄᙢN~´⌕ᨵজஹঝ;ঞ¹஺ᫀজឋঝ./ঞ+᪀¹ஹᵨ⚪9ᨵ᝞aw¼½¾½¿ஹᓫÁஹÂ/ஹឋ¦ஹÃÄஹ⌱ÅÆF/ÆF:^¿ஹÆF/ஹÈÆᓫÁஹÉÆᦟË¿ᦟËᦟË¿ஹÂ/ஹឋ¦ஹÌ¢ஹÍᣴÆF^¿ᓫÁᓫÁ/¢ஹᵯÐஹᦟË¿ஹᦟË/Lw¼Oᙠ᝞aὶ@(1).k½¾⌱ÅÔÕÆFÕÆFhÔk½¾⌱ÅÖ(2).kᦟËÍᣴÔÕÆFÕÆFhÔkᦟËÍᣴÖ(3).kᓫÁᨵÔkᦟ

35ËkᦟË×!kᓫÁ஺ØÙᡂ᝞aR?(1).ᑖ¦9Z½¾⌱Æ;ᦟËÉÆÚkÛÜḄ+᪀E-R஺(2).ÝL9ZÙᡂḄE-RᔠᡂkᐰE-R஺(3).ÝᐰE-RdᣚhÞḄᐵ@23⊤cḄᦪDost+᪀஺ß(1).½¾⌱ÆஹᦟËÉÆE-R᝞aᡠc஺m½¾⌱ÆE-Rᦟᵨ1ᓫÁᵯÐ/ফ.ᔠâḄᐰLÕäÆ&RæᨵÍᣴÈÆ

36ᐰE-Rhç±èéᩖa☢ìᔜw¼ឋᓫÁᓫÁ/ஹᵯн¾½¿ஹÂ/ஹឋ¦ஹÃÄᦟËᦟË¿ஹÂ/ஹឋ¦ஹÌ¢ÆF^¿ஹÆF¿G3I.ᐰE-RdᣚhÞḄᐵ@23⊤cḄᦪDost+᪀᝞aᓫÁGᓫÁ/ᵯÐIᦟËGᦟË¿Â/ឋ¦Ì¢ᓫÁ/IÆFGÆF^¿ÆF/ᓫÁ/I½¾G½¿Â/ឋ¦ÃÄᓫÁ/IÍᣴGᦟË¿ÆF^¿I⌱ÅG½¿ÆF^¿Iíஹî⚪ᦪDo9Zïᑖh}pk▤Qðk▤QḄ´⌕Éñ#òßG1IᦪDo9Zᑖh6k▤Q◤\ᑖ᪆ஹᭆ1+᪀9Zஹst+᪀9Zஹᱥᳮ+᪀9ZஹᦪDowxஹᦪDoyU;z{஺G2Iᔜ▤QÉñ᝞aজ◤\ᑖ᪆óôõßöᑖ᪆ᵨᡝ◤\GᒹᦪDöᜐᳮI஺ঝᭆ1+᪀9Zùᵨᡝ◤\úUûᔠஹüýöþÿ
ᡂᐹDBMSḄᭆ஺ঞ᪀ᭆ᪀ᣚDBMSᡠ"ᢝḄᦪ%&'ᐸ)*+ᓄ஺টᦪ%.ᱥᳮᦪ%⌱2ᨬ〉ᔠ6ᵨ8᛻Ḅᱥᳮ᪀:ᒹ<=>᪀?=2@AB஺ঠᦪ%.DEFᕒHᵨDBMSIJḄᦪ%KLஹNᐹOPQKL᪷%?ᱥᳮḄSTᦪ%.UᑴWXY6ᵨZ[\]ᦪ%ᐭ.&)*YH*஺ডᦪ%.H*?`aᙠᦪ%.cdH*eZf'ᐸ)*ghஹX᦮Wjᦋ஺

37ஹᑨn⚪1.ᐵcf*ᑡḄr[sᐵ஺:B2.E-Rtuv⊤xyDz{|ὶc஺:B3.~ᦪ%.᪀஺:B4.ḄQ⌕'ᐵc஺5.T'ᦪ%'AX┝ᑣᐕTjᦋA,ᐸ'AḄ┝஺:B6.┝■¡ᜫjᦋ?£“¥”ᦪ%஺:B7.SQLKLḄ§¨©Sᐰᦪ%⚗஺:B8.ᐵcRfᨵx,y,zcU®¯x—y,yfz,ᑣ°z±⌴³ᦪ´µx஺:B9.ᦪ%.ᵫcdd·ᳮ?zf¸ᑴ¹º»◀½ᦪ%ᑍ¿஺:B10.À~~ḄÀzᔜÀ~|ᐕÂÃÄÅ஺:BÆஹᓫ⚗⌱È⚪11.ᦪ%.f=ÉÊtḄA.ËÌB.'6Ḅᦪ%C.ÍÎD.▲ᑴ12.6ᵨᦪ%.ḄQ⌕ÐḄ½A.ÑÒÓÔÕ⚪B.ÑÒᦪ%Ö᦮ឋÕ⚪C.ᐳÙᦪ%Õ⚪D.ÑÒᦪ%ÚᜧÕ⚪13.ᙠᦪ%.ᢈÝfÞßcdḄA.E-RB.à§C.ᐵcD.☢ᔣ'Ḅ14.2ãᐵcfḄäᑡ&»åÄæḄᐗ\ḄᐵcHÞ°A.2ᑡHÞB.ᢗéHÞC.ὶHÞD.⌱ÈHÞ15.'ᐵcêë┯íḄA.TᙠîïḄᦪðᳮñஹzᔠñ?òóôÞõ~ḄöẠB.øßDBMSùᜧᑖûᵨᐵcᦪ%C.ᵨÆ`⊤⊤xᐵcᐸᜧᱯýD.ᐹᨵþÿ
ḄDBMSᐵᦪ16.SQLḄ᧕஺A.ᓄB.ᓄC.ᓄD.17.SQL⊤Ḅ!"#$%&᯿(᦮ឋ+ᑣḄ஺A.-./0B.᜜./0C.23/0D.NOTNULL18.45ឋ678Ḅᐵ9:;+ᓄ+ᓄḄ-⌕ᳮ?@A.ᐵ+ᓄᳮ?B.ᐵABᳮ?C.CᦪABᳮ?D.ᦪᳮDEᳮ?19.ᐵ9"ḄFឋᐰH-FឋᑣRḄᨬJKLA.2NFB.3NFC.BCNFD.4NF

3820.M┝FOA.PQᦑSB.TᦑSC.ᦑSD.UVᦑS21.Ꮇ᝞Zᵨᐵᦪᩭ$%]ᵨᙠᦪ45Ḅ▤`◤⌕bE-R9cdᣚ;ᐵᦪ9c஺A.ᭆg45B.ᱥᳮ45C.Ai▤`D.DE4522.ᦪjkᵨOA.lmᦪḄ(᦮ឋB.$%ᦪḄnᐰឋC.oiᦪឮqᡈst
D.$%ᦪᐳv23.ᦪyzᒹ|ᦪ},⌕ᒹ|]Ḅ,A.ᦪᳮB.ᦪ]ᵨC.ᐵḄ5BD.ᔜᐵᕒ24.ᐵ"ḄFឋḄ6᪗ᐗᑣ:Fឋ;A.-ṹB.᎛⌱ṹC.-FឋD.᜜ṹ25.ᙠR(U)"᝞£X-Y,s§¨OXḄ©ª«/¬X',®¯ᨵX'-Y,ᑣ_________A.Y¨X(ᐰ²ᦪ@³B.Y²ᦪ@³OXC.X;UḄ᎛⌱ṹD.RFO2NF¶.·¸¹º26.²ᦪ@³27.BCNF28.PQ29.DBMS30.»¼½ஹ
⊤¿ÀÁᨵᐵᦪḄ9᝞ÂÃSTUDENT(SNO,SNAME,SEX,CLASS)TEACHER(TNO,TNAME,SEX,BIRTHDAY,PROF,DEPART)COURSE(CNO,CNAME,TNO)SCORE(SNO,CNO,DEGREE)ᐸ"ÃSTUDENTC⊤ÅÆḄᔜFឋ@Ç⊤ÈÉÊ·ឋËÌÍÎTEACHERC⊤ᦟÐÆḄᔜFឋ@Ç⊤ÈᦟÐÉÊ·ឋËÑÅÒÓ,Ô:ᡠᙠÎCOURSEC⊤ÖÆḄᔜFឋ@Ç⊤ÈÖÉÖ·ᣴÖᦟÐÉÎSCOREC⊤⌱ÖÆḄᔜFឋ@Ç⊤ÈÉÖÉᡂÙ஺ÚᵨᐵCᦪஹSQL⊤¿᝞Â3ÛÃ31.ᑡÑ“99031”“99032”ÌᐰÝÅḄÞß஺32.ᑡÑ“5B”ᦟÐᡠᦟÖḄᡂÙ⊤஺33.âÈ“ãä”ᦟЩÖḄÅᡂÙÚᵨSQL⊤¿᝞Â3ÛÃ34.âÈ“99031”ÌÅḄᦪ஺

3935.âÈSCORE⊤"åæ5·Å⌱çḄs3èᜮḄÖÉḄêᙳᑖᦪ஺íஹî¹⚪4ᨵᐵ9R(A,B,C,D,E,F),RḄ²ᦪ@³¬ÃF={AB-C,C-D,A-F,D-E,D-F},RḄᑖ¹P={ABC,CD,DEF}஺36.îRḄ᎛⌱ᐵ.ð஺37.ᑨòPᔲᐹᨵõö÷øឋ²ᦪ@³lᢝឋúûᳮᵫ஺ýஹþᔠᵨ⚪ᎷḄᦪᒹḄ(1)Ḅஹஹᙬᡠᙠ஺(2)Ḅᡠᨵஹ!ᳮ├$Ḅ%&஺(3)%&Ḅ%&ஹᑴ⌼ᖪஹ*+ஹ,-%&ᑁ/஺(4)ᑴ⌼ᖪḄᑴ⌼ᖪ0ஹᙢᙬஹ2%Ḅ%&*+஺38.3456ᦪḄE-R7஺39.:E-R7;ᣚᡂᐵ?@,஺AᫀஹᑨD⚪(1-5)VVXXV(6-10)VXXXVEஹᓫ⚗⌱I⚪(11J15)ACABD(16J20)CBABC(21J25)DCDBAKஹLMN26.OᦪPQRR(U)STឋVUWḄᐵ?@X஺X,YSUḄYV஺Z[\R(U)Ḅ]^_`Ḅᐵ?r,rab_`cᙠdᐗfᙠXWḄTឋghijkᙠYWḄTឋgbijᑣ0XOᦪmYᡈYOᦪPQ\X,opX-Y஺27.BCNFRᐵ?@XRG1NF,᝞r[\RḄsOᦪPQX-Y,ZYbT\X,ᑣXtuᨵ᎛⌱ṹjxyRGBCNF஺28.z{ᡠ|z{Sᵨᡝ~Ḅpᑡj6p⌕yᐰ⌕yᐰb,Sb_ᑖᒘḄpᓫ஺29.DBMSdatabasemanagementsystem,ᦪᳮ?Sᦪ?᪶jᙠp?ḄᢝpjM᝞ᙢfcᦪj᝞ᦔḄᦪḄ?஺ᐸ⌕`ᒹᦪ~`ஹᦪ¡`ஹᦪḄ¢£ᳮᦪḄ¤¥¦஺30.§7§7S¨©ª⊤ᡈᐸ¬§7a5Ḅ⊤j®ª¯b°¥cᙠᦪaj±²S³ᦪa´cµ§7Ḅ~kbcµ§7[Ḅᦪj6ᦪ¶cµᙠ5§7Ḅ©ª⊤aj·¸§7S¹⊤஺ºஹp⊤»31.°CLASS='99O31,VCLASS='99032,(STUDENT);SELECT*FROMSTUDENTWHERECLASS='99031'ORCLASS='99032,¼32.n,CNO,GRADE0DEPART='¿ÀÁ'(TEACHER00COURSE00SCORE)¼SN0SELECT*FROMSCOREWHERECNOIN(SELECTCNOFROMCOURSEWhereTNOIN(SELECTTNOFROMTEACHERWHEREDEPART='CS'))¼33.nSNO.CNO.GRADE°SNAME='ᩭÃ'(TEACHER00COURSE00SCORE)¼

40SELECT*FROMSCOREWHERECNOIN
SELECTCNOFROMCOURSEWHERETNOIN
SELECTTNOFROMTEACHERWHERESNAME='ÅÃ'ÆƼ34.SELECTCOUNT
SNOFROMSTUDENTWHERECLASS='99O31'¼35.SELECTAVE
GRADEFROMSCOREWHERECNOLIKE"3%"GROUPBYCNOHAVINGCOUNT
SNO=5¼ÇஹÈM⚪36.ÈRḄ᎛⌱ᐵÉÊËA,B37.ᑨDPᐹᨵÍÎÏÐឋÑbᐹᨵPQÒᢝឋj·ÓA-FÔÕᑮÒᢝ஺×ஹØᔠᵨ⚪38.3456ᦪḄE-R7஺ËjjᙬÆËj!ᳮÆ%&Ë%&j,j%&ᑁ/Æᑴ⌼ᖪËᑴ⌼ᖪ0jᙢᙬÆ39.E-R7;ᣚᡂᐵ?@,஺Ë,jᙬjÆË,!ᳮÆ%&Ë%&j,,%&ᑁ/,├$ḄÆᑴ⌼ᖪËᑴ⌼ᖪ0,ᙢᙬÆ2%Ë%&j,,ᑴ⌼ᖪ0,*+Æஹᓫ⚗⌱I⚪1.ᐵ?ᦪ@,WḄᐵ?¢ÀᑖÓËÆA.ᐵ?ÜᦪVᔠ¢ÀB.ᐵ?Üᦪᐵ?ÞÀC.ᐵ?ÞÀ|LÞÀD.ᐵ?Üᦪ|LÞÀ2.ᙠᦪ?ajÒâᦪ-ã~ämᨵᦔḄ`SËÆA.åæçᑴB.cçᑴC.èᐰçᑴD.é᦮ឋçᑴ3.ëìdᐵ?᝞

41ABCDEA1blcldlel12b2c2d2e213blcld3el2ᎷRRḄÉSA,SḄÉSD,ᙠᐵ?SḄ~aᒹu᜜ÉY÷“FOREIGNKEY
AREFERENCESR
AONDELETERESTRICT”ᑡSQLᡂ᡻Ḅ
A.DELETEFROMRWHEREA=2B.DELETEFROMRWHEREA=3C.DELETEFROMSWHEREA=1D.DELETEFROMSWHEREA=24.()*+ᵫ-./012ᡂ345Ḅ/016〉ᵨ95:;Ḅ*+ᑣ*+=>?@/01=>?ABḄὶD
A.1:1B.1:MC.M:1D.M:N5.DGᦑIJ⌼ᡂ
A.ᑁMᦪOPᜫB.RSᦪOPᜫC.TSᦪOPᜫD.UVᦪOPᜫ6.SQLḄSELECTX"HAVINGᩩ1⊤^_”ᵨᩭa⌱cdᩩ1Ḅ
A.ᑡB.C.ᐵDD.ᑖ27.hᐵDi_R
A,B,C,FRkᡂlḄFD?F={A-B,C-B},R±ḄᑖqP={AB,AC},ᑣᑖqP
A.sᢝuᦪvw?FB.PᜫxC-BC.PᜫxAfBD.ᔲsᢝFD,ᵫRḄ{|ᐵD}~8.(.cd2NFcd3NFḄᐵDi_Mᙠ
)A.ឋ᎛⌱Ḅ0ᑖvwIB.ឋ᎛⌱Ḅ0ᑖvwC.ឋ᎛⌱Ḅ⌴vwID.ឋ᎛⌱Ḅ⌴vw9.᝞TᙠᦪORkxX┝ᑣᐸᙠᦪOk
A.6X┝B.6S┝C.6S┝ᡈX┝D.┝10.ᵨ☢ḄSQLl(•.¡⊤:CREATETABLEStudent(SnoCHAR(4)NOTNULL,SnameCHAR(8)NOTNULL,SexCHAR(2),AgeSMALLINT)6¯°ᐭᑮ⊤XḄᐗ2()A.'5021','ᑢἝ'ᵱ21B.NULL,'ᑢἝNULL,21C.'5021z,NULL,ᵱ21D.'5021',ᑢἝNULL,NULL11.¹º»ᐵDS¼ᦋᩗ▲ÀÁᵨᡝlin,ÇᐕÉᵨᡝlin»ᐵDSḄ¼ᦋᩗ▲ÀÁᐸÅᑣÆ᡻ḄSQL
A.GRANTUPDATEONSTOlinWITHGRANTOPTIONB.GRANTUPDATEONSTOlinC.REVOKEUPDATEONSFROMlinRESTRICT

42D.REVOKEUPDATEONSFROMlinRESTRICTchen(ஹÎÏ⚪12.Ñ᯿Ó᦮ឋÕᑣḄÖ×஺13.᝞Ù.ᐵDÚᨵÜᐳឋᑣᐸÞᯠὶàáâ@áâãä஺14.SQLXåᔠuᦪ“COUNT
ᑡè”Ḅ஺15.SQLé(êë9ᐵDìᦪíABḄᐵDîïé஺16.-.ᵨᡝ5ð5(ᦪOñáâòóáâ஺17.ᙠᦪOôhõXÕᑜM÷ø᪀íMúûü9hõ஺18.hᐵDi_R
A,B,C,DíRkḄuᦪvw?F={AB-D,D-C},R±Ḅ(.ᑖq={ABD,BCD},᪷Oþÿὶ
Ḅᭆὶ
ᑖ஺ஹ⚪19.ᦪ᪀!᪀Ḅ"#$%&'20.*ᨬ,-ᦪ./012Ḅ3ᩩ5஺21.67ER:;<=>?Ḅ@AᨵCDE'22.*FGᦻ5Ḅᵨ⌶஺23.LMNO<=P>?CDEᦪQRS'ᵨ%&TU=VWᔜ!QRSḄYZ'ஹ[\⚪24.[^_`ᦪaᨵᐵ᝞defghfgifgjឋlmnogOhfgi_`igpo_`h_`i_`jᙢᙬoᵨᐵsᦪ⊤uᑏwdᑡyzeQᙠ“}ᐗ”_`gOḄᡠᨵfgḄfgi஺25..24⚪Ḅ⊤ᑏwyz3_`᝕fgḄᙳgpḄSQL஺26..24⚪Ḅ⊤ᵨSQLᑏwdᑡNOe50fgḄgp200ᐗ஺27..24⚪Ḅ⊤ᵨSQLR3gpQ2000ᐗḄfgYZḄhjASSEo28.ᐵRhA,B,C,D,E,Fo£¤R¥Ḅ-ᦪ./0F={AB->CDEF,B->C,E->F},«wRḄ᎛⌱ṹ஺¯ஹ°ᔠ⚪29.²³Ḅ´µ¶ᑣ᝞deh1o¸fg<£¹D3QºḄg»¼3g»ᨵ½jfg¹¾¿h2o¸fgᨵR3f¸¼½jfg<=ᨵÀºḄf¸¿h3of¸Á,Âgp᳛_`ᢥfgᙠR3g»aÅᡂḄgÂ\ÇÈÉ;h4ofgḄËឋᨵfgiஹÌjஹf¸Í,Âgp᳛¿h5og»ḄËឋᨵg»iÍg»jÎ஺᪷¥*´µ¶ᑣeজ[\ERÑ¿ঝÓERÑÔᣚᡂᐵ0L¶ᓄ12ØÙÚ
ÍÛᢝ-ᦪ./Ḅ3NFoᫀe

43Rஹᓫ⚗⌱â⚪1.B2.D3.A6.D7.B8.B9.D10.D11.Aஹãä⚪12.᜜13.çᓱéê14.íRᑡaḄî\Ç3ᦪ15.ᐗïæÇ16LM17.ᱥᳮ18ØÙஹ⚪19.
1ᦪḄ᪀ᵫ᜜ஹÍᑁïᡂ஺h2᜜$ᦪᵨᡝ=óôõÍöᵨḄ67ᦪḄ÷ø᪀ÍᱯúḄû*$ᦪᵨᡝḄᦪü¤Ḅ$ᦪḄ67Ḅ÷ø᪀஺$ᦪaᐰþᦪḄ÷ø᪀ÍᱯឋḄû*$ᡠᨵᵨᡝḄ_ᐳᦪ
஺Ḅᦪ
Ḅᐰ᪀஺ᑁᦪ
ᙠᦪ
ᑁḄ⊤ᓽᦪ
ᱥᳮ᪀!Ḅ஺"3ᦪ
ᙠ#$%&'()*+,᧜./᜜/᧜./ᑁ᧜.23*ᦪ
4Ḅᦪ
56ᐹᨵ9:Ḅ;<ឋᱥᳮ;<ឋ஺20.᝞?@ᦪABCFDEFᑡᩩIᑣKFLMN᩽P@ᦪABC஺
1F4QM@ᦪABḄRSTᨵMNUឋV
2F4Wᙠ#᪵Ḅ@ᦪABX-A,YZF[F-X—A\]V
3F4Wᙠ#᪵Ḅ@ᦪABX-A,Xᨵ^_CZYZ"F—
X-AUZfA[F\]஺21.ᑖE-R&'Ḅ$bcd/
1Uឋcd"2efcd஺"3᪀cd22.
1ghijᦑlឮn"2ghᦑlឮn"3opᦑlឮn"qrsᜓuvghw23.
1xyz{|ᩭᦪ
WM~ឋ/ᜫᦋஹWn“”ᦪ
஺WM~ឋḄ!xyᑴ஺ᨬᵨḄxyᑴᢈ┝ᢈ஺.⚪24.n"w-n.
of=‘£ᐗ'"8{8ww25.SELECT"fAVG"§wwFROM{WHERE.={.AND{.=.AND.ឋ¨=᝕GROUPBYf26.UPDATE{SET§=§+200WHEREIN
SELECTFROMWHEREª«50

4427.CREATEVIEWASSEASSELECT"fឋ¨ª«wFROMWHEREIN
SELECTFROM{WHERE§=200028.¬ALLbUឋC,DLNbUឋACD®U¯Q°᎛⌱ṹ஺ὃµBஹEஹF,¶L"ACDB+={ABCDEF=U,Fᡠ¸"A,C,D,BL᎛⌱ṹ
ACDEF'={ACDEF}WU,
ACDF+={ACDF}^U,Fᡠ¸ᙳWL᎛⌱ṹºACDEFF+={ACDEF}WU,»WL᎛⌱ṹ"4ᑖwᡠ¸᎛⌱ṹL"A,C,D,B¼.½ᔠ⚪
2জÀᣚsḄᐵL"ÃfÄPŧ᳛wÇ"ÇÇfKwÈ["ÇÅwঝ
ÊËᑏÍ@ᦪAB/-ÏÄ-ÏÃf-ÏPŧ᳛Ä-ÏPŧ᳛"Çw-ÏÅÇ-ÏÇfKᵫজZÍḄᐵ_4ÇÈ[ÑÒU¯3NF¯"ÃfÄPŧ᳛wᙠḼÔÕUឋ'Ḅ@ᦪAB"Ä-ÏPŧ᳛wᡠ¸W3NFᐸgh×Øx2ᢝ@ᦪABḄᑖ¬ᑮ3NFL/"ÃfÄwK"ÄPŧ᳛w½Ûgh×Øx2ᢝ@ᦪABḄᑖ¬ᑮ3NFL{"ÃfÄwK"ÄPŧ᳛wÇ"ÇÇfKwÈ["ÇÅw}ᦪ
ᭆß

45àáâ1ஹᐵãᓄ4Ḅᑤ◀z{èᢣজ,ëᐭz{èᢣঝ-A.Wíᑤ◀Ḅᦪ
îᑤ◀-B.WíëᐭḄᦪ
îëᐭ-C.ïíᑤ◀Ḅᦪ
ðîᑤ◀-D.ïíëᐭḄᦪ
ðîëᐭñ/ᑤ◀z{èᢣ᡻hᑤ◀z{ÅóWïíᑤ◀Ḅᦪ
ᑤ◀ḄôõVëᐭèᢣ᡻hëᐭz{ÅïíëᐭḄᦪ
×ëᐭḄôõ஺v⚪ñᫀL/জAঝD஺2ஹឋ59÷ḄᐵKLãᓄãᓄÕ⌕ḄᳮßA
-A.ᐵãᓄᳮß-B.ᐵùúᳮß-Cûᦪᳮß-D.ᦪᳮñ/ᐵãᓄᳮßᐵᦪ
4ghᐵḄᳮßA
஺v⚪ñᫀLAo2ஹ᪷
ᐵᦪ
ãᓄᳮßᐵᦪ
4Ḅᐵ⌕DEàM஺F☢“þ”ᐵ4¶ÿ
ឋᡂᕒᳮ-A.ᳮ-B.ᡂᕒ-C.-D.ᐵḄ“ᡂᕒ”"#Ḅ1NF஺%⚪ᫀ(B஺3ஹ*◀,ᑖ.ᦪ01Ḅ1NFḄᐵ234"A.INFB.2NFC.3NFD.4NFᵫ2NFḄ4678%⚪ᫀ(B஺4ஹ9ᐵRḄ᎛⌱ṹ="ᵫᓫ
ឋ᪀ᡂḄᑣRḄᨬB34"-A.1NF-B.2NF-C.3NF-D.CDE4᎛⌱ṹᵫᓫ
ឋ᪀ᡂ4FGᙠIJ
ឋK᎛⌱ṹḄᑖ.ᦪ01஺%⚪ᫀ(B஺

465ஹᙠᐵ2R
A,B,C,Dᨵ.ᦪ01NF={BfC,C-D,D-A},ᑣROPᑮA.INFB.2NFC.3NFD.RSTὅ=VWᐵ2Ḅ᎛⌱ṹ"B,X(B_*C,CB,C-*D,ᡠRGᙠIJ
ឋDK᎛⌱ṹḄZ⌴.ᦪ01R"3NF஺\X(GᙠIJ
ឋK᎛⌱ṹḄᑖ.ᦪ01ᡠRR"2NF஺%⚪ᫀ(B஺6ஹ]ᨵᐵW^_^`4abᐸdᓄᑮTfEḄᫀ"___A.W1^_W2^`4aB.W1^^`4aW2^_C.W1^_^`W2^`4aD.RS=KWᐵḄ.ᦪ01N({^_^^`^`4a},k⌱ṹ(“^”ᑖ᪆78“4a”“^`”Z⌴.ᦪ01m“^”nZ⌴01o*◀஺⌱⚗AḄqᐵrᨵst
ឋfEu⌱⚗Bv*◀Z⌴01஺%⚪ᫀ(C஺7ஹᨵᐵ2wxwyz{9|wx|yzᨵ4Ḅ{|yz|{}ᨵwxᑣR~┯Ḅ"A.wyzyz{=7R(᎛⌱ṹB.}ᨵwyzO(᎛⌱ṹC.ᐵ2
mTD.ᐵ2
mBCNFwyz{yz{wᡠRwyzyz{=7R(᎛⌱ṹ⌱⚗AfEuWᐵᡠᨵḄ
ឋ="J
ឋᡠR
mT⌱⚗CfEuWᐵSḄq.ᦪ01Ḅ=ᒹ,WᐵḄ᎛⌱ṹᡠR
mBCNF,⌱⚗DfE஺%⚪ᫀ(B஺8ஹᐵ2STJ
S#,T,J#Gᙠ.ᦪ01
S#,J#-T,
S#,TfJ#,T->J#,ᑣA.ᐵSTJINF,2NFB.ᐵSTJ2NF,3NFC.ᐵSTJ3NF,BCNFD.ᐵSTJBCNF,4NF

47Wᐵ2Ḅ᎛⌱ṹ"S#,J#S#,T,ᡠᨵḄ
ឋ="J
ឋᡠᨵWᐵ2"3NF,\X(T-J#ḄvᒹWᐵḄ᎛⌱ṹᡠR"BCNF஺%⚪ᫀ(C஺9ஹO*◀01ḄᑍḄ"A.2NFB.3NFC.4NFD.BCNFᐵ2Pᑮ4NF7ᑤ◀ᵫ01Ḅᑍ஺%⚪ᫀ(C»10ஹB
m.ᦪ01mA
ឋ
ឋBAḄὶ"o_A.1KB.K1C.KD.RS="11ஹᙠᐵ2᝞
ឋABGᙠ1K1Ḅὶᑣ—஺A.A-BB.BfAC.A—BD.RS="12ஹᐵ2RḄ
ឋᐰ"J
ឋᑣRḄᨬB34"A.2NFB.3NFC.BCNFD.RS="BCB¡wxᡂ¢£¤⊤yzᡂ¢w_ឋ¦§¨©ªyywwᑖᦟ¬^ᡂ¢S1®TᵱCS98C1DB603°Ml90C2DS603±M970C3OS804²M485C4MA1206³M790C5PH905ᕜM275S2³µ᝕CS99C1DB603°Ml86·•ᐵ2R
U,F,.ᦪ01ᐵF(-w_ឋ¦§¨©ª-yywᑖw^-wyᡂ¢-¬ᦟ¬•
ឋNu(-w_ឋ¦§¨©ªyzᡂ¢1NF•*º7ᑜᑖḄ
ឋyzᡂ¢-wxw_ឋ¦§¨©ªyywᑖwᦟ¬^,ᡂ¢

48-ᐵ¼½wy-elNF•*ºᑖ.ᦪ01-GᙠḄᑖ01•wyP-_ឋ¦§¨©ª•wypywᑖw^,ᦟ¬-*ºᑖ01•w_ឋ¦§¨©ª•y~ywᑖw^,ᦟ¬•wyᡂ¢-ᢗÀᡂTÁᐵ2•wxw_ឋ¦§¨©ª•yz〈ywᑖw^,ᦟ¬•ᡂ¢wyᡂ¢-G2NF•*ºZ⌴.ᦪ01-GᙠḄZ⌴01•y^•^ᦟ¬•yLᦟ¬-*ºZ⌴01•yywᑖw^•^ᦟ¬-ᢗÀᡂqÁᐵ2•yzyywᑖ.w.^•ᦟ¬^,ᦟ¬-G3NFᨬÄᢗÀÅ-wxw_.ឋ¦.§¨.©ª-yzyy.wᑖ.w.¬-ᦟ¬¬ᦟ¬-ᡂ¢wyᡂ¢•1ஹ~⊤ÆÇᦪÈNÉᑨË"ᔲ7ÍÎ(ᐵᦪÈÏḄᐵ9Vᑣᦋ⌼ᡂ(Ò7OÓḄÔO(ᐵᦪÈÏᐵḄÕÖ×Vn`ᦋ⌼Ḅᳮᵫ஺+ᦟ,-.+DB/0ᑢ2.3+CAD4567⌼+CAM:;<=+CTY>?@A

49·X(ᐵ2"1NFᐵᓽᒹÙÚÛÔÜGᙠÝᝅÅ᪀ÆÇḄᦪÈNßᯠ7ÍÎ(ᐵᦪÈÏḄᐵᦋ⌼(1NFḄᐵ᝞~ᡠ/J'sO+ᦟ,-.+DBB0,-.+DBᑢ2.^^+CAD45.+CAD67⌼+CAM:;<=+CTY>?<=+CTY@D2ஹ]ᨵᦟwáᳮᦪÈÏᐸ
ឋ(wS#,yzC#,ᡂ¢G,yᦟ¬TN,ᦟ¬ᡠᙠḄD஺nâᦪÈᨵ~ᑡä6-wyzᑖ¦ᐸå⊤ḄwxyzKo஺-wxᡠæḄ|yz=ᨵᡂ¢஺-|yz}ᨵçyᦟ¬|çᦟ¬7Rᨵyz஺-ᦟ¬rᨵÙ|ᦟ¬}
m஺•è᪷ÈSä6E4.ᦪ01N஺•᝞ᵨS☢ᡠᨵ
ឋÛᡂᐵ2ìíWᐵ2(î2Ô¡Öᙠ×VïஹᑤðḄñòóô஺•ᑖ·(ᐹᨵ01öᢝCøùÎḄ3NF஺,·•
1F={
S#,C#-G,C#—TN,TN-D}•2ᐵ2(INF,X(Wᐵ2Ḅ᎛⌱ṹ(S#,C#,ᑣIJ
ឋᨵG,TND஺•\•.1ᨵC#fTN,.•.GᙠIJ
ឋTNK᎛⌱ṹS#,C#Ḅᑖ01ᓽ•9úï]yzᨚürᨵwx⌱æᑣXýṹS#O×Vþᐭ
஺ᦟ᪥⌕ᑤ◀ᨵᐵᑤ◀Ḅ
C#ᑤ◀஺•
3VFm={
S#,C#-G,C#—TN,TN-D}•AP={R1,R2,R3}•ᐸ-Rl=(S#,C#,G)-R2=(C#,TN)-R3=(TN,D)•3ஹ"⊤$%Ḅᐵ&R'()+,-ᔲ/ᙠ
12,/ᙠᑣᐸᑖ5'678+஺ᑖ59ᡂḄ68+-ᔲ;<=>ᑖ5?ᐵ&/ᙠḄ
12,REFᩞᧇFᦪJKELMNELMOPP111498059902250P1I2698059902300P1I31598059902180P211698119912250

505@'INF஺A'ᐵ&Ḅ᎛⌱ṹ'EFGᩞᧇGJKLMNឋ“QFRS”U“9FRS”VᑖWᦪYZ[᎛⌱ṹḄ\]“FG”ᓽEFGᩞᧇGJ7QFRSEFGᩞᧇGJ--9FRSR`ᦟ`ᦟᙢᙬC1cᓟeD1C2[fgD1C3hiD2C4[fgD1•@-2NF஺•@/ᙠ
12᝞kF⚗mnopᨚrᵨᑮᩞᧇᑣFḄᦪuAvwṹḄ7VᑖEᩞᧇGJKxyᐭᑮᦪu{%|}ᐭ12஺F"cᑣᑤ~FḄ
;xᜫᩞᧇ☢Ḅ஺•ᐸḄVᑖWᦪYZᑖ5'7Ḅᐵ&ᑣ᝞"ᡠḄ2NFᐵ&+RIR2EFᩞᧇFᦪJOPEFKELMNELMP1114250P198059902P1I26300P298119812P1I315180P2116250P2I418350•ᑖ5pFnoprᵨᑮᩞᧇFᦪu;ᙠᐵ&R2}ᐭ஺Fᦪuᑤ◀ᐵ&R2
ᜫᩞᧇ☢Ḅ஺•4ஹᨵ᝞"ᡠḄᐵ&R஺
1@'()+,',•
2-ᔲ/ᙠᑤ◀
12,/ᙠᑣ-ᙠ"?

51•(3)@ᑖ5'678+ᑖ5pḄᐵ&᝞5ᑖ5?;x/ᙠḄᑤ◀
Ḅ12⚪஺•5(1)@-2NF஺•:RḄ᎛⌱ṹ'`K“`7ᦟ`”“ᦟ`7`”ᡂ,“ᦟ`7ᦟᙢᙬ”.•.ᓽ/ᙠLMNឋᦟᙢᙬ᎛⌱ṹ`Ḅª⌴WᦪYZA¬R-3NF஺••••/ᙠLMNឋ᎛⌱ṹḄVᑖWᦪYZR-2NF஺•(2)/ᙠ஺®ᑤ◀¯ᑤ◀ᑤ◀ḄᦟḄᨵᐵ஺•(3)ᑖ5'678+᝞"ᡠ஺RIR2ᦟᦟᦟᙢᙬC1ᓟᓟD1C2D1C3ᓱD2C4ᑖ5pᑤ◀ᦪuᐵ&R1
ᦟᙢᙬᙠᐵ&R2°ᯠ²ᶇᜫᦟ☢Ḅ஺•5ஹᨵ᝞"ᡠḄᐵ&R஺RREFRESTឋVᓫXFᓫXE1ZHAO20FD3cccE2QIAN25MD1A^AE3SEN38MD3CCCE4LI25FD3CCCµR-ᔲN[3NF?',-@N[()+,¶᝞·ᓄ'3NF?•5RN[3NF,@-2NF஺•:RḄ᎛⌱ṹ'¹FGU¹F`K¹FG7ᓫ»Gᓫ»G7¹FGᡂᓫ»G7ᓫ»`஺•ᓽ/ᙠLMNឋᓫ»`᎛⌱ṹ¹FGḄª⌴WᦪYZ஺·ᓄpḄᐵ&\+'᝞"ᡠḄᐵ&R1¼R2o____________¿___________R2REFREÀឋVᓫXFᓫXFᓫXE1ZHAO20FD3D3CCCE2QIAN25MD1E3SEN38MD3D1AAAE4U25FD3

52•6ஹ"☢$%Ḅᐵ&SC'()+,-ᔲ/ᙠ}ᐭᑤ◀12,/ᙠᑣ-ᙠ",ḄÁA-,@ᑖ5'678+ᑖ5pḄᐵ&xᔲ5
12⚪,•ᐸSNO'GCNO'GCTITLE'`INAME'ᦟ`ILOCA'ᦟᙢᙬGRADE'ᡂÂ஺SCSNOCNOCTITLEINAMEILOCAGRADE80152C1OS:YD17080153C2DBZᓣD28580154C1OS:YD18680154C3AlᩰᩰD37280155C4CLZᓣD292•5SC'INFo•@/ᙠ}ᐭஹᑤ◀12
஺®Ã7¯AÄᨵ⌱ÅᑣvwṹḄ7VᑖSNOx᡻Ç}ᐭ
È®ᡠᨵ⌨⌱¯KyÇᑤ◀
ᑤ◀Ḅᑤ◀ᣵ஺•SCᐵ&/ᙠ}ᐭUᑤ◀
12ḄÁAᙠ[ᐵ&Ḅ᎛⌱ṹ'(SNO,CNO),ᐸᨵLMNឋGRADE9ᐰWᦪYZ[(SNC,CNO),ᐸÌLMNឋCTITLE,INAME,ILOCAÍÎWᦪYZ[CNO,ᓽ@ϼ(SNO,CNO)'VᑖWᦪYZᐵ&஺ᑖ5pḄᐵ&+᝞"ᡠ஺SGCISNOCNOGRADECNOCTITLEINAMEILOCA80152C170C1OS]0180153C285C2DB^D280154C186C3Al᨟D380154C37280155C492C4CL^D2•ᑖ5pḄᐵ&+Í'2NF,¶5Ðᐜ?Ḅ}ᐭஹᑤ◀12஺®Ã7¯;ᦪu}ᐭᑮCI⊤È®ᡠᨵ⌨⌱¯,Î◤ᑤ◀SG⊤ḄᨵᐵÓÔKḄᨵᐵ°²ᶇᙠCI⊤஺•ᑖ52NFpḄCIᐵ&°/ᙠ}ᐭஹᑤ◀
12஺ᨵ7ᦟÕᑮ,◤ᐸᨵᐵᦪu}ᐭᑮCI~Öᦟᨚr×ØÙᦟF
ᑣAvwṹCNOÚKxyÇ}ᐭ
È®ÛܯKᑤ◀CI⊤Ḅ7ᩩÓÔᑤ◀ḄᦟḄᨵᐵᑤ◀஺CI⊤%|
12ḄÁA-ᐵ&/ᙠLMNឋ᎛⌱ṹḄª⌴WᦪYZCNOT[NAME,INAMETCM9ᡂINAMEfILOCA..CNO>ILOCA

53*CIy7ßᑖ5'᝞"ᡠḄCourseUInstructorᐵ&;<5àá
12஺CourssIhstndorCNOCTITLEINAMEINAMEILOCAC1OSâã:YD1C2DB6ᓣC3AlᩰᩰZᓣD2C4CL6ᓣᩰᩰD3•7ஹæᐵ[&ç8èéêḄ7ᐵ&ᦪu{7&ᨵëìíîìíîïÎð7çîçᨵë7&Ḅñᙠò7óôõî;<ö÷ëèéîèéᨵë஺-øáḄNឋᨵGஹù`ஹ%ïᨴஹ&`ஹç8Gஹóôõ஺-øáç8ḄNឋᨵç8GஹìíGஹ&`ஹûᦪஹᐭïü஺-øá&ḄNឋᨵ&`ஹ&Gஹýþÿᙢ
ஹᦪ஺-Ḅឋᨵஹᡂஹᙢ
ஹᦪஹḄ஺•ᐵ!"#ᢣ%ᔲ'ᙠ)⌴+ᦪ,-#./+ᦪ,-01%2ឋḄ3456+ᦪ,-%7ᐰ+ᦪ,-#9%1ᑖ+ᦪ,-஺•ᢣᔜᐵḄ᎛⌱ṹஹ᜜ṹ#ᨵ@ᨵᐰṹ'ᙠA(1)ᐵ(C#DE#F#GHC#᎛⌱ṹC᜜ṹ#GHCᨬF,-JFm=KCLD#Cf#INLWO4»,»•᜛'QL᜛E—Sj(2)GHᐵGH(GHC#TU##ᦪ#ᐭ)XY#Zṹ/HCᓃ~^1᜜ṹ#ᨬF,-JFm=KGHCfTU#'`GHCLᦪ#GHCLᐭ#T'aLb;'ᙠ)⌴+ᦪ,-ᩩCLᦪ#LCb(GHCLTU,TU7GHC,`TUf##GHCL஺᎛gḄhi᜜ṹᨬF,-JFm=Lᡂ#Lᙢ
#Lᦪb

54(5)ᐵL(C##ᐭ)᎛⌱ṹ(C#)᜜ṹC#ᨬF,-JFm={(C#)Lᐭ},(C#)Lᐭ%7ᐰ+ᦪ,-஺lNᔜᐵiᐰṹ'ᙠ஺•8ஹᢣQᑡᐵ!"%no"Aqrsᳮᵫ஺জR(X,Y,Z)F={XY—Z}জR(X,Y,Z)F={Y-Z,XZ—Y}জR(X,Y,Z)F={Y-Z,Y-X,X-Y,X-Z}জR(X,Y,Z)F={X-Y,X—Z}জR(W,X,Y,Z)F={X-Z,WX—Y}•w:জR%BCNF஺R᎛⌱ṹyXY,Fz{ᨵL|+ᦪ,-#}~+ᦪ,-Ḅ01ᒹRḄ᎛⌱ṹXY஺ঝR%3NF஺R᎛⌱ṹyXYXZ,Rzᡠᨵឋ%ឋ#'ᙠឋ.᎛⌱ṹḄ)⌴,-஺ঞR%BCNF஺R᎛⌱ṹyXY,YX-YZ,#X-Y,X-Z,ᵫ/FzᨵY-Z,Y-X,Z%+ᦪ,-/X,}%)⌴+ᦪ,-/X஺..7ḄL+ᦪ,-Ḅ01ᒹL᎛⌱ṹ#R%BCNFoটR%BCNF஺RḄ᎛⌱ṹyX,}FzL|+ᦪ,-Ḅ01ᒹ᎛⌱ṹXoঠR%INF஺RḄ᎛⌱ṹyWX,ᑣY,Zyឋ#ᵫ/XfZ,Fz'ᙠឋ.᎛⌱ṹḄ1ᑖ+ᦪ,-஺1ஹINFஹ2NF3NFḄᩩ஺q7ᡂQ⚪L⊤᝞Q#ᐸ%ᔲ3NF,¢£ᐸᓄy¥ᔠ3NFḄᐵ஺(F⚪12ᑖ)ὃ¨ὃὃ«ᙢᡂ¬Dឋ©ὃ«CC᪥
ὃᡂ¬ᑖ

55nL"Ḅᐵ®Ḅᩩ%ᐗ°zḄL|ᑖ±²³%´ᑖᒘḄᦪ¶⚗஺n¸"#ᢣḄ%¹ºᐵ»nL"#}ᡠᨵឋ7ᐰ,-/ᐸṹ஺n¼"#ᢣḄ%¹ºᐵ»n¸"#}½Ḅ¾L|ឋ)⌴,-/¾ᐵ¿À஺ὃ34Áὃ¨C#D#ឋ©#ὃ᪥Âὃ«34Áὃ«C#ὃ«ᙢ
Âὃ«ᑖÃÁὃ¨C#ὃ«CÂᡂ¬Áὃ¨C#ὃᡂ¬#ᑖÂ2ஹL⊤᝞Q#ᐸ%ᔲ3NF,¢£ᐸᓄy¥ᔠ3NFḄᐵ஺Á12ᑖÂÍ®ᖪÍ®ᖪᙢÒ'èCÃÉÊCËÌᓫÑÉᙬ±ÃᐵÁèC#ÃÉ#ÊCËÌÂÍ®ᖪᐵÁÍ®ᖪÉ#Í®ᖪᙢᙬÂÃÒ'ᐵÁèC#Í®ᖪÉ#ᓫÑ#Ò'±Â3ஹINFஹ2NF3NFḄᩩ஺q7ᡂQ⚪ÔÕᦟᐵ#ᦟÁC#D#×#ឋ©###ØÙ#ᡂ¬Â#Ú~ᐵḄ¿%ÛÜ#/no"#yÛÜA᝞ݽ/3NF,Þ½Ëᑮ3NF஺4ஹáâQᑡᐵḄᐵ¿Àஹ"ãHä¢/3NF,ᑣ£ᐸᓄy3NF஺å1.çÒÁçÒC#☢é#ᵯëCṹ#ìC#ìÉ#ËÌ#Ò'ᦪ±Âå1íᫀçÒC+ìCä1NFäçÒÁçÒC#☢é#ᵯëCṹÂìÁìC#ìÉ#ËÌÂð'ÁçÒC#ìC#Ò'ᦪ±Âå2.ñÁᕒ¨C#ᕒD#óô¨C#óôÉ#óôõ#ñö÷Â#⚗óôᨵ2|ᕒñ#^ᕒ´2⚗óô஺å2íᫀᕒ¨C+óô¨Cä1NFäᕒÁᕒ¨C#ᕒDÂóôÁóô¨C,óôÉ#óôõÂñÁᕒ¨C#óô¨C#ñö÷Â

565ஹáâQᑡᐵḄᐵ¿Àஹ"ãHä¢/3NF,ᑣ£ᐸᓄy3NF,⌕ù|ᐵᑏLᩩûü஺Á1ý¨C#1ýÉ#ᡠᙠþÿᕒᕒ⚗⚗,⚜ᐭ⚗Ḅᢣᕒᙠ⚗Ḅ஺ᡠᙠ!"ᕒᕒᕒ⚗⚗⚗⚜#ᕒ⚗ᐭ⚗Ḅ