資料庫管理
Database Management
學期
112-2
學分
3
學分
當期課號
517501
永久課號
MGCM10019
開課單位
資訊管理與財務金融系
授課教師
劉建良
校區
光復
類別
必修
上課時間表
| 節 | 週三 |
|---|---|
2 09:00–09:50 | 資料庫管理 MB415 3 節連堂 |
3 10:10–11:00 | |
4 11:10–12:00 |
* 根據陽明交大上課時間表所列
概述
This course will focus on practical issues about databases, including database modeling, normalization, and SQL. The goal is to let students understand how to design databases and how to use the developed database as the backend system to development database applications.
先修科目
無
評分方式
TBD
課程大綱
- Introduction
- Relational Model
- Data Model
- SQL programming & Web databases
- File organizations and Index structures
- Database Design Theory
- Transaction processing concepts
- Data Warehousing
週次計畫
| 週次 | 主題 |
|---|---|
| 第 1 週 | Introduction to Databases |
| 第 2 週 | Database Systems |
| 第 3 週 | Data Models |
| 第 4 週 | The Relational Database Model |
| 第 5 週 | The ER Model |
| 第 6 週 | Advanced Data Modeling |
| 第 7 週 | Normalization of Database Tables |
| 第 8 週 | Normalization of Database Tables |
| 第 9 週 | Midterm |
| 第 10 週 | Introduction to SQL |
| 第 11 週 | Database Connectivity and Web Technologies |
| 第 12 週 | Advanced SQL |
| 第 13 週 | Database Design |
| 第 14 週 | Database Design |
| 第 15 週 | Business Intelligence and DataWarehouse |
| 第 16 週 | Project Presentation |
| 第 17 週 | Project Presentation |
| 第 18 週 | Final Exam |
教科書
Database Systems: Design, Implementation, & Management (13th edition) by Carlos Coronel and Steven Morris
Office Hours
- 地點
- MB 505
- 聯絡方式
- E-mail: clliu@mail.nctu.edu.tw