| Course Name |
(中) 資料庫管理系統導論(3314) |
| (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 |
English |
Semester |
2025-SPRING |
| 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 |
| Assignment |
| Quiz |
| Oral Presentation |
|
| 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 |
National Holiday (No Class) |
| Week 8 |
Entity–Relationship Model |
| Week 9 |
Midterm Group Discussion: Final Project Proposal |
| Week 10 |
Database Normalization Theory |
| Week 11 |
Database Normalization Theory |
| Week 12 |
Database Storage Structures |
| Week 13 |
Query Processing and Optimization |
| Week 14 |
Object-Based Databases |
| Week 15 |
XML (XPath and XQuery) |
| Week 16 |
Final Exam |
| Week 17 |
Final Project Presentation |
| Week 18 |
Final Project Presentation |
|
| Evaluation |
Attendance: 10%
- Roll call, class participation, or simply for extra credit.
Written assignments: 35%
- Approximately 5 handwritten assignments (7% each).
Final exam: 25%
- Closed-book written exam.
Final project: 30%
- Group project for implementing a database application. |
| 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 |
| Thursdays 13:00-14:00 |
| Sustainable Development Goals, SDGs |
| 04.Quality Education 08.Decent Work and Economic Growth 09.Industry, Innovation and Infrastructure | include experience courses：Y |
|