◎系所教育目標：
1.培育理論與實務兼具之財金專業人才
2.造就學生富國際宏觀與前瞻視野能力
3.強調專業倫理與具高度正直感之特質 |
| ◎核心能力 | 關聯性 |
| 1.財務金融專業知能 | 1 關聯性最弱 |
| 2.獨立思考創新能力 | 3 關聯性中等 |
| 3.國際觀與外語能力 | 3 關聯性中等 |
| 4.溝通協調合作能力 | 3 關聯性中等 |
| 5.人文關懷服務能力 | 3 關聯性中等 |
◎本學科內容概述：
資料庫技術的進步，讓人們可以輕鬆地管理、檢索、處理資訊。資料庫技術在多數資訊系統中扮演舉足輕重的角色。一個資料庫系統包含一個或多個資料庫、資料庫管理系統、及相關應用程式所組成。本課程範圍包含資訊系統的需求分析、資料庫的概念設計及邏輯設計、資料庫的新增、修改、刪除及查詢，以及資訊應用程式開發。 |
◎本學科教學內容大綱：
1.概論 2.設計流程 3.概念資料模型 4.邏輯資料模型 5.資料庫管理系統操作 6.資料庫語言 |
◎本學科學習目標：
• To introduce students to the concepts and techniques of Database.
• To develop a real-world App Database application. |
| ◎教學進度： |
| 週次 | 主題 | 教學內容 | 教學方法 |
01
02/22 | Class Introduction | Class Introduction | 講授、討論。 |
02
02/29 | Course organization; Databases and Database Users | Chapter 1 | 講授、討論。 |
03
03/07 | Database System Concepts and Architecture | Chapter 2 | 口頭報告、講授、討論。 |
04
03/14 | Data Modeling Using the Entity-Relationship Model | Chapter 3 | 講授、討論。 |
05
03/21 | The Enhanced Entity-Relationship (EER) Model | Chapter 4 | 講授、討論。 |
06
03/28 | ER and EER-to-relational mapping. | Chapter 9 | 講授、討論。 |
07
04/04 | Case Study | Education Store | 講授、討論。 |
08
04/11 | The Relational Data Model and Relational Database Constraints | Chapter 5 | 口頭報告、討論。 |
09
04/18 | Midterm | Midterm | 期中考。 |
10
04/25 | Presentation | Project presentation | 口頭報告、講授、討論。 |
11
05/02 | Relational Algebra | Chapter 8 | 講授、討論。 |
12
05/09 | Basic SQL | Chapter 6 | 講授、討論。 |
13
05/16 | More SQL: Complex Queries, Triggers, Views, and Schema Modification | Chapter 7 | 講授、討論。 |
14
05/23 | Case Study | Ontario Machinery Ring (A) | 講授、討論。 |
15
05/30 | Basics of Functional Dependencies and Normalization | Chapter 14 | 講授、討論。 |
16
06/06 | NOSQL Databases and Big Data Storage Systems | Chapter 24 | 口頭報告、講授、討論。 |
17
06/13 | Presentation | Project presentation | 口頭報告、討論。 |
18
06/20 | Final Exam | Final Exam | 期末考。 |
◎課程要求：
An introductory Python course or consent of instructor. |
◎成績考核
期中考30% : Closed book exam
期末考30% : Closed book exam
作業/習題演練20%
Project 20%
補充說明：Project(Case study)
There will be some class presentations using real world cases. You will critically review these papers on an appropriate topic and then give an oral presentation or attend class discussion (to be announced).
Project description
There will be a course project involving the design, implementation, population, and querying of a small database, using Oracle or a similar relational database management system. The project is an important part of this course. There will be progress reports due during the term and a final report at the end of the term.
Project
There is a mandatory project based on a real-world App database application approved by the instructor. Students will complete the tasks outlined below. As the project contains 25% of the grade, it is important that you spend enough time to achieve the project goals. The project goals are: (1) Understand a real world problem, design an App system; (2) Design your project complete including DB, I/O, processing, and documents; (3) Demonstrate your project to the class. Develop an E-R model or a UML model for this DB. (4) Determine SOP for all the processes. |
◎參考書目與學習資源
Elmasri, R. and Navathe, S.B. (2016) Fundamentals of Database Systems 7th Edition, Pearson. |
| ◎教材講義 請改以帳號登入校務系統選擇全校課程查詢方能查看教材講義 |