| Relevance of Course Objectives and Core Learning Outcomes(%) |
Teaching and Assessment Methods for Course Objectives |
| Course Objectives |
Competency Indicators |
Ratio(%) |
Teaching Methods |
Assessment Methods |
1.建立對於資料庫系統之初步認識
2.培養運用結構化查詢語言(SQL)來操作資料庫之能力
3.使用Tableau進行資料視覺化 |
| 1.Independent Thinking |
| 2.Professional Knowledge with Applications |
| 7.Expression and Communication |
| 8.Cooperation and Coordination |
|
|
| Exercises |
| Discussion |
| Lecturing |
|
| Written Presentation |
| Attendance |
| Oral Presentation |
| Assignment |
|
| Course Content and Homework/Schedule/Tests Schedule |
| Week |
Course Content |
| Week 1 |
課程介紹 |
| Week 2 |
資料庫系統與架構 |
| Week 3 |
關聯式資料模型 |
| Week 4 |
SQL I |
| Week 5 |
SQL II |
| Week 6 |
SQL III |
| Week 7 |
期中考複習 |
| Week 8 |
期中考 |
| Week 9 |
Tableau工作坊，時間是4/24(五) 1:00pm~5:00pm。當天將邀請知識遊牧之彭其捷創辦人與蘇思文經理進行Tableau教學 |
| Week 10 |
實體關係資料模型(ER Model)
|
| Week 11 |
增強實體關係資料模型(EER Model) |
| Week 12 |
資料庫正規化 |
| Week 13 |
期末專題報告 |
| Week 14 |
期末專題報告 |
| Week 15 |
期末考前複習 |
| Week 16 |
期末考 |
self-directed
learning |
02.Viewing multimedia materials related to industry and academia.
03.Preparing presentations or reports related to industry and academia.
SQL online practice & Final project report submission |
|
| Evaluation |
-課堂參與(10%)
-期中考試(27.5%)
-期末考試(27.5%)
-期末專題報告(35%)：學生自由選擇感興趣之資料集設計資料庫，包括ER Model繪製、基礎SQL操作、使用Tableau進行視覺化圖表呈現。
考試前一周將針對考試內容進行複習講解 |
| Textbook & other References |
Database Systems Design, Implementation, and Management, 14/e, Cengage, 2023, By Coronel & Morris.
|
| Teaching Aids & Teacher's Website |
| 自製教材，將於每周上課前上傳至iLearning |
| Office Hours |
| Tuesday 10:00~12:00 |
| Sustainable Development Goals, SDGs(Link URL) |
| include experience courses：N |
|