Welcome! This class focuses on the fundamental knowledge and theory of database and database management systems.

Announcement

• Archive

Basic Information

• Class Time: Mon 15:30-16:20, Thu 10:10-12:00
• Class Location: EC122
• E3: https://e3p.nycu.edu.tw/course/view.php?id=17287
• Course Website: https://cscs10022-database-fall2025.notion.site/
• Contact: [email protected]

Course Schedule

Course Calendar

Assignments

Assignment 0: Honor Code (Due: Wed, 09/10)

• Assignment 1: Apply SQL on real-world datasets (Due: Wed, 10/15)
• Assignment 2: TBD

Final Project Milestones

• Project - Part 1: Group formation & Ideation (Due: Wed, 09/17)
• Project - Part 2: TBD
• Project - Part 3: Final Submission (Due: Wed, 12/14)

Course Staff

• Instructor: Professor Dennis Wang (Computer Science)
  • Email: [email protected]
• TAs: To be announced

Syllabus

Policies and background for CSCS10022, Introduction to Database Systems, (114-1 / Fall 2025). All syllabus content is subject to change, particularly prior to the start of the semester.

Course Description

Databases are at the core of modern application development. With structural data being the cornerstone across almost every domain of human activity, including financial transaction, scientific work, and digital public infrastructure, it is crucial to have database management systems that are carefully designed to be built and populated with data for different scenarios.

In this course, we will cover topics that are essential to database, including:

• Theory of relational data design (data models, relational models, entity-relationship (E-R) Modeling)
• Query languages (SQL, stored procedures)
• Efficient storage of data (database design, normalization, constraints, integrity)
• Indexing and performance (order preserving trees, hash tables, vector indexes, query processing and optimization)

For the detailed list of topics and schedule, please see the course calendar.

Learning Objectives