| 課程大綱 Syllabus |
學生學習目標
Learning Objectives |
單元學習活動
Learning Activities |
學習成效評量
Evaluation |
備註
Notes |
序
No. | 單元主題
Unit topic |
內容綱要
Content summary |
| 1 | Chapter 1 Introduction |
1. Database Languages
2. Relational Databases
3. Database Design
4. Object-based and semistructured databases
5. Data Storage and Querying
6. Transaction Management
7. Database Architecture |
Database Applications and Purposes |
|
|
|
| 2 | Chapter 2 Relationship Model |
1. The Relational Data Model and Relational Database Constraints
2. Relational Database Schemas
3. Update Operations, Transactions, and Dealing with Constraint Violations |
能使用MySQL |
|
|
|
| 3 | Chapter 3 SQL |
1. Data Definition
2. Basic Query Structure
3. Set Operations
4. Aggregate Functions |
能使用SQL操作MySQL |
|
|
|
| 4 | Chapter 3 Higher SQL |
5. Nested Subqueries
6. Complex Queries
7. Views
8. Joined Relations |
能使用較雜SQL指令 |
|
|
|
| 5 | Chapter 4 Advanced SQL |
1. SQL Data Types and Schemas
2. Integrity Constraints
3. Authorization
4. Embedded SQL |
能使用高階SQL指令 |
|
|
|
| 6 | Chapter 4 Advanced SQL II |
5. More Complex SQL Retrieval Queries
6. Specifying Constraints as Assertions and Actions as Triggers
7. Views (Virtual Tables) in SQL
8. Schema Change Statements in SQL |
使用SQL修改資料庫 |
|
|
|
| 7 | Chapter 6 Formal Relational Languages: The Algebra and Calculus |
1. Unary Relational Operations: SELECT and PROJECT
2. Relational Algebra Operations from Set Theory
3. Binary Relational Operations: JOIN and DIVISION
4. Additional Relational Operations |
了解SQL的語法演變 |
|
|
|
| 8 | Chapter 7 Conceptual Data Modeling Using Entities and Relationships |
1. Using High-Level Conceptual Data Models for Database Design
2. Entity Types, Entity Sets, Attributes, and Keys
3. Relationship Types, Relationship Sets, Roles, and Structural Constraints
4. Weak Entity Types |
能以E-R Model設計資料庫系統 |
|
|
|
| 9 | Mid-term Exam |
期中考 |
確實了解並通過測驗 |
|
|
|
| 10 | Chapter 8 Mapping a Conceptual Design into a Logical Design |
1. Relational Database Design Using ER-to-Relational Mapping
2. Mapping EER Model Constructs to Relations |
能將ER (EER) Model 轉成 Relational Data Model |
|
|
|
| 11 | Chapter 9 UML for Database Application Design |
1. Basic of UML Class diagrams
2. Representing Specialization and Generalization in UML Class Diagrams
3. Use of UML Diagrams as an Aid to Database Design Specification |
能以UML設計資料庫系統 |
|
|
|
| 12 | Chapter 11 XML: Concepts, Languages, and Standards |
1. Structured, Semistructured, and Unstructured Data
2. XML Hierarchical (Tree) Data Model
3. XML Documents, DTD, and XML Schema
4. Storing and Extracting XML Documents from Databases |
能將資料庫轉為XML |
|
|
|
| 13 | Chapter 13 SQL Web Programming Using C/PHP |
1. A Simple PHP Example
2. Overview of Basic Features of PHP
3. Overview of PHP Database Programming |
學習初步PHP程式，讀取MySQL表格 |
|
|
|
| 14 | Chapter 14 Database Normalization Using Functional Dependency |
1. Informal Design Guidelines for Relation Schemas
2. Functional Dependencies
3. Normal Forms Based on Primary Keys
4. General Definitions of Second and Third Normal Forms |
能將資料庫正規化 |
|
|
|
| 15 | Chapter 14 Database Normalization Using Multi-valued Dependency |
1. BCNF
2. Multivalued Dependency and Fourth Normal Form |
能將資料庫正規化為符合BCNF和4th NF 資料表 |
|
|
|
| 16 | 專題報告 I |
資料庫專題設計與報告 |
能獨立設計一可用之三層式資料庫系統 |
|
|
|
| 17 | 專題報告 II |
資料庫專題設計與報告 |
能獨立設計一可用之三層式資料庫系統 |
|
|
|
| 18 | Final Exam |
期末考 |
通過測驗 |
|
|
|