資料庫管理
Database Management
| 節 | 週三 |
|---|---|
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
1. Basic Concepts 2. DB System Concepts 3. DB System Architecture
- 講授：
- 3
Relational Model
1. Relational Data Model 2.SQL
- 講授：
- 7.5
- 實作：
- 1.5
Data Model
1. ER Model 2. Enhanced ER Model 3. UML 4. ER and EER to Relational Mapping
- 講授：
- 7.5
SQL programming & Web databases
1. Embedded SQL 2. Dynamic SQL, SQLJ 3. ODBC, JDBC 4. ASP, JSP, PHP
- 講授：
- 4
- 示範：
- 2
- 實作：
- 1.5
File organizations and Index structures
1. Record Storage 2. File Organizations 3. Index Structures
- 講授：
- 5
Database Design Theory
1. Informal Guidelines 2. Functional Dependencies 3. Normalization for Relational Databases 4. 1NF, 2NF, 3NF, BCNF
- 講授：
- 7
Transaction processing concepts
1. Transaction properties 2. Concurrency control 3. Database recovery
- 講授：
- 5
Data Warehousing
1. Data Modeling for Data Warehouses 2. Building a Data Warehouse 3. Functionality of a Data Warehouse
- 講授：
- 4
| 週次 | 主題 |
|---|---|
| 第 1 週 | Introduction to Databases 2025-02-19(三) |
| 第 2 週 | Database Systems 2025-02-26(三) |
| 第 3 週 | Data Models 2025-03-05(三) |
| 第 4 週 | The Relational Database Model 2025-03-12(三) |
| 第 5 週 | The ER Model 2025-03-19(三) |
| 第 6 週 | Advanced Data Modeling 2025-03-26(三) |
| 第 7 週 | Normalization of Database Tables 2025-04-02(三) |
| 第 8 週 | Normalization of Database Tables 2025-04-09(三) |
| 第 9 週 | Midterm 2025-04-16(三) |
| 第 10 週 | Introduction to SQL 2025-04-23(三) |
| 第 11 週 | Database Connectivity and Web Technologies 2025-04-30(三) |
| 第 12 週 | Advanced SQL 2025-05-07(三) |
| 第 13 週 | Database Design 2025-05-14(三) |
| 第 14 週 | Database Design 2025-05-21(三) |
| 第 15 週 | Business Intelligence and DataWarehouse 2025-05-28(三) |
| 第 16 週 | Project Presentation 2025-06-04(三) |
| 第 17 週 | Project Presentation 2025-06-11(三) |
| 第 18 週 | Final Exam 2025-06-18(三) |
Database Systems: Design, Implementation, & Management (13th edition) by Carlos Coronel and Steven Morris
- 地點
- MB 505
- 時間
- 教師未提供此項資料
- 聯絡方式
- E-mail: clliu@mail.nctu.edu.tw