教學大綱與進度

課程基本資料：

學年期	課號	課程名稱	階段	學分	時數	修	教師	班級	人	撤	備註
115-1	362048	資料庫系統	1	3.0	3	▲	劉建宏	資工三	89	1

教學大綱與進度：

教師姓名	劉建宏　教師諮商時間(Office Hours)
Email	cliu@ntut.edu.tw
最後更新時間	2026-08-20 11:57:32
課程大綱	This course is designed to introduce concepts and skills essential in the database systems. Relational database will be the main focus with related topics such as relational model, design concepts, and structured query language. The topics to be covered include: introduction to database systems, record storage and file organizations, indexed structures for files, the relational model, relational algebra and calculus, SQL, conceptual and logical design for relational database, functional dependencies, normalization and database management system technology.
課程進度 (1-16週)	Week Topics ---- ----------------------------- 1 Databases and Database User 2 Database System Concepts & Architecture 3 Entity-Relationship Data Modeling 4 Enhanced Entity-Relationship & UML Modeling 5 Relational Data Model & Constraints 6 Relational Database Design 7 SQL 8 Midterm Exam 9 Project Presentation 10 More SQL 11 Functional Dependencies and Normalization 12 Relational Database Design Algorithms 13 Practical Database Design Methodology 14 Disk Storage and Basic File Structures 15 Indexing Structures for Files 16 Final Exam 17 Project Presentation 18 Project Presentation
彈性學習 (17-18週)	類別 ● 學生分組實作及討論(Student group practice and discussion) ● AI 輔助學習與工具應用(AI-assisted learning and tool application) 內容 學生分組進行專題報告、系統展示、以及回答教師提問，包含如何使用AI工具進行專題實作與報告。 時數 (小時) 6 學習成果 學生繳交資料庫系統專題報告、相關實作成果，以及展示影片。 評量比例 期末專題報告約佔總成績8%，報告內容包含User Scenarios, System Architecture Diagram, ER Model, Normalization (Functional Dependency), SQL Examples, AI Tools, System Demo等。
評量方式與標準	1. Homework and Attendance (15%)                        2. Exams  a. Midterm (30%)            b. Final (30%)                 3. Team Project (25%)
使用教材、參考書目或其他	【遵守智慧財產權觀念，請使用正版教科書，不得使用非法影印教科書】 使用外文原文書：是 Textbook: Ramez Elmasri and Shamkant B. Navathe, Fundamentals of Database Systems, 7th Edition, Pearson, 2017. Reference Books: Abraham Silberschatz, Henry F. Kotth, and S. Sudarshan, Database System Concepts, 7th Edition, McGraw Hill, 2019. Thomas Connolly and Carolyn Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, 6th Edition, Pearson Education Limited, 2015.
課程諮詢管道	Please contact instructor in person during office hours or email to instructor.
延伸教學與資源	● 參與式創新教學 (Participatory & Innovative Teaching) 強調學生參與與產出，導入翻轉、PBL/專題、設計思考或遊戲化等策略。 Emphasizes student engagement and outcomes by adopting strategies such as Flipped Classroom, PBL (Problem/Project- Based Learning), Design Thinking, or Gamification. ● 數位科技融入 (Digital Technology Integration) 運用生成式AI、VR/AR、IoT、IRS等新興科技輔助教學與評量。 Utilizes emerging technologies such as Generative AI, VR/AR, IoT, and IRS (Interactive Response Systems) to facilitate teaching and assessment.
課程對應SDGs指標	SDG3：良好健康和福祉（Good Health and Well-being） SDG4：優質教育（Quality Education） SDG8：尊嚴就業與經濟發展（Decent Work and Economic Growth） SDG9：產業創新與基礎設施（Industry, Innovation and Infrastructure）
課程是否導入AI	● 鼓勵學生使用生成式AI工具（Encourage students to use generative AI tools）
備註	The course will be offered online using MS Teams during the period of Level 3 COVID-19 Alert. The Teams link created by school will be used. Check the course web page at Taipei Tech i-School Plus (https://istudy.ntut.edu.tw/learn/index.php) or email instructor for details.