SDSC5003 Course Information

#sdsc5003 #course information

English / 中文

Course Overview

Course Code: SDSC5003

Course Name: Introduction to Database Systems

Semester: 2025/26 Academic Year, Semester 1

Instructors:

  • Yu Yang (yuyang@cityu.edu.hk)

  • Terence Chan (terenceChan@cityu.edu.hk)

Teaching Model: Face-to-face

Office Hours: To be announced (TBA)

Teaching Assistant: Not specified

Assessment Method

Component Weight Details
Individual Assignments 30% Multiple assignments focusing on database design and implementation.
Group Project 20% Team-based project (3-5 students). Tracks: Database Application Development or Research Paper Replication.
Final Exam 50% Comprehensive exam covering all course content; closed-book, with permitted aids.

Schedule and Teaching Plan

Week Date (Example) Activity Content Deadline
1 2025-09-06 Lecture Introduction & ER Model
2 2025-09-13 Lecture Relational Model
3 2025-09-20 Lecture Relational Algebra
4 2025-09-27 Lecture SQL Queries I Assignment 1 released
5 2025-10-04 Lecture SQL Queries II & SQL Constraints Assignment 1 due
Group formation deadline
6 2025-10-11 No Teaching CityU Info Day; Design Theory (self-study)
7 2025-10-18 Lecture Time Complexity & Storage and Indexing I
8 2025-10-25 Lecture Storage and Indexing II Assignment 2 released
9 2025-11-01 Lecture Storage and Indexing III & Query Evaluation Project proposal due
10 2025-11-08 Lecture Parallel Data Processing & MapReduce Assignment 2 due
11 2025-11-15 Lecture Spark & Overview of Transaction Management Assignment 3 released
12 2025-11-22 Lecture Vector DB & Course Review
13 2025-11-29 Review Session Exam preparation and project Q&A Assignment 3 due
Final project report due

Project Requirements (20% of Total Grade)

Key Deadlines:

  1. Group Formation (1 point)

    • Deadline: Week 5 (e.g., October 5, 2025, 23:59)
    • Filename: Team-Formation-XX (XX = Team Name)

  2. Project Proposal (4 points)

    • Deadline: Week 9 (e.g., November 2, 2025, 23:59)
    • Format: ≥0.5-page PDF proposal
    • Filename: Team-Proposal-XX

  3. Final Submission (15 points)

    • Deadline: Week 13 (e.g., November 30, 2025, 23:59)
    • Submission includes:
      • Source Code (30% weight): PDF of code → Team-Appendix-XX
      • Video Demonstration (20% weight): 5-minute max video → Team-Video-XX
      • Written Report (50% weight): ≤6-page PDF (cover page, methodology, results, conclusion) → Team-MainReport-XX

Project Rules:

  • Topic: Must use database systems concepts (Track 1: Application Development; Track 2: Research Replication).

  • Data Source: Mandatory use of Hong Kong Open Data (e.g., public transport datasets).

  • Originality: Projects must be independently designed for this course; reuse of prior work or plagiarism is prohibited.

  • Grading Criteria: Scientific value and innovation are prioritized; strict anti-plagiarism enforcement.