課程大綱 Syllabus |
學生學習目標 Learning Objectives |
單元學習活動 Learning Activities |
學習成效評量 Evaluation |
備註 Notes |
序 No. | 單元主題 Unit topic |
內容綱要 Content summary |
1 | The Course Introduction |
The Course Introduction |
了解本課程與其它課程之相互關係及了解本課程的內涵 |
|
|
|
2 | ER Model (1) |
ER model |
能運用ER模型做概念式資料庫設計 |
|
|
|
3 | ER Model (2) |
enhanced ER model |
能運用ER模型做概念式資料庫設計 |
|
|
|
4 | The relational database model |
A logical view of data
Keys
Integrity rules
Relational algebra |
能運用關連模型做邏輯式資料庫設計 |
|
|
|
5 | ER Model to Relational Model |
mapping ER model to relational model |
能將ER模型映射至關連式模型 |
|
|
|
6 | Primary SQL (1) |
Primary SQL command |
能運用SQL command做基本查詢 |
|
|
|
7 | Advance SQL (1) |
multi-tables inner/outter joins
aggregate functions |
能join多張table並將資料聚合 |
|
|
|
8 | Mid Exam |
mid exam |
驗收半學期的學習成果 |
|
|
|
9 | Advance SQL (2) |
using subquery in query command |
能運用subquery於複雜查詢 |
|
|
|
10 | Normalization of database tables |
Conversion to 1NF
Conversion to 2NF
Conversion to 3NF
Conversion to higher NF |
能將資料表正規化 |
|
|
|
11 | System Analysis |
requirements acquisition
translating requirements to conceptual design |
能分析出系統需求 |
|
|
|
12 | Report Design(1) |
using BI tools to design charts |
能運用Chart呈現資料 |
|
|
|
13 | Report Design (2) |
designing data drill down or roll up paths in reports |
能設計資料鑽探與上捲的屬性階層 |
|
|
|
14 | Dimension Model (1) |
dimension tables
fact tables |
能用維度模型設計資料倉儲 |
|
|
|
15 | Dimension Model (2) |
advance issues of dimension model |
能用維度模型設計資料倉儲 |
|
|
|
16 | Final Exam |
final exam |
final exam |
|
|
|