1. 了解企業經營與「資料庫」、「資料庫系統」之間的關係。
2. 具備「資料庫系統」的概念設計與邏輯設計能力。
3. 具備「資料庫管理系統」之操作能力。
4. 簡單「資料庫系統」的專案開發。第1~8週了解商用資料庫系統開發方法、正規化技術、實體關係圖、SQL語法、以及 Microsoft Access 基本操作；
第10~14週則開發資料庫系統及 Microsoft Access 進階操作；
畢業考後(第15~17週)則結合 ASP.NET 設計網頁式資料庫系統(此部分四年級同學可自行決定是否修習)。1. Understand the relationship between enterprise operations and "database" and "database system".
2. Have the concept design and logical design capabilities of "database system".
3. Have the operational capabilities of "database management system".
4. Simple project development of “Database System”. Weeks 1 to 8 learn about commercial database system development methods, regularization techniques, physical relationship diagrams, SQL syntax, and basic Microsoft Access operations;
The database system and Microsoft Access advanced operations will be launched from the 10th to 14th weeks;
After the graduation exam (weeks 15th to 17th), ASP.NET will be combined with ASP.NET to design a web-based database system (this part of the fourth-year students can decide whether to review it by themselves).
1.「資料庫系統開發」參考用書
(1) Hoffer, Jeffrey A., V. Ramesh, and Heikki Topi(2019), Modern Database Management (13/e), Upper Saddle River, NJ: Prentice Hall.
(2) 曾守正、周韻寰 (2010)，資料庫系統之理論與實務，華泰書局。
(3) Elmasri, Ramez and Shamkant B. Navathe, (2016). Fundamentals of Database Systems (7/e), New York, NY:Addison Wesley.
2. 「資料庫管理系統」工具用書
(1) 陳會安(2021)，Access 資料庫系統理論與實務，第五版，旗標出版社 [建議購買]
(2) 楊世瑩(2011)，Access 2010 嚴選教材，碁峰出版社
(3) 施威銘研究室(2011)，資料庫理論與實務ACCESS 2010，旗標出版社
(4) 陳會安(2008)，ASP.NET 4.6網頁製作徹底研究 (使用Visual Basic)，旗標出版社
1. Reference book for "Development of Database System"
(1) Hoffer, Jeffrey A., V. Ramesh, and Heikki Topi(2019), Modern Database Management (13/e), Upper Saddle River, NJ: Prentice Hall.
(2) Zeng Shouzheng and Zhou Yihuan (2010), Theory and Practice of Database System, Huatai Bookstore.
(3) Elmasri, Ramez and Shamkant B. Navathe, (2016). Fundamentals of Database Systems (7/e), New York, NY:Addison Wesley.
2. "Database Management System" tool book
(1) Chen Hengan (2021), Access Database System Theory and Practice, Fifth Edition, Flag Press[Suggest to buy]< br />
(2) Yang Shi-hwan (2011), Access 2010 Strictly selected textbooks, Qifeng Publishing House
(3) Shiweishan Research Office (2011), Database Discussion and Practice ACCESS 2010, Flag Press
(4) Chen Hengan (2008), ASP.NET 4.6 web production basic research (using Visual Basic), Flag Press
| 評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
|---|---|---|
| 課堂參與及作業課堂參與及作業 Class participation and work |
30 | |
| 小考小考 Small exam |
20 | |
| 期中考期中考 Midterm exam |
20 | |
| 期末專案期末專案 Final period project |
30 |
