數據庫原理及應用英教學日歷

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

2、英）考試（考核）方式實驗操作閉卷考試期末考試成績約占50；課程設計占30%；平時成績占20；平時成績包括網絡作業(yè)40% + 考勤30% + 實驗操作30%時間地點從第1周至第18周周三 實409 1/2節(jié)周五 實409 3/4節(jié)教 學 任 務 安 排授課教師姓名職稱理論課學時討論學時答疑學時其他方式學時教學的主要內容（章節(jié)）胡毅副教授（內）402426課 程 教 學 進 程周序課次學時數教學主要內容授課教師執(zhí)行情況理論實踐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