資料庫管理
Database Management
| 節 | 週一 |
|---|---|
5 13:20–14:10 | 資料庫管理 MB415（光復） 3 節連堂 |
6 14:20–15:10 | |
7 15:30–16:20 |
* 根據陽明交大上課時間表所列
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 2026-02-23(一) |
| 第 2 週 | Database Systems 2026-03-02(一) |
| 第 3 週 | Data Models 2026-03-09(一) |
| 第 4 週 | The Relational Database Model 2026-03-16(一) |
| 第 5 週 | The ER Model 2026-03-23(一) |
| 第 6 週 | Advanced Data Modeling 2026-03-30(一) |
| 第 7 週 | Normalization of Database Tables 2026-04-06(一) |
| 第 8 週 | Normalization of Database Tables 2026-04-13(一) |
| 第 9 週 | Midterm 2026-04-20(一) |
| 第 10 週 | Introduction to SQL 2026-04-27(一) |
| 第 11 週 | Database Connectivity and Web Technologies 2026-05-04(一) |
| 第 12 週 | Advanced SQL 2026-05-11(一) |
| 第 13 週 | Database Design 2026-05-18(一) |
| 第 14 週 | Database Design 2026-05-25(一) |
| 第 15 週 | Business Intelligence and DataWarehouse 2026-06-01(一) |
| 第 16 週 | Project Presentation 2026-06-08(一) |
| 第 17 週 | Project Presentation 2026-06-15(一) |
| 第 18 週 | Final Exam 2026-06-22(一) |
Database Systems: Design, Implementation, & Management (13th edition) by Carlos Coronel and Steven Morris
- 地點
- MB 505
- 時間
- 教師未提供此項資料
- 聯絡方式
- E-mail: clliu@mail.nctu.edu.tw