| 課程名稱 Course Title |
(中文) 資料庫設計 (英文) Database Design |
開課單位 Departments |
資訊經營研究所 | ||
| 課程代碼 Course No. |
N4720 | ||||
| 授課教師 Instructor |
陳明賢 | ||||
| 學分數 Credit |
3.0 | 必/選修 core required/optional |
選修 | 開課年級 Level |
研究所 |
| 先修科目或先備能力Course Pre-requisites：關於資料庫設計乃是入門課程，主要是為非資訊相關科系畢業的同學而安排。已熟悉資料庫的同學請不要選。 | |||||
| 課程概述與目標 Course Overview and Goals：訓練學生對一個商業上的資訊管理情境，設計出能滿足需求的資料庫綱要、查詢及管理報表。 | |||||
| 教科書 Textbook |
書名:DATABASE SYSTEMS - DESIGN,IMPLEMENTATION, AND MANAGEMENT 13/E 作者:CORONEL(ROB) 代理: 高立圖書 |
||||
| 參考教材 Reference |
|||||
| 課程大綱 Syllabus |
學生學習目標 Learning Objectives |
單元學習活動 Learning Activities |
學習成效評量 Evaluation |
備註 Notes |
||
| 週 Week | 單元主題 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 | Primary SQL (2) | Primary SQL command | 能運用SQL command做基本查詢 |
|
|
|
| 8 | Advance SQL (1) | multi-tables inner/outter joins aggregate functions |
能join多張table並將資料聚合 |
|
|
|
| 9 | Mid Exam | mid exam | 驗收半學期的學習成果 |
|
||
| 10 | Advance SQL (2) | using subquery in query command | 能運用subquery於複雜查詢 |
|
|
|
| 11 | Normalization of database tables | Conversion to 1NF Conversion to 2NF Conversion to 3NF Conversion to higher NF |
能將資料表正規化 |
|
|
|
| 12 | System Analysis | requirements acquisition translating requirements to conceptual design |
能分析出系統需求 |
|
|
|
| 13 | Report Design(1) | using BI tools to design charts | 能運用Chart呈現資料 |
|
|
|
| 14 | Report Design (2) | designing data drill down or roll up paths in reports | 能設計資料鑽探與上捲的屬性階層 |
|
|
|
| 15 | Dimension Model (1) | dimension tables fact tables |
能用維度模型設計資料倉儲 |
|
|
|
| 16 | Dimension Model (2) | advance issues of dimension model | 能用維度模型設計資料倉儲 |
|
|
|
| 17 | Term Project Presentation (2) | 學期專題驗收 | 能綜合運用本課程所習得的技術於資料庫設計 |
|
|
|
| 18 | Final Exam | final exam | final exam |
|
||
|
教學要點概述 Overview of Teaching Points： |