課程資訊
課程名稱
資料庫系統
Database Systems 
開課學期
101-1 
授課對象
學程  生物統計學程  
授課教師
蘇明道 
課號
BSE5076 
課程識別碼
622 U2750 
班次
 
學分
全/半年
半年 
必/選修
選修 
上課時間
星期五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