資料庫管理
Database Management
學期
109-2
學分
3
學分
當期課號
1505
永久課號
DOM1048
開課單位
資訊管理與財務金融系
授課教師
劉敦仁
校區
光復
類別
必修
上課時間表
| 節 | 週二 | 週三 |
|---|---|---|
2 09:00–09:50 | 資料庫管理 MB312 | |
3 10:10–11:00 | 資料庫管理 MB312 2 節連堂 | |
4 11:10–12:00 |
* 根據陽明交大上課時間表所列
概述
The main objective of this class is to study the fundamental concepts necessary for designing, using, and implementing database systems. The course stresses the fundamentals of database modeling and design, the languages and facilities provided by database management systems, and system implementation techniques. Emerging database technologies and applications will also be introduced.
評分方式
Midterm (35%), Homework & Project (25%), Final (35%), Participation (5%)
課程大綱
- Introduction
- Relational Model
- Data Model
- SQL programming & Web databases
- File organizations and Index structures
- Database Design Theory
- Transaction processing concepts
- Data Warehousing
週次計畫
| 週次 | 主題 |
|---|---|
| 第 1 週 | Basic concepts; DB system concepts; |
| 第 2 週 | DB system architecture; Relational Model, Languages, and System |
| 第 3 週 | Relational Model, Languages, and System; Relational Data Model |
| 第 4 週 | Relational Data Model; SQL |
| 第 5 週 | Advanced SQL; Entity-Relationship Model |
| 第 6 週 | Enhanced Entity-Relationship Model |
| 第 7 週 | ER and EER to Relational Mapping; SQL programming & Web databases |
| 第 8 週 | SQL programming & Web databases; Embedded SQL; SQLJ Project Demo |
| 第 9 週 | Application programming interface; JDBC; PHP; Questions Review |
| 第 10 週 | Questions Review; Midterm |
| 第 11 週 | Record Storage; File Organizations; |
| 第 12 週 | Index Structures for Files |
| 第 13 週 | Database design informal Guidelines; Functional Dependencies; |
| 第 14 週 | Normalization for Relational Databases; 1NF, 2NF, 3NF, BCNF |
| 第 15 週 | Transaction processing concepts; Concurrency control; Database recovery; |
| 第 16 週 | Data Modeling for Data Warehouses; Functionality of a Data Warehouse; Questions Review |
| 第 17 週 | Questions Review; Final exam |
| 第 18 週 | Project Demo; arrangement by Teaching assistant |
教科書
Fundamentals of Database Systems, Seven Edition, Pearson, 2017, by Ramez Elmasri and Shamkant B. Navathe.
Office Hours
- 地點
- MB 305
- 時間
- Tu. 12:00 ~ pm 1:30; Wed. pm 12:00 ~ 1:30;
- 聯絡方式
- dliu@mail.nctu.edu.tw