|
課程名稱 |
資料庫系統
Database Systems |
|
開課學期 |
101-1 |
|
授課對象 |
學程 生物產業自動化學程 |
|
授課教師 |
蘇明道 |
|
課號 |
BSE5076 |
|
課程識別碼 |
622 U2750 |
|
班次 |
|
|
學分 |
3 |
|
全/半年 |
半年 |
|
必/選修 |
選修 |
|
上課時間 |
星期五2,3,4(9:10~12:10) |
|
上課地點 |
農工九 |
|
備註 |
本課程以英語授課。
總人數上限：30人 |
|
Ceiba 課程網頁 |
http://ceiba.ntu.edu.tw/1011BSE_DBMS |
|
課程簡介影片 |
|
|
核心能力關聯 |
本課程尚未建立核心能力關連 |
|
課程大綱
|
|
為確保您我的權利,請尊重智慧財產權及不得非法影印
|
|
課程概述 |
The purpose of this course is to acquaint the students with the concepts and theories of database system. Practical experiences will also be gained by performing system analysis, constructing database file, and running database programs. Since NTU owns its site license, Microsoft ACCESS is recommended but not mandatory. The student may use other available tools. |
|
課程目標 |
To understand the concepts and theories of database management system and its applications. |
|
課程要求 |
1. Homeworks and in class quizzes
2. Mid-term exam.
3. Term project: proposal, report, presentation |
|
Office Hours |
|
|
參考書目 |
D.M.KROENKE, DATABASE PROCESSING: FUNDAMENTALS, DESIGN, AND IMPLEMENTATION, 10TH EDITION |
|
指定閱讀 |
D.M.Kroenke,
Database Processing: Fundamentals, Design, and Implementation,
12th Edition |
|
評量方式
(僅供參考) |
|
No. |
項目 |
百分比 |
說明 |
|
1. |
Term project |
35% |
|
2. |
Quiz |
10% |
|
3. |
Homework |
35% |
|
4. |
Mid-term |
20% |
|
|
|
週次 |
日期 |
單元主題 |
|
Week 1 |
9/14 |
introduction |
|
Week 2 |
9/21 |
DBMS Basic |
|
Week 3 |
9/28 |
Basic SQL |
|
Week 4 |
10/05 |
Relational Data Model |
|
Week 5 |
10/12 |
Normalization with Normal Form |
|
Week 6 |
10/19 |
Database Design with normalization |
|
Week 7 |
10/26 |
ER Modeling(1/2) |
|
Week 8 |
11/02 |
ER Modeling(2/2) |
|
Week 9 |
11/09 |
Mid Term Exam |
|
Week 10 |
11/16 |
Database Design |
|
Week 11 |
11/23 |
Database Design (Cont'd) |
|
Week 12 |
11/30 |
Transforming Data Model into a Database Design |
|
Week 13 |
12/07 |
Project Discussions |
|
Week 14 |
12/14 |
Database Warehouse |
|
Week 15 |
12/21 |
No Class |
|
Week 16 |
12/28 |
VBA/CASE |
|
Week 17 |
1/04 |
Term Project Review/discussions |
|