1. 了解企業經營與「資料庫」、「資料庫系統」之間的關係。
2. 具備「資料庫系統」的概念設計與邏輯設計能力。
3. 具備「資料庫管理系統」之操作能力。
4. 簡單「資料庫系統」的專案開發。第1~8週了解商用資料庫系統開發方法、正規化技術、實體關係圖、SQL語法、以及 Microsoft Access 基本操作;
第10~14週則開發資料庫系統及 Microsoft Access 進階操作;
畢業考後(第15~17週)則結合 ASP.NET 設計網頁式資料庫系統(此部分四年級同學可自行決定是否修習)。1. Understand the relationship between business operations and "databases" and "database systems".
2. Have the conceptual design and logical design capabilities of "database system".
3. Have the ability to operate "database management system".
4. Project development of simple "database system". Weeks 1 to 8: Understand commercial database system development methods, formalization techniques, entity relationship diagrams, SQL syntax, and basic operations of Microsoft Access;
Weeks 10 to 14 will develop database systems and advanced operations of Microsoft Access;
After the graduation exam (weeks 15 to 17), you will design a web-based database system using ASP.NET (fourth-year students can decide whether to study this part).
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. "Database System Development" Reference Book
(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 Yunhuan (2010), Theory and Practice of Database Systems, Huatai Book Company.
(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 Hui'an (2021), Access database system theory and practice, fifth edition, Qibiao Publishing House[Recommended purchase]< br />
(2) Yang Shiying (2011), Access 2010 carefully selected textbooks, Qifeng Publishing House
(3) Shi Weiming Research Laboratory (2011), Database Theory and Practice ACCESS 2010, Qibiao Publishing House
(4) Chen Hui'an (2008), A thorough study of ASP.NET 4.6 web page production (using Visual Basic), Banner Publishing House
評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
---|---|---|
課堂參與及作業課堂參與及作業 Class participation and assignments |
30 | |
小考小考 Quiz |
20 | |
期中考期中考 midterm exam |
20 | |
期末專案期末專案 Final project |
30 |