NCHU Course Outline
Course Name (中) 資料庫系統(7700)
(Eng.) Database Systems
Offering Dept Executive Master Program in Management Information Systems
Course Type Elective Credits 3 Teacher CHAN, YUNG-KUAN
Department Executive Master Program in Management Information Systems / (W)Graduate Language Chinese Semester 2026-SPRING
Course Description 資料庫系統在資訊的儲存、管理、與使用上具有重要的功用。本課程將由 資料的模型(ER Model)談起,討論如何建立資料間的關聯性與資料的屬性。繼而討論如何將ER Model轉換為實際資料庫的資料模型,如階層資料模型、網路資料模型、關聯式資料模型、與物件導向資料模型。 另外,資料庫查詢語言與資料各種層次的正規化也是本課程的重點。
Prerequisites
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.Professional Knowledge and Practical Application
2.Independent Problem-Solving
60
40
Course Content and Homework/Schedule/Tests Schedule
Week Course Content
Week 1 Relational Data Model
Week 2 ER Model
Week 3 Transform ER Model to Relation
Week 4 Normalization
Week 5 Database Constraints
Week 6 SQL
Week 7 交易管理
Week 8 並行控制與回復
Week 9 期中考
Week 10 死結處理
Week 11 關聯式代數
Week 12 查詢最化
Week 13 Index file
Week 14 Hash function
Week 15 B-Tree結構
Week 16 密碼學 資訊安全 期末考
self-directed
learning

Evaluation
30%期中考、30%期末考、30%作業、30%平常成績。
Textbook & other References

Teaching Aids & Teacher's Website
講義
Office Hours
星期二
18:00-20:00
Sustainable Development Goals, SDGs(Link URL)
 include experience courses:N
Please respect the intellectual property rights and use the materials legally.Please respect gender equality.
Update Date, year/month/day:None Printed Date, year/month/day:2026 / 5 / 31
The second-hand book website:http://www.myub.com.tw/