教學大綱與進度

課程基本資料：

學年期	課號	課程名稱	階段	學分	時數	修	教師	班級	人	撤	備註
111-2	312303	資料庫系統	1	3.0	3	▲	劉建宏	電資外生三	20	0

教學大綱與進度：

教師姓名	劉建宏　教師諮商時間(Office Hours)
Email	cliu@ntut.edu.tw
最後更新時間	2022-12-20 10:10:58
課程大綱	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.
課程進度	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 Algebra and Calculus 7 Relational Database Design 8 SQL 9 Midterm Exam 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 Transaction Processing Concepts and Theory 17 Project Presentation 18 Final Exam
評量方式與標準	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.
課程諮詢管道	The instructor is available for tutoring or consultations by students during the following scheduled office hours in the Technology Research Building, Room 1523. Tuesday: 9:00am-12:00pm Thuresday: 9:00am-12:00pm
課程對應SDGs指標
課程是否導入AI
備註	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 https://myweb.ntut.edu.tw/~cliu/courses/db/db.htm or email instructor for details.