Introduction to Database Systems 資料庫系統導論 (CSIE: BFCZ005)
Spring semester, 2022 CSIE BS2A (資工二甲)Thursday 13:30 ~ 16:30, 圖資大樓0802
Instructor: Kuo-Chuan Wu 吳國銓
Email: kcwu@nptu.edu.tw
Office hour: Mon. 13:30-16:30 & Tue. 09:00-12:00, or by appointment
- This is an introductory course in database systems. This course includes, but is not limited to, the study of data models, query languages, transactions, parallel data processing, implementation techniques of database management systems.
- After successfully completing the course, students will have fundamental principles of database design to prepare for professional courses and techniques covered.
Course Schedule & Important Date
| # | Date | Topics | Remark |
|---|---|---|---|
| 1 | 02/24 | Introduction to Course Overview | |
| 2 | 03/03 | Basic PHP and Development Environment | |
| 3 | 03/10 | Basic PHP and Development Environment | |
| 4 | 03/17 | Relational Databases | |
| 5 | 03/24 | Relational Databases | |
| 6 | 03/31 | The Entity-Relationship Data Model | |
| 7 | 04/07 | The Entity-Relationship Data Model | |
| 8 | 04/14 | The Entity-Relationship Data Model | |
| 9 | 04/21 | Midterm Exam | |
| 10 | 04/28 | Collaborative Teaching | |
| 11 | 05/05 | Collaborative Teaching | |
| 12 | 05/12 | Collaborative Teaching | |
| 13 | 05/19 | Normalization | |
| 14 | 05/26 | Relational Algebra | |
| 15 | 06/02 | The database language-SQL | |
| 16 | 06/09 | The database language-SQL | |
| 17 | 06/16 | The database language-SQL | |
| 18 | 06/23 | The database language-SQL |
Final Project
| ID No. | Name | Title | Reference | Remark |
|---|---|---|---|---|
| CBB107024 | 管〇豪 | 書櫥 | 私人圖書館 | 03/24 16:25 |
| CBB107050 | 邱〇旻 | |||
| CBB108010 | 蔡〇吏 | ZOO | 全國動物收容管理系統 | 03/31 14:59 |
| CBB108057 | 陳〇琪 | HyRead ebook 國立屏東大學 | 04/11 23:50 | |
| CBB109101 | 洪〇憲 | Dcard | 04/28 15:42 | |
| CBB109102 | 楊〇安 | 個人資料及商品庫存管理網站 | 美商玫琳凱台灣分公司 | 03/28 00:26 |
| CBB109103 | 邱〇凱 | |||
| CBB109104 | 徐〇瀚 | Minecraft 合成查詢 | Minecraft wiki | 05/26 12:15 |
| CBB109105 | 蔡〇龍 | Opple | Apple | 05/26 11:00 |
| CBB109106 | 簡〇定 | 蟹殼 | 蝦皮 | 05/12 15:13 |
| CBB109107 | 趙〇葳 | 家族回憶 | 巴哈姆特動畫瘋 | 03/31 14:08 |
| CBB109108 | 徐〇友 | Disney+ | 05/04 21:44 | |
| CBB109109 | 陳〇全 | 人物自傳 | 散戶中的霸主 | 05/27 11:15 |
| CBB109110 | 涂〇淳 | 雲端餐廚 | ichef | 04/30 23:24 |
| CBB109111 | 柯〇明 | Arknight Tools | prts.wiki | 05/26 15:!3 |
| CBB109112 | 周〇勛 | 網匪 | Netflix | 04/07 14:38 |
| CBB109113 | 古〇懷 | 線上菜單/點餐 | 麥當勞 | 05/23 01:30 |
| CBB109114 | 顏〇佑 | 惡名昭彰購物網站 | 03/31 08:30 | |
| CBB109115 | 侯〇龍 | 醫院 | 成大醫院 | 05/26 17:30 |
| CBB109117 | 黃〇桀 | 全揚撞球運動用品專賣店 | 03/31 14:58 | |
| CBB109118 | 羅〇邑 | |||
| CBB109119 | 洪〇倫 | 七輪手作炭烤吐司 | 04/28 20:14 | |
| CBB109120 | 劉〇瑋 | 寶可夢圖鑑-關都地區 | 神奇寶貝百科 | 05/02 19:18 |
| CBB109121 | 洪〇宏 | 學生基本資料資料庫 | 03/29 19:03 | |
| CBB109122 | 陳〇嘉 | 小說網站 | 05/16 13:42 | |
| CBB109123 | 謝〇倫 | 子龍傳奇 | 華碩電腦 | 05/05 10:08 |
| CBB109124 | 蔡〇翰 | nike 鞋款 | Nike | 06/02 14:27 |
| CBB109125 | 王〇康 | Discord | 03/24 16:00 | |
| CBB109126 | 陳〇文 | |||
| CBB109129 | 鄧〇承 | 台股籌碼激戰 | 玩股網 | 05/26 08:30 |
| CBB109130 | 蔡〇霖 | 40噗 | 91譜 | 05/25 17:19 |
| CBB109131 | 吳〇霖 | |||
| CBB109132 | 吳〇鋐 | 淘寶 | 05/26 13:41 | |
| CBB109133 | 高〇欽 | 餐廳前後廚餐點監控 | 05/26 13:59 | |
| CBB109134 | 林〇宏 | 蠟ove Car | WAXUP | 04/13 16:05 |
| CBB109135 | 嚴〇保 | |||
| CBB109136 | 黃〇慶 | |||
| CBB109137 | 朱〇瑋 | |||
| CBB109138 | 吳〇群 | eMask 線上預購口罩 | 04/29 10:10 | |
| CBB109139 | 劉〇燁 | 機票查詢及線上預訂 | 阿提哈德航空 | 05/20 11:16 |
| CBB109140 | 黃〇仁 | 來買水 | 會員資料管理 | 03/31 15:16 |
| CBB109142 | 張〇昌 | FPHWW | 金玉堂 | 04/28 21:41 |
| CBB109143 | 吳〇翰 | 傳說角色BP | 傳說對決 | 05/26 13:50 |
| CBB109144 | 陳〇綺 | LNG圖鑑 | LNG 實況存檔 | 04/10 22:21 |
| CBB109145 | 林〇容 | 新路穀物語遊戲資訊 | Stardew Valley 中文维基 | 04/14 15:53 |
| CBB109146 | 方〇欣 | 全家會員優惠攻略 | 全家會員 | 04/14 16:05 |
| CBB109147 | 盧〇璆 | STEAM | STEAM | 04/14 15:52 |
| CBB110213 | 李〇發 | 高雄國際航空站 | 高雄國際航空站 | 05/10 15:39 |
| CBE108017 | 蔡〇謙 | Λura CTF | CTFd | 03/31 00:27 |
| CBE109013 | 劉〇安 | Banking | 中信網路銀行 | 05/04 16:06 |
| CBE109021 | 黃〇翰 | BSTAR | 台灣之星 | 05/12 11:53 |
| CEJ108037 | 平〇甄 | 模擬租書網 | Renta | 04/07 22:52 |
Reference Textbooks
- 動畫圖解資料庫系統理論，李春雄(全華圖書)
- Fundamentals of Database Systems (7th ed.) by Ramez Elmasri and Shamkant B. Navathe (Pearson)
- Sams Teach Yourself SQL in 10 Minutes (4th ed.) by Ben Forta (Pearson Education)
- Database System Concepts (6th ed.) by A. Silberschatz, H. F. Korth, and S. Sudarshan (McGraw-Hill)
- A First Course in Database Systems (3rd ed.) by Jeffrey D. Ullman and Jennifer Widom (Pearson)
Grading Policy
- Class participation 10%
- Midterm exam 30%
- Final project 60%