1、廣東外語外貿(mào)大學(xué)南國(guó)商學(xué)院全日制本科教學(xué)日歷20132014學(xué)年 第二學(xué)期課 程 名 稱 數(shù)據(jù)庫(kù)原理及應(yīng)用 課 程 性 質(zhì) 專業(yè)必修課 學(xué) 時(shí) 72 學(xué) 分 4 適用專業(yè)（方向） 計(jì)算機(jī)科學(xué)與技術(shù) 學(xué)生年級(jí)、人數(shù) 2012計(jì)科（雙語班） 26人 開 課 單 位 信息科學(xué)技術(shù)系 授課教師姓名、職稱 胡毅 副教授（內(nèi)） 教 務(wù) 處 制二0一一年九月學(xué)時(shí)分配課堂講授專題討論實(shí)驗(yàn)、社會(huì)實(shí)踐、見習(xí)或?qū)嵙?xí)自學(xué)指導(dǎo)其他402264使用教材名 稱出版社版次與出版時(shí)間教材類別數(shù)據(jù)庫(kù)系統(tǒng)基礎(chǔ)教程(英文版)(第3版)機(jī)械工業(yè)出版社2008-8-1第1版經(jīng)典原版書庫(kù)授課語言全中文雙語（注明語種）全外語（注明語種）是（

2、英）考試（考核）方式實(shí)驗(yàn)操作閉卷考試期末考試成績(jī)約占50；課程設(shè)計(jì)占30%；平時(shí)成績(jī)占20；平時(shí)成績(jī)包括網(wǎng)絡(luò)作業(yè)40% + 考勤30% + 實(shí)驗(yàn)操作30%時(shí)間地點(diǎn)從第1周至第18周周三 實(shí)409 1/2節(jié)周五 實(shí)409 3/4節(jié)教 學(xué) 任 務(wù) 安 排授課教師姓名職稱理論課學(xué)時(shí)討論學(xué)時(shí)答疑學(xué)時(shí)其他方式學(xué)時(shí)教學(xué)的主要內(nèi)容（章節(jié)）胡毅副教授（內(nèi)）402426課 程 教 學(xué) 進(jìn) 程周序課次學(xué)時(shí)數(shù)教學(xué)主要內(nèi)容授課教師執(zhí)行情況理論實(shí)踐112Chapter 1: The Worlds of Database Systems22Chapter 2: Data Models and Basics of the

3、Relational Model2311Chapter 2: Defining a Relation Schema in SQL 411Chapter 2: An Algebraic Query Language3511Chapter 2: Constraints on Relations and Exercises62Chapter 3: Functional Dependencies and Rules472Chapter 3: Design of Relational Database Schemas82Chapter 3: The Third Normal Form and Multi

4、valued Dependence5911Chapter 4: The Entity/Relationship Model1011Chapter 4: Design Principles and Constraints in E-R Model6112Chapter 4: Weak Entity Sets and From E-R to Relational Design122Chapter 5: Relational Operations on Bags and Extended Operators71311Chapter 5: A Logic for Relations and Datal

5、og1411Chapter 6: Simple Queries in SQL81511Chapter 6: Queries Involving More Than One Relation1611Chapter 6: Subqueries91711Chapter 6: Full-Relation Operations1811Chapter 6: Database Modifications and Transactions in SQL101911Chapter 7: Key、Foreign keys and Constraints2011Chapter 7: Assertions and T

6、riggers112111Chapter 8: Virtual Views and Modifying Views2211Chapter 8: Indexes in SQL and Selection of Indexes12232Chapter 9: The Three-Tier Architecture and The SQL Environment2411Chapter 9: The SQL/Host-Language Interface13252Chapter 9: Stored Procedures and Using a Call-Level Interface2611Chapte

7、r 9: JDBC、PHP and VS142711Chapter 10: Security and User Authorization in SQL2811Chapter 10: Recursion in SQL and The Object-Relational Model152911Chapter 10: User-Defined Types in SQL and Operations on O/R Data3011Chapter 10: On-Line Analytic Processing and Data Cubes163111Chapter 11: Semistructured Data and XML3211Chapter 11: Document Type Definitions and XML Schema173311Chapter 12: P