| 課程大綱 Syllabus |
學生學習目標
Learning Objectives |
單元學習活動
Learning Activities |
學習成效評量
Evaluation |
備註
Notes |
序
No. | 單元主題
Unit topic |
內容綱要
Content summary |
| 1 | Database Systems |
# introducing the class
# introducing what are databases
# evolution of file system data processing
# problems with file system data processing
# the database system environment |
了解資料庫系統的演進 |
|
|
|
| 2 | Data models |
#. data modeling and data models
#. the importance of data models
#. basic building blocks
#. business rules
#. degrees of data abstraction |
能敘述資料模型的重要性
了解有哪些可用於建模時的模塊
能分辨不同的資料抽象程度 |
|
|
|
| 3 | The relational database model - basic |
#. a logical view of data
#. keys
#. integrity rules
#. the data dictionary
#. relationships within relational database |
了解何謂關聯式資料庫模型
了解各種鍵的定義與彼此間的關係
了解關聯式資料庫的一致性法則
了解關聯式資料庫各種專有名詞及三種關聯模式 |
|
|
|
| 4 | The relational database model - Relational Algebra |
# select
# project
# union, intersect, difference
# product
# inner join: natural join, equijoin, theta join
# outter join: left / right / full outer join |
能運用關連代數操作資料
能正確運用各種join於各式資料操作情境 |
|
|
|
| 5 | ER modeling 1 |
#. entities
#. attributes
#. relationships
#. connectivity and cardinality
#. existence dependence |
瞭解何謂實體關係模式。
瞭解如何將設計者與使用者訪談的過程記錄(情境)轉換成E-R圖。
瞭解如何將ER圖轉換成資料庫，以利資料庫程式設計所需要的資料來源。 |
|
|
|
| 6 | ER modeling 2 |
#. weak entities
#. relationship participation
#. relationship degree
#. recursive relationships
#. associative entities |
瞭解何謂實體關係模式。
瞭解如何將設計者與使用者訪談的過程記錄(情境)轉換成E-R圖。
瞭解如何將ER圖轉換成資料庫，以利資料庫程式設計所需要的資料來源。 |
|
|
|
| 7 | Introduction to query data by SQL |
# introduction to SQL
# basic SELECT queries
# SELECT statement options
# FROM clause options
# ORDER BY clause options
# WHERE options
# aggregate functions
# grouping data
# HAVING clause |
能敘述SQL各子句的作用
能敘述SQL各子句執行的先後順序
能運用SQL，在不需子查詢情況下，從數個資料表查詢資料
能分群資料表中的資料並聚合資料表中的數據 |
|
|
|
| 8 | Integration practice of query data by SQL |
# Integration practice of SQL |
能join數個資料表
能過濾join後資料
能aggregate數據並過濾aggregate結果
能按查詢需求，正確運用inner join或outter join |
|
|
|
| 9 | 期中考 |
# 測量學習成果 |
了解學習狀況 |
|
|
|
| 10 | Advance query data by SQL |
# WHERE subqueries
# IN subqueries
# HAVING subqueries
# multirow subquery operators: ALL and ANY
# FROM subqueries
# attribute list subqueries
# correlated subqueries
# relational set operators: UNION, UNION ALL, INTERSECT, EXCPT
# SQL functions |
能運用各式子查詢，從數個資料表中查詢資料
能運用SQL functions於查詢中 |
|
|
|
| 11 | Advance query data by SQL |
# WHERE subqueries
# IN subqueries
# HAVING subqueries
# multirow subquery operators: ALL and ANY
# FROM subqueries
# attribute list subqueries
# correlated subqueries
# relational set operators: UNION, UNION ALL, INTERSECT, EXCPT
# SQL functions |
能運用各式子查詢，從數個資料表中查詢資料
能運用SQL functions於查詢中 |
|
|
|
| 12 | Advanced Integration practice of query data by SQL |
# Advanced Integration practice of SQL |
能運用子查詢於select, from子句
能運用子查詢於關係運算子
能運用子查詢於多值運算子
能運用多層巢狀子查詢 |
|
|
|
| 13 | Advanced Integration practice of query data by SQL |
# Advanced Integration practice of SQL |
能運用子查詢於select, from子句
能運用子查詢於關係運算子
能運用子查詢於多值運算子
能運用多層巢狀子查詢 |
|
|
|
| 14 | Normalization of database tables 1 |
# the natural of data
# database tables and normalization
# the need for normalization
# the normalization process
# conversion to 1NF
# conversion to 2NF
# conversion to 3NF |
能明辨資料的本質
瞭解資料庫正規化的概念及目的。
瞭解資料庫正規化程序及規則。 |
|
|
|
| 15 | Normalization of database tables 2 |
# improving the design
# higher-level normal forms
# BCNF
# 4NF
# normalization and database design
# denormalization |
能運用正規化程序以改善資料庫設計
能按資料本質而決定是否需要正規化
明暸反正規的用意 |
|
|
|
| 16 | The DDL and DML of SQL |
# data definition commands
# creating table structures
# altering table structures
# data manipulation commands
# adding table rows
# inserting table rows with a SELECT subquery
# updating table rows
# deleting tables rows
#virtual table: create a view |
能活運DDL及DML於資料庫建立及資料維護 |
|
|
|
| 17 | Transaction Management and Concurrency Control |
#what is a transaction
#concurrency control
#concurrency control with locking methods
#concurrency control with time stamping methods |
能描述資料庫交易管理過程
能界定資料庫交易的4項特性
能解釋平行控制及其對資料庫完整性的影響
能描述平行控制時應該如何鎖定資料 |
|
|
|
| 18 | 期末考 |
測量學習成果 |
了解學生學習成效 |
|
|
|