NCHU Course Outline

Course Name	(中) 資料庫管理(2077)
	(Eng.) Database Management
Offering Dept	Department of Business Administration
Course Type	Elective			Credits	3	Teacher	Huang Yang
Department	Department of Business Administration / Undergraduate			Language	Chinese	英文/EMI		Semester	2025-SPRING
Course Description	在現今數據驅動的時代，善用資料庫管理企業數據已成為商業分析的關鍵工具。本課程旨在培養學生管理和運用資料庫系統的基礎理論與實務能力。課程內容涵蓋資料庫設計原理、結構化查詢語言(SQL)、資料庫正規化與安全性管理等主題。學生無須程式基礎。不開放資工/資管等具資訊專長相關科系學生加選。 This course aims to develop students' foundational theoretical knowledge and practical skills in database management systems. Course content covers database design principles, Structured Query Language (SQL), database normalization, and security management,...etc. No prerequisite programming skills required. This course is not for students from Computer Science, Information Management, or other CS-related departments.
Prerequisites								self-directed learning in the course	Y

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.建立對於資料庫系統之初步認識 Establish a basic understanding of database systems 2.培養運用結構化查詢語言(SQL)來操作資料庫之能力 Ability to operate databases using Structured Query Language (SQL)	1.Independent Thinking 2.Professional Knowledge with Applications 7.Expression and Communication 8.Cooperation and Coordination	30 40 15 15	Exercises Discussion Lecturing	Written Presentation Attendance Oral Presentation Assignment
Course Content and Homework/Schedule/Tests Schedule
Week Course Content Week 1 Course Overview Week 2 DB System Concepts and Architecture Week 3 Relational Data Model Week 4 SQL Week 5 SQL Week 6 Midterm Exam Review Week 7 運動會補假 Holiday Week 8 Midterm Exam Week 9 Entity-Relationship Model Week 10 Index Structures; Database Design Informal Guidelines Week 11 Tableau Workshop Week 12 Database Normalization Week 13 Final Project Presentation Week 14 Final Project Presentation Week 15 Final Exam Review Week 16 Final Exam Week 17 Self-learning - SQL online practice Week 18 Self-learning - Final project report submission
Evaluation
課堂參與 Class participation(15%) 分組期末專題報告 Group final project (35%)：學生自由選擇感興趣之主題設計資料庫，包括但不限於ER Model繪製、基礎SQL操作、視覺化報表呈現。Students freely choose topics of interest to design databases, including but not limited to ER Model drawing, basic SQL operations, and data visualization. 期中考試 Midterm exam(25%) 期末考試 Final Exam(25%) 考試前一周將針對考試內容進行複習講解。 Class participation(15%) Group final project (35%)：Students are free to choose topics they're interested in for database design, including but not limited to drawing ER Models, basic SQL operations, and data visualization. Midterm exam(25%) Final Exam(25%)
Textbook & other References
Fundamentals of Database Systems, Seven Edition, Pearson, 2017, by Ramez Elmasri and Shamkant B. Navathe.
Teaching Aids & Teacher's Website
Office Hours
Tuesday 10:00~12:00
Sustainable Development Goals, SDGs(Link URL)
include experience courses：N

Please respect the intellectual property rights and use the materials legally.Please respect gender equality.
Update Date, year/month/day：2025/02/27 12:33:20	Printed Date, year/month/day：2025 / 5 / 05
The second-hand book website：http://www.myub.com.tw/