資料庫管理
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 2024-02-21(三) |
| 第 2 週 | Database Systems 2024-02-28(三) |
| 第 3 週 | Data Models 2024-03-06(三) |
| 第 4 週 | The Relational Database Model 2024-03-13(三) |
| 第 5 週 | The ER Model 2024-03-20(三) |
| 第 6 週 | Advanced Data Modeling 2024-03-27(三) |
| 第 7 週 | Normalization of Database Tables 2024-04-03(三) |
| 第 8 週 | Normalization of Database Tables 2024-04-10(三) |
| 第 9 週 | Midterm 2024-04-17(三) |
| 第 10 週 | Introduction to SQL 2024-04-24(三) |
| 第 11 週 | Database Connectivity and Web Technologies 2024-05-01(三) |
| 第 12 週 | Advanced SQL 2024-05-08(三) |
| 第 13 週 | Database Design 2024-05-15(三) |
| 第 14 週 | Database Design 2024-05-22(三) |
| 第 15 週 | Business Intelligence and DataWarehouse 2024-05-29(三) |
| 第 16 週 | Project Presentation 2024-06-05(三) |
| 第 17 週 | Project Presentation 2024-06-12(三) |
| 第 18 週 | Final Exam 2024-06-19(三) |
Database Systems: Design, Implementation, & Management (13th edition) by Carlos Coronel and Steven Morris
- 地點
- MB 505
- 時間
- 教師未提供此項資料
- 聯絡方式
- E-mail: clliu@mail.nctu.edu.tw