| 課程名稱 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 |
|
|
|
| 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 | 期末考 | 通過測驗 |
|
||
|
教學要點概述 Overview of Teaching Points： |