教學大綱表 Syllabus
請遵守智慧財產權,勿使用非法影印教科書,避免觸法。
課程名稱
Course Title
(中文) 資料庫系統
(英文) Database Systems
開課單位
Departments
資訊工程學系
課程代碼
Course No.
I3360C
授課教師
Instructor
鄭福炯
學分數
Credit
3.0 必/選修
core required/optional
必修 開課年級
Level
大二
先修科目或先備能力Course Pre-requisites:計算機概論、程式設計
課程概述與目標 Course Overview and Goals:The aim of this course is to cover the material most useful to the majority of database students -- databases from the point of view of the database designer, user, and application programmer. It focuses on database design, use, and implementation. In this course, we present the fundamental concepts of database management. These concepts include aspects of database design, database languages, and database applications implementation.
教科書
Textbook
1. Database systems, 7th edition, Ramez Emasri and Shamkant B. Navache, Pearson, 2016
2. 資料庫系統理論與實務 陳會安,旗標,2020
書目標號: 06309- 007
參考教材
Reference
1. W3School Tutorial on :PHP, MySQL, Apache Web Server

課程大綱
Syllabus
學生學習目標
Learning Objectives
單元學習活動
Learning Activities
學習成效評量
Evaluation
備註
Notes

Week
單元主題
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
  • 討論
  • 講授
  • 閱讀討論
  • 作業 Assignment
  •  
    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
  • 討論
  • 實作
  • 上機實習
  • 作業 Assignment
  •  
    3 Chapter 3 SQL 1. Data Definition
    2. Basic Query Structure
    3. Set Operations
    4. Aggregate Functions
    能使用SQL操作MySQL
  • 討論
  • 實作
  • 講授
  • 上機實習
  • 作業 Assignment
  •  
    4 Chapter 3 Higher SQL 5. Nested Subqueries
    6. Complex Queries
    7. Views
    8. Joined Relations
    能使用較雜SQL指令
  • 討論
  • 實作
  • 上機實習
  • 平時考 Test
  • 作業 Assignment
  •  
    5 Chapter 4 Advanced SQL 1. SQL Data Types and Schemas
    2. Integrity Constraints
    3. Authorization
    4. Embedded SQL
    能使用高階SQL指令
  • 討論
  • 實作
  • 上機實習
  • 作業 Assignment
  •  
    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修改資料庫
  • 討論
  • 實作
  • 上機實習
  • 作業 Assignment
  •  
    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的語法演變
  • 討論
  • 講授
  • 作業 Assignment
  •  
    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設計資料庫系統
  • 實作
  • 講授
  • 作業 Assignment
  •  
    9 Mid-term Exam 期中考 確實了解並通過測驗
  • 期中考 Midterm
  •  
    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
  • 討論
  • 實作
  • 講授
  • 作業 Assignment
  •  
    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設計資料庫系統
  • 設計研究
  • 實作
  • 講授
  • 作業 Assignment
  •  
    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
  • 討論
  • 實作
  • 講授
  • 作業 Assignment
  •  
    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表格
  • 實作
  • 講授
  • 上機實習
  • 作業 Assignment
  •  
    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
    能將資料庫正規化
  • 設計研究
  • 討論
  • 實作
  • 講授
  • 問答 Interrogation
  • 作業 Assignment
  •  
    15 Chapter 14 Database Normalization Using Multi-valued Dependency 1. BCNF
    2. Multivalued Dependency and Fourth Normal Form
    能將資料庫正規化為符合BCNF和4th NF 資料表
  • 討論
  • 實作
  • 講授
  • 問答 Interrogation
  • 作業 Assignment
  •  
    16 專題報告 I 資料庫專題設計與報告 能獨立設計一可用之三層式資料庫系統
  • 設計研究
  • 心得發表
  • 實作
  • 上機實習
  • 專題 Seminar
  •  
    17 專題報告 II 資料庫專題設計與報告 能獨立設計一可用之三層式資料庫系統
  • 設計研究
  • 討論
  • 心得發表
  • 實作
  • 上機實習
  • 專題 Seminar
  •  
    18 Final Exam 期末考 通過測驗
  • 期末考 Final Exam
  •  

    教學要點概述 Overview of Teaching Points:
    教材編選 Teaching Materials: ■ 自編教材 Handout by Instructor ■ 教科書作者提供 Textbook
    評量方法 Evaluation: 期末考 Final Exam:30%   期中考 Midterm:30%   專題 Seminar:10%   平時考 Test:10%   作業 Assignment:20%  
    教學資源 Teaching Resources: □ 教材電子檔 Soft Copy of the Handout or the Textbook ■ 課程網站 Website
    課程網站:網路大學
    扣考規定 The rule of being able to take the final exam of the course:http://eboard.ttu.edu.tw/ttuwebpost/showcontent-news.php?id=504