資料庫管理系統

Database Management Systems

學期

106-2

學分

0 學分

當期課號

5633

永久課號

IIM5535

開課單位

管理學院碩士在職專班-資管組

授課教師

劉敦仁

校區

光復

類別

選修

上課時間表

節	週四
A 18:30–19:20	資料庫管理系統 MB312（光復） 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%), Others (10%)

課程大綱

Introduction

1. Basic Concepts 2. DB System Concepts 3. DB System Architecture

講授：

3
Relational Model

1. Relational Data Model 2.SQL

講授：

7.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
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

講授：

4
Data Warehousing

1. Data Modeling for Data Warehouses 2. Building a Data Warehouse 3. Functionality of a Data Warehouse 4. Introduction to Data Mining

講授：

6

週次計畫

週次	主題
第 1 週	Basic concepts
第 2 週	DB system concepts and architecture;
第 3 週	Relational Model, Languages, and System
第 4 週	Relational Data Model; SQL
第 5 週	SQL
第 6 週	SQL; Entity-Relationship Model
第 7 週	Entity-Relationship Model
第 8 週	ER and EER to Relational Mapping
第 9 週	Embedded SQL; Dynamic SQL, SQLJ
第 10 週	Midterm
第 11 週	ODBC, JDBC, ASP, JSP, PHP
第 12 週	Record Storage; File Organizations; Index structures
第 13 週	Index structures; Database design informal Guidelines;
第 14 週	Functional Dependencies; Normalization for Relational Databases
第 15 週	1NF, 2NF, 3NF, BCNF
第 16 週	Transaction processing concepts; Concurrency control; Database recovery;
第 17 週	Data warehouse; Data Modeling for Data Warehouses; Functionality of a Data Warehouse; Introduction to Data Mining
第 18 週	Final exam

教科書

Fundamentals of Database Systems, Fifth Edition, Addison Wesley, 2007, by Ramez Elmasri and Shamkant B. Navathe.

Office Hours

地點: MB 305
時間: Thur. pm 5:30 ~ 6:30
聯絡方式: dliu@iim.nctu.edu.tw