1166 - 商用資料庫

Database Systems

教育目標 Course Target

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).

參考書目 Reference Books

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, Banner Publishing House [Recommended purchase]
(2) Yang Shiying (2011), Access 2010 carefully selected textbooks, Qifeng Publishing House
(3) Shi Weiming Research Laboratory (2011), Database Theory and Practice ACCESS 2010, Banner Press
(4) Chen Huian (2008), A thorough study of ASP.NET 4.6 web page production (using Visual Basic), Banner Publishing House

評分方式 Grading

評分項目
Grading Method
配分比例
Percentage
說明
Description
課堂參與及作業
Class participation and assignments
30
小考
Quiz
20
期中考
midterm exam
20
期末專案
Final project
30

授課大綱 Course Plan

點擊下方連結查看詳細授課大綱
Click the link below to view the detailed course plan

查看授課大綱 View Course Plan

相似課程 Related Courses

課程代碼
Course Code
課程名稱
Course Name
授課教師
Instructor
時間地點
Time & Room
學分
Credits
操作
Actions
選修-1257
企管系3,4 張榮庭 四/2,3,4[M024] 3-0 詳細資訊 Details

課程資訊 Course Information

基本資料 Basic Information

  • 課程代碼 Course Code: 1166
  • 學分 Credit: 3-0
  • 上課時間 Course Time:
    Thursday/2,3,4[M024]
  • 授課教師 Teacher:
    張榮庭
  • 修課班級 Class:
    共選修3,4(管院開)
  • 選課備註 Memo:
    第一週務必到課,未到且未請假者視同棄選。當日人工加簽。與企管系1257「商用資料庫」課程併班上課。
選課狀態 Enrollment Status

目前選課人數 Current Enrollment: 19 人

交換生/外籍生選課登記

請點選上方按鈕加入登記清單,再等候任課教師審核。
Add this class to your wishlist by clicking the button above.