資料庫系統概論
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 will be able to: 1. Describe what is database and database system 2. Apply query language to manipulate data 3. Design a database with real-world datasets 4. Develop an application with database system and real-world datasets 5. Identify sources of information and solutions on AWS manuals/instructions
Programming, Web Programming, Data Structures
2 hours on-site class + 1 hour online learning
100 points = 20% midterm + 20% final exam + 20% final project + 20% homework + 10% quiz in the class + 10% course engagement
| 週次 | 主題 |
|---|---|
| 第 1 週 | Introduction to DB |
| 第 2 週 | Introduction to the Relational Model |
| 第 3 週 | Holiday |
| 第 4 週 | Introduction to SQL + Intermediate SQL |
| 第 5 週 | Intermediate SQL |
| 第 6 週 | Database Design Using The E-R Model |
| 第 7 週 | Database Design Using The E-R Model |
| 第 8 週 | Relational Database Design - Normalization |
| 第 9 週 | Midterm |
| 第 10 週 | Relational Database Design - Normalization |
| 第 11 週 | Relational Database Design - Normalization |
| 第 12 週 | Indexing |
| 第 13 週 | Physical Storage Systems + Data Storage Structures |
| 第 14 週 | Query Processing + Query Optimization |
| 第 15 週 | Query Optimization |
| 第 16 週 | Final exam |
| 第 17 週 | Final project - present & evaluation |
| 第 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.