NCHU Course Outline
Course Name (中) 資料庫系統設計(三)(5912)
(Eng.) Database System (III)
Offering Dept Graduate Institute of Data Science and Information Computing
Course Type Elective Credits 1 Teacher Yu-Tsung Tai
Department Graduate Institute of Data Science and Information Computing/Graduate Language 中/英文 Semester 2024-FALL
Course Description 本系列課程會簡介教育數據的常見格式，及如何在圖形化介面(GUI)中下指令操作這些數據。
雖然 csv 檔是最常見用以交換教育數據的格式之一，但需在先設定好固定的欄位，每個欄位也只有有限的資料型態。為了有更多的彈性處理各種資料，在資料庫系統設計(三)中，我們將會介紹 JSON 格式及如何用以匯入匯出 Excel 及 MySQL 中的資料。此外，我們也會介紹如何在 Python 程式中讀寫 MySQL 資料庫，讓未來的老師們能理解學習管理系統讀寫資料的原理，並為了有需要時開發自己的學習管理系統預做準備。
In the series of Database System (I), (II), and (III), we will introduce educational data sets, its common formats and methods to handle these data via graphical user interfaces (GUI) and programs.
Although csv files provides a way to exchange educational data, it requires us to completely determine all data fields within a limited number of types. To be more flexible exchange educational data, we introduce JavaScript Object Notation (JSON) and import and export data in Excel and MySQL database in this format. Besides, we will discuss how to access MySQL database in Python so that the future teachers will have basic idea about how learning management system access data, and prepare for developing their own learning management system.
Prerequisites
self-directed learning in the course N
Relevance of Course Objectives and Core Learning Outcomes(%) Teaching and Assessment Methods for Course Objectives
Course Objectives Competency Indicators Ratio(%) Teaching Methods Assessment Methods
依課本 [1]中的 Chapter 3 Database and Data Warehouses 和 Chapter 6 Keep SQL in Your Toolset 學習在 Access 裡自動化正規化及轉換滑鼠操作為 SQL 語句。
Follow Chapter 3 Database and Data Warehouses and Chapter 6 Keep SQL in Your Toolset in [1] to normalize database in Access and transform our idea and operations into SQL statements.
3.
6.
50
50
Exercises
Lecturing
Assignment
Quiz
Course Content and Homework/Schedule/Tests Schedule
Week Course Content
Week 1 2024年05月16日 Make-up Exam for Database System (II) on May 16th, 2024 and Data Types in Microsoft Access
Week 2 2024年05月16日 Make-up Exam for Database System (II) on May 16th, 2024 and Use Mid Function to Split Educational Data in Microsoft Access
Week 3 2024年05月16日 Make-up Exam for Database System (II) on May 16th, 2024 and Modify SELECT Statement in Access to First Normalize Educational Data Table
Week 4 2024年05月23日 Import Excel Educational Data into Microsoft Access
Week 5 2024年05月23日 Use Table Analyzer to Analyze the Imported Tables
Week 6 2024年05月23日 Modify the Access-Generated SELECT Statement to Run in MySQL Workbrench
Week 7 2024年05月30日 First-Normalizing Access Tables by Power Query in Excel
Week 8 2024年05月30日 Modify Power Query-Generated SELECT Statements to Show a Table in Microsoft Access
Week 9 2024年05月30日 Modify Power Query-Generated SELECT Statements to Join Tables in Microsoft Access
Week 10 2024年06月06日 We Could View the Native SQL Statement of Which Kind of Queries in Power Query
Week 11 2024年06月06日 Read MySQL in Power Query via ODBC
Week 12 2024年06月06日 Read MySQL in Power Query via ODBC
Week 13 2024年06月13日 Final Exam on June 13th, 2024
Week 14 2024年06月13日 Final Exam on June 13th, 2024
Week 15 2024年06月13日 Final Exam on June 13th, 2024
Week 16 2024年06月20日 Make-up Exam for Database System (III) on June 20th, 2024
Week 17 2024年06月20日 Make-up Exam for Database System (III) on June 20th, 2024
Week 18 2024年06月20日 Make-up Exam for Database System (III) on June 20th, 2024
Evaluation
作業50%、期末考50%
Assignment 50% and Final Exam 50%
Textbook & other References
其中 [1]是課本，其他為參考書目。
Within the references, [1] is the textbook, and the others are general references.

References
[1] K. Jamsa, Introduction to Data Mining and Analytics, Burlington, MA: Jones & Bartlett Learning, 2020, p. 668.
[2] Microsoft, ＂Access help & learning,＂ 2022. [Online]. Available: https://support.microsoft.com/en-us/access. [Accessed 22 07 2024].
[3] C. Coronel and S. Morris, Database Systems: Design, Implementation, and Management, 13 ed., Boston, MA: Cengage, 2022.
[4] R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, 7 ed., Hoboken, NJ: Pearson Addison Wesley, 2015.
Teaching Aids & Teacher's Website
微學程網站 https://reurl.cc/Z1o8Z3
Office Hours
可於下課後留在教室提問
Sustainable Development Goals, SDGs
04.Quality Education   08.Decent Work and Economic Growth   09.Industry, Innovation and Infrastructureinclude experience courses：Y
Please respect the intellectual property rights and use the materials legally.Please repsect gender equality.
Update Date, year/month/day：2024/08/11 01:29:45 Printed Date, year/month/day：2024 / 11 / 21
The second-hand book website：http://www.myub.com.tw/