Course Information
Course title
資料庫系統
Database Systems 
Semester
102-1 
Designated for
College of Bioresources & Agriculture  GRADUATE INSTITUTE OF BIOENVIROMENTAL SYSTEMS ENGINEERING  
Instructor
蘇明道 
Curriculum Number
BSE5076 
Curriculum Identity Number
622EU2750 
Class
 
Credits
Full/Half
Yr.
Half 
Required/
Elective
Elective 
Time
Friday 2,3,4(9:10~12:10) 
Room
農工九 
Remarks
本課程以英語授課。
The upper limit of the number of students: 30. 
Ceiba Web Server
http://ceiba.ntu.edu.tw/1021_BSEDB 
Course introduction video
 
Table of Core Capabilities and Curriculum Planning
Association has not been established
Course Syllabus
Please respect the intellectual property rights of others and do not copy any of the course information without permission
Course Description

本課成為資料庫應用之入門課程,學生將瞭解資料庫之基本理論與應用概念,並經由作業之研習累積實務之資料庫設計與操作經驗。台灣大學計資中心將提供Microsoft Access作為上課與作業之基本平台,但學生亦可選擇其個別之資料庫軟體。 

Course Objective
使學生瞭解資料庫之基本觀念與原理,並經由作業得到實際設計與操作之經驗。 
Course Requirement
Homework 35% Midterm/Final 25%,30%, Quiz and Participation 10% 
Student Workload (expected study time outside of class per week)
 
Office Hours
 
Designated reading
 
References
D.M.Kroenke, Database Processing: Fundamentals, Design, and Implementation, 10th Edition 
Grading
   
Progress
Week
Date
Topic
Week 1
9/13  Introductions 
Week 2
9/20  Holiday (No Class) 
Week 3
9/27  Data, Information, and Information System 
Week 4
10/04  Database Environment and Development Process (Chap.1) 
Week 5
10/11  Modeling Data in the Organization (Chap.2) 
Week 6
10/18  No class due to blackout 
Week 7
10/25  The E-R Model (Chap.3) 
Week 8
11/01  Normal Form and Normalization 
Week 9
11/08  MidTerm Exam 
Week 10
11/15  University Homecoming day(No Class) 
Week 11
11/22  Logical Database Design and the Relational Model (Chap.4) 
Week 12
11/29  Introduction to SQL (Chap.6) 
Week 13
12/06  Advanced SQL (Chap.7) 
Week 14
12/13  Data Warehousing (Chap.9) 
Week 15
12/20  Final Exam. 
Week 16
12/27  Database Design (Chap4/5) 
Week 17
1/03  Database Application Development (Chap.8)