課程資源-復(fù)試數(shù)據(jù)庫(kù)期末復(fù)習(xí)chreview

ChapterChapterTheRelationalCh2Ch2TheRelationalTheCAPNamingthePartsofaRelationalKeys,Superkeys,andNullRelationalSet-TheoreticNativeRelationalTheInterdependenceofIllustrativeOtherRelational DatabasePrinciples& 2.22.2NamingthePartsofaOld:fileofColumnnamesOld:fieldnamesofRowsOld:recordsofaOld:setof DatabasePrinciples& 2.22.2NamingthePartsofa（關(guān)系（表Fileof（屬性（列（元組（行（模式（表頭Typeof DatabasePrinciples& 2.22.2NamingthePartsofatable columnt 2tablerow

DatabasePrinciples& 2.32.3RelationalRule1.FirstNormalFormCan'thavemulti-valuedRule2.AccessRowsbyContentOnlyCan'tsay:thethirdrowdownfromtheNoordertotheNoordertotheRule3.TheUniqueRowEntityIntegrityRule(實(shí)體完整性 DatabasePrinciples& 2.42.4Keys,Superkeys,andNullKey&Primary DatabasePrinciples& 2.42.4Keys,Superkeys,andNullTheorem2.4.2.EverytableThasatleastoneProof.GivenatableTwithHead(T)={A1...KHead(T則K是表T的一個(gè)超鍵(superkey)While(K是表T的超鍵){THEN{K:=S;continue;}ELSEbreak;}Returnkey‘K’for DatabasePrinciples& 2.4Keys,Superkeys,andNull2.4Keys,Superkeys,andNull DatabasePrinciples& 2.52.5Relational languageintroducedbyE.F.storedintheformof

resultsofaqueryintableformoperationsofrelationalalgebra DatabasePrinciples& 2.5Relational2.5Relational(并∪R∪(交∩R∩(差–R–(乘積R DatabasePrinciples& nativerelational(投影R[R[Ai1,…,Aik(選擇RwhereRwhereRwhereA1=5(聯(lián)接R(除法RDifferencebetweenjoinandT=RT=R÷{B1,…,Bm{A1,A2,…,An DatabasePrinciples&

ArowtisinthetableRSifandonlytherearetworowsuinRandvinS,suchthatu[Bi]=v[Bi]foralli(1ik);t[Ai]=u[Ai]foralli,1int[Ci]=v[Ci]foralli,1imt[Bi]=u[Bi]=v[Bi]foralli,TcontainsthelargestpossiblesetofrowstsuchthatforeachrowsinS,wecanfindonerowrinR,wheret(Ai)=r(Ai)for1in s(Bj)=r(Bj)for1jmch2ch21：關(guān)系的合并運(yùn)2：特殊運(yùn)算（‘差’運(yùn)算）的使用方3：‘除’運(yùn)算與‘聯(lián)接’運(yùn)算的區(qū)4：特殊運(yùn)算（除算）的使用方

正確的表示方‘差‘除’運(yùn)算與‘聯(lián)接’運(yùn)算的區(qū) 查詢的結(jié)果關(guān)系稱為‘目標(biāo)對(duì)象在決定某個(gè)元組t是否屬于結(jié)果關(guān)系A(chǔ)rowtisinthetableRSifandonlyiftherearetworowsuinRandvinS,suchthatu[Bi]=v[Bi]forallit[Ai]=u[Ai]foralli,1int[Ci]=v[Ci]foralli,1imt[Bi]=u[Bi]=v[Bi]foralli, DatabasePrinciples& DatabasePrinciples& ‘除’運(yùn)算表達(dá)式的表示方‘被除數(shù)’關(guān)系中必須包含目標(biāo)對(duì)象和條件對(duì)象’‘除數(shù)關(guān)系中只含‘條’ChapterBasicSQLQueryCh3Ch3BasicSQLQuerySettingUptheSimpleSelectUNIONOperatorsandFORALLSomeAdvancedSQLSetFunctionsinGroupsofRowsinACompleteDescriptionofSQLInsert,Update,andDelete DatabasePrinciples& BasicBasicDataTypeinSQLCREATESimpleSelectRelationalAlgebravsSQLQuerysingletable,product,naturaljoin,thetajointable&columnSimpleSELECTSQL查詢語(yǔ)句(Selectstatement)BETWEEN…ANDIS結(jié)果排序：ORDERSimpleSelectTheINexpr[NOT]IN(subquery fiedComparisonexprSOME|ANY|ALL(subqueryTheEXISTS[NOT]EXISTS(subqueryTheBETWEENexpr[NOT]BETWEENexpr1ANDSimpleSimpleSelectpredicateTheISNULLcolumnIS[NOT]TheLIKEcolumn[NOT]LIKEval1[ESCAPEval2underscore(_):anysinglepercent(%):anysequenceofzeroormorecharacters子查詢表名的作用獨(dú)立子查相關(guān)子查查詢謂 NOTSOME/ANY/ NOT復(fù)