資料庫管理系統
Database Management Systems
| 節 | 週四 |
|---|---|
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
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
- 講授：
- 3
Data Warehousing & Data Mining
1. Data Modeling for Data Warehouses 2. Building a Data Warehouse 3. Functionality of a Data Warehouse 4. Introduction to Data Mining
- 講授：
- 3
| 週次 | 主題 |
|---|---|
| 第 1 週 | Basic concepts, DB system concepts and architecture 2025-02-20(四) |
| 第 2 週 | Relational Model, Languages, and System 2025-02-27(四) |
| 第 3 週 | Relational Data Model; SQL 2025-03-06(四) |
| 第 4 週 | SQL 2025-03-13(四) |
| 第 5 週 | SQL; Entity-Relationship Model 2025-03-20(四) |
| 第 6 週 | Entity-Relationship Model 2025-03-27(四) |
| 第 7 週 | ER and EER to Relational Mapping 2025-04-03(四) |
| 第 8 週 | Embedded SQL; Dynamic SQL, SQLJ, PHP 2025-04-10(四) |
| 第 9 週 | Midterm 2025-04-17(四) |
| 第 10 週 | Record Storage; File Organizations; Index structures 2025-04-24(四) |
| 第 11 週 | Index structures; Database design informal Guidelines; 2025-05-01(四) |
| 第 12 週 | Functional Dependencies; Normalization for Relational Databases 2025-05-08(四) |
| 第 13 週 | 1NF, 2NF, 3NF, BCNF 2025-05-15(四) |
| 第 14 週 | Transaction processing concepts; Concurrency control; Database recovery; 2025-05-22(四) |
| 第 15 週 | Data warehouse; Data Modeling for Data Warehouses; Functionality of a Data Warehouse; 2025-05-29(四) |
| 第 16 週 | Final exam 2025-06-05(四) |
Fundamentals of Database Systems, Seven Edition, Pearson, 2017, by Ramez Elmasri and Shamkant B. Navathe.
- 地點
- MB 305
- 時間
- Thur. pm 5:30 - 6:30.
- 聯絡方式
- dliu@nycu.edu.tw