NCHU Course Outline
Course Name (中) 資料庫系統設計(一)(5910)
(Eng.) Database System (I)
Offering Dept Graduate Institute of Data Science and Information Computing
Course Type Elective Credits 1 Teacher Yu-Tsung Tai
Department Department of Applied Mathematics/Undergraduate Language 中/英文 Semester 2024-FALL
Course Description 這系列課程會簡介教育數據的常見格式，及如何在圖形化介面(GUI)中下指令操作這些數據。
如數據來源所述，很多教育數據以逗號分隔(CSV)及Excel活頁簿(xlsx)的格式發佈。因此第一單元會從課本 [1]中的Chapter 5 Keep Excel in Your Toolset和Chapter 3 Database and Date Warehouses開始，簡介如何在Microsoft Excel用最基本的工作表及Power Query操作這些教育數據。
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.
Many educational data sets are shared in comma-separated values (csv) and Microsoft Excel xlsx files. In Database System (I), we will follow Chapter 5 Keep Excel in Your Toolset and Chapter 3 Database and Date Warehouses in our textbook [1] to introduce how to handle these educational data in Microsoft Excel worksheet and Power Query.
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 5 Keep Excel in Your Toolset學習如何用Excel操作逗號分隔(CSV)及Excel活頁簿(xlsx)檔案。
Follow Chapter 5 Keep Excel in Your Toolset in our textbook [1] to handle xlsx and csv files in Excel.
● 依課本 [1]中的Chapter 3 Database and Date Warehouses學習資料庫的基本概念。
Follow Chapter 3 Database and Date Warehouses in our textbook [1] to learn the basic concept of database.
5.Professional Knowledge in Computer Science
100
Exercises
Lecturing
Assignment
Quiz
Course Content and Homework/Schedule/Tests Schedule
Week Course Content
Week 1 2024年07月15日 Introduction
Week 2 2024年07月15日 Compare Database Software
Week 3 2024年07月15日 Educational Data Sets in Excel and Comma-Separated Values (CSV) Formats
Week 4 2024年07月15日 Primary and Foreign Keys
Week 5 2024年07月15日 Dependency Preservation and First, Second, and Third Normal Form
Week 6 2024年07月15日 Use Pivot Table in Excel to Decompose Educational Data While Preserving Dependency
Week 7 2024年07月17日 Worksheet Functions and Visual Basic for Application Macros in Excel
Week 8 2024年07月17日 Use VLOOKUP Worksheet Function to JOIN Educational Data Tables
Week 9 2024年07月17日 Record Visual Basic for Application Macros in Excel to Automate Educational Data Processing Tasks
Week 10 2024年07月17日 Use Power Query in Excel to Decompose Educational Data While Preserving Dependency
Week 11 2024年07月17日 Use Merge Queries in Power Query to JOIN Educational Data Tables
Week 12 2024年07月17日 Practice Power Query in Excel
Week 13 2024年07月19日 Reverse the Process of Full OUTER JOIN Toward Entity Integrity
Week 14 2024年07月19日 Filter Rows in Power Query to Reverse the Process of Full OUTER JOIN
Week 15 2024年07月19日 Add a New Index Column to Finalize Entity Integrity
Week 16 2024年07月19日 Final Exam
Week 17 2024年07月19日 Final Exam
Week 18 2024年07月19日 Final Exam
Evaluation
● 作業 50% 平時課堂指派作業，以實際操作後截圖上傳為主
Assignment 50% Assigned mainly in class to upload the screenshot
● 期末考 50% 紙本選擇填充題
Final Exam 50% Paper-based multiple-choice or filling-blank questions
Textbook & other References
其中 [1]是課本，其他為參考書目。
Within the references, [1] is the textbook, and the other is the general reference.

References
[1] K. Jamsa, Introduction to Data Mining and Analytics, Burlington, MA: Jones & Bartlett Learning, 2020, p. 668.
[2] Microsoft, ”Excel 說明與學習,” 2022. [Online]. Available: https://support.microsoft.com/zh-tw/excel. [Accessed 19 12 2022].
[3] R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, 7 ed., Hoboken, NJ: Pearson Addison Wesley, 2015.
[4] C. Coronel and S. Morris, Database Systems: Design, Implementation, and Management, 13 ed., Boston, MA: Cengage, 2022.
Teaching Aids & Teacher's Website
微學程網站 https://reurl.cc/Z1o8Z3
Google Classroom https://classroom.google.com/c/NjkxNDcxMDAxMTE4?cjc=jkudwel
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:15:32 Printed Date, year/month/day：2024 / 11 / 21
The second-hand book website：http://www.myub.com.tw/