資料庫系統概論
Introduction to Database Systems
| 節 | 週四 |
|---|---|
3 10:10–11:00 | 資料庫系統概論 ED117 2 節連堂 |
4 11:10–12:00 |
* 根據陽明交大上課時間表所列
A database system is designed to be built and populated with data for a certain task. In this course, we will introduce the core concepts and key technologies of database systems. At the end of the semester, you need to build an application (using Java, Python, R, or others) with databases.
Programming, Web Programming, Data Structures
100 points = 20% midterm + 20% final exam + 20% final project + 20% homework + 10% quiz in the class + 10% course engagement
| 週次 | 主題 |
|---|---|
| 第 1 週 | Introduction Introduction to DB |
| 第 2 週 | Introduction to the Relational Model |
| 第 3 週 | Introduction to SQL |
| 第 4 週 | Introduction to SQL + Intermediate SQL |
| 第 5 週 | Intermediate SQL |
| 第 6 週 | Database Design Using The E-R Model |
| 第 7 週 | Relational Database Design - Normalization |
| 第 8 週 | Midterm |
| 第 9 週 | Relational Database Design - Normalization |
| 第 10 週 | Indexing |
| 第 11 週 | Physical Storage Systems + Data Storage Structures |
| 第 12 週 | Query Processing |
| 第 13 週 | Query Processing + Query Optimization |
| 第 14 週 | Query Optimization |
| 第 15 週 | Transactions |
| 第 16 週 | Concurrency |
| 第 17 週 | Final exam |
| 第 18 週 | Introduction to NoSQL Database |
Textbook: Abraham Silberschatz , Henry Korth , S. Sudarsha, “Database System Concepts,” 7th Edition, McGraw-Hill, 2020. ISBN10: 0078022150 https://www.mheducation.com/highered/product/database-system-concepts-silberschatz-korth/M9780078022159.html Reference Books: T. Connolly and C. Begg, “Database Systems: A Practical Approach to Design, Implementation, and Management,”6th Edition, Pearson, 2014.