| Course Name |
(中) 資料庫管理系統導論(3286) |
| (Eng.) Introduction to Database Management System |
| Offering Dept |
Department of Computer Science and Engineering |
| Course Type |
Elective |
Credits |
3 |
Teacher |
Jason Lin |
| Department |
Department of Computer Science and Engineering/Undergraduate |
Language |
中/英文 |
Semester |
2025-FALL |
| Course Description |
This course provides an introduction to the fundamental concepts of database management systems. Topics include the core functions and components of database systems, various data models, design principles, query languages, data processing techniques, and real-world applications. Students will gain a solid foundation in database design and management, preparing them for further exploration into more advanced topics in database systems and their applications. |
| 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 |
| The primary goal of this course is to introduce students to the fundamental principles of database management systems. Students will develop an understanding of the key functions, architecture, and components of these systems. The course will also cover essential topics such as data models (including ER and relational models), query languages (primarily SQL), and the design processes involved in building and managing databases. By the end of the course, students will have the foundational knowledge required to work with and design functional database systems. |
| 1.Having abilities on computer science literacy, information theory, and mathematical analysis. |
| 3.Having abilities of analyzing, designing, and implementing IT software systems. |
| 4.Having abilities of analyzing, designing, and integrating IT application systems. |
|
|
|
| Written Presentation |
| Attendance |
| Quiz |
| Oral Presentation |
| Internship |
|
| Course Content and Homework/Schedule/Tests Schedule |
| Week |
Course Content |
| Week 1 |
Overview of Database Systems |
| Week 2 |
Introduction to Relational Model |
| Week 3 |
Structured Query Language |
| Week 4 |
Structured Query Language |
| Week 5 |
Structured Query Language |
| Week 6 |
Structured Query Language |
| Week 7 |
Entity–Relationship Model |
| Week 8 |
Entity–Relationship Model |
| Week 9 |
Final Project Proposal (Midterm) |
| Week 10 |
Database Normalization Theory |
| Week 11 |
Database Normalization Theory |
| Week 12 |
Database Storage Structures |
| Week 13 |
Object-Based Databases |
| Week 14 |
XML (XPath and XQuery) |
| Week 15 |
Final Project Presentation |
| Week 16 |
Final Exam |
self-directed
learning |
03.Preparing presentations or reports related to industry and academia.
|
|
| Evaluation |
Attendance: 10%
- Roll call, class participation, or simply for extra credit.
Pop Quiz: 30%
- Approximately 5 to 6 in-class quizzes.
Final Project: 35%
- Group project for implementing a database application.
Final Comprehensive Exam: 25%
- Closed-book written exam. |
| Textbook & other References |
| Avi Silberschatz, Henry F. Korth, and S. Sudarshan, Database System Concepts, 7th Edition, McGraw-Hill, 2019. |
| Teaching Aids & Teacher's Website |
| Please refer to iLearning 3.0 |
| Office Hours |
| Wednesdays 14:00-15:00 |
| Sustainable Development Goals, SDGs(Link URL) |
03.Preparing presentations or reports related to industry and academia.
09.Industry, Innovation and Infrastructure | include experience courses：Y |
|