【文章內(nèi)容簡介】 .................................................................. 47 數(shù) 據(jù)庫系統(tǒng)的模式結(jié)構(gòu) .............................................................................................. 48 第 5 章 關(guān)系數(shù)據(jù)庫系統(tǒng) .............................................................................................................. 49 知識(shí)點(diǎn) ................................................................................................................................. 49 關(guān)系數(shù)據(jù)庫系統(tǒng) ........................................................................................................... 49 關(guān)系數(shù)據(jù)模型 .............................................................................................................. 49 關(guān)系模型的基本術(shù)語 .................................................................................................. 50 關(guān)系的形式定義 .......................................................................................................... 50 關(guān)系數(shù)據(jù)庫對關(guān)系的限定 .......................................................................................... 51 關(guān)系模型的完整性約束 .............................................................................................. 51 實(shí)體完整性規(guī)則 .......................................................................................................... 51 參照完整性規(guī)則 .......................................................................................................... 51 用戶定義的完整性 ...................................................................................................... 51 關(guān)系代數(shù) .................................................................................................................... 52 傳統(tǒng)的集合運(yùn)算 ........................................................................................................ 52 專門的關(guān)系運(yùn)算 ........................................................................................................ 52 重點(diǎn)難點(diǎn) ............................................................................................................................. 53 關(guān)系模型的數(shù)據(jù)結(jié)構(gòu) .................................................................................................. 53 關(guān)系數(shù)據(jù)庫對關(guān)系的限定 .......................................................................................... 55 關(guān)系模型完整性規(guī)則 .................................................................................................. 55 用完整性規(guī)則檢查數(shù)據(jù)庫操作 .................................................................................. 57 關(guān)系代數(shù) ...................................................................................................................... 58 第 6 章 關(guān)系數(shù)據(jù)庫標(biāo)準(zhǔn)語言 SQL ............................................................................................. 62 4 知識(shí)點(diǎn) ................................................................................................................................. 62 結(jié)構(gòu)化查詢語言 SQL .................................................................................................. 62 SQL 數(shù)據(jù)庫體系結(jié)構(gòu) ................................................................................................... 62 SQL 的數(shù)據(jù)定義 ........................................................................................................... 62 基本表 .......................................................................................................................... 63 索引 .............................................................................................................................. 64 視圖 .............................................................................................................................. 65 SQL 的數(shù)據(jù)操縱 ........................................................................................................... 65 查詢語句 ...................................................................................................................... 65 修改語句 ...................................................................................................................... 65 SQL 的數(shù)據(jù)控制 ......................................................................................................... 66 嵌入式 SQL ................................................................................................................ 66 重點(diǎn)難點(diǎn) ............................................................................................................................. 67 數(shù)據(jù)查詢 ...................................................................................................................... 67 數(shù)據(jù)修改 ...................................................................................................................... 78 視圖 .............................................................................................................................. 80 嵌入式 SQL .................................................................................................................. 83 第 7 章 關(guān)系數(shù)據(jù)庫規(guī)范化理論與數(shù)據(jù)庫設(shè)計(jì) .......................................................................... 85 知識(shí)點(diǎn) ................................................................................................................................. 85 關(guān)系模式的設(shè)計(jì)問題 .................................................................................................. 85 數(shù)據(jù)依賴 ...................................................................................................................... 85 函數(shù)依賴 ...................................................................................................................... 85 多值依賴 ...................................................................................................................... 86 函數(shù)依賴的邏輯蘊(yùn)含 .................................................................................................. 86 碼 .................................................................................................................................. 86 Armstrong 公理系統(tǒng) ................