資料庫管理系統
Database Management Systems
學期
114-2
學分
3
學分
當期課號
557609
永久課號
MGIM30043
開課單位
管理學院碩士在職專班-資管組
授課教師
劉敦仁
校區
光復
類別
選修
上課時間表
| 節 | 週四 |
|---|---|
A 18:30–19:20 | 資料庫管理系統 MB311 3 節連堂 |
B 19:30–20:20 | |
C 20:30–21:20 |
* 根據陽明交大上課時間表所列
概述
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 (20%), Final (35%), Participation (10%)
課程大綱
- Introduction
- Relational Model
- Data Model
- SQL programming & Web databases
- File organizations and Index structures
- Database Design Theory
- Transaction processing concepts
- Data Warehousing & Data Mining
週次計畫
| 週次 | 主題 |
|---|---|
| 第 1 週 | Basic concepts, DB system concepts and architecture |
| 第 2 週 | Relational Model, Languages, and System |
| 第 3 週 | Relational Data Model SQL |
| 第 4 週 | SQL |
| 第 5 週 | SQL Entity-Relationship Model |
| 第 6 週 | Entity-Relationship Model |
| 第 7 週 | ER and EER to Relational Mapping |
| 第 8 週 | Embedded SQL Dynamic SQL, SQLJ, PHP |
| 第 9 週 | Midterm |
| 第 10 週 | Record Storage File Organizations Index structures |
| 第 11 週 | Index structures Database design informal Guidelines |
| 第 12 週 | Functional Dependencies Normalization for Relational Databases |
| 第 13 週 | 1NF, 2NF, 3NF, BCNF |
| 第 14 週 | Transaction processing concepts Concurrency control Database recovery |
| 第 15 週 | Data warehouse Data Modeling for Data Warehouses Functionality of a Data Warehouse |
| 第 16 週 | Final exam |
教科書
Fundamentals of Database Systems, Seven Edition, Pearson, 2017, by Ramez Elmasri and Shamkant B. Navathe.
Office Hours
- 地點
- MB 305
- 時間
- Thur. pm 5:30 - 6:30.
- 聯絡方式
- dliu@nycu.edu.tw