教學大綱與進度
課程基本資料:
學年期
課號
課程名稱
階段
學分
時數
修
教師
班級
人
撤
備註
99-1
138992
資料庫
1
3.0
3
★
林敏勝
電機所
47
1
教學大綱與進度:
教師姓名
林敏勝
Email
mslin@ee.ntut.edu.tw
最後更新時間
2010-09-11 23:16:36
課程大綱
這門課程主要是介紹資料庫系統的理論與應用,內容包含有: 1. 資料庫系統的介紹與架構 2. ER 資料模式 3. 檔案儲存結構 4. 關連式資料模式 5. SQL 查詢語言 6. ER資料模式與關連式資料模式之間的轉換 7. 資料庫正規化 8. 交易處理
課程進度
Week 1 Introduction to Databases Week 2 The Basic (Flat) Relational Model Week 3 SQL: Data Definition, Constraints, and Basic Queries and Updates(I) Week 4 SQL: Data Definition, Constraints, and Basic Queries and Updates(II) Week 5 SQL: Advanced Queries, Assertions, Triggers, and Views Week 6 Formal Relational Languages: The Relational Algebra Week 7 Conceptual Data Modeling Using the Entities and Relationships (ER) Week 8 Mapping a Conceptual Design into a Logical Design Week 9 Midterm Week 10 MySQL & PHP Week 11 Database Design Theory: Introduction to Normalization Using Functional and Multivalued Dependencies (I) Week 12 Database Design Theory: Introduction to Normalization Using Functional and Multivalued Dependencies (II) Week 12 Database Design Theory: Normalization Algorithms Week 13 Foundations of Database Transaction Processing Week 14 Introduction to Protocols for Concurrency Control in Databases Week 15 Database File Organizations: Unordered, Ordered, and Hashed files of Records Week 16 Database File Indexing Techniques, B-Trees, and B+-Trees Week 17 Term Project Week 18 Final
評量方式與標準
Homework 10% Midterm 30% Final 30% Project 30%
使用教材、參考書目或其他
【遵守智慧財產權觀念,請使用正版教科書,不得使用非法影印教科書】
使用外文原文書:
Database Systems (Models, Languages, Design, and Application Programming), Sixth Edition by Elmasri & Navathe, PEARSON
課程諮詢管道
備註