TrustGuide HK
中文EN

Local review · Access to each material is reviewed separately. This is not a personal registration or degree audit.

City University of Hong Kong · Course

CS3402Database Systems

2026/27 · Undergraduate

Course code
CS3402
Credit units
3
Academic unit
Department of Computer Science
Readable study materials
139 items

Course overview and requirements

Choose the outline year, then review the content, entry requirements and assessment.

2026/27 · Official catalogue edition

The effective term printed in this PDF is Semester A 2025/26。

Offering record for 2026/27：Semester A 2026/27 / Semester B 2026/27 · Catalogue source ↗

What you will study

Course overview
This course is aimed at equipping students with the knowledge of database design, as well as, the ability to use database management systems in an effective manner. The course will also provide an insight into database management techniques and concepts, namely, indexing, query optimization, transactions, concurrency control, and database recovery.

Official PDF, page 2 · Abstract

Course content
Keyword Syllabus Database design methodology: entity-relationship model, functional dependency, normalization, data definition language. Query Language: SQL, relational algebra, query by example. Data model: relational model. Database management issues: integrity, trigger, user constraint, security. Transaction management: ACID properties, concurrency control, serializability, locking protocols, deadlock. Syllabus • Introduction Database history. File-based system vs database. Database components. Architecture. Data independence. Data models. • File organization Physical data organization: Ordered file. Indexed file. Hash file. • Data model and query Relational model: schema, primary key, foreign key, algebra, database operators. Data definition. SQL. • Database design Entity Relationship model. Data redundancy. Functional dependency. Normalization: BCNF, 3NF. • Transaction management Concurrency Control: ACID Properties, Serializability, Locking Protocols, deadlock detection and prevention.

Official PDF, page 6 · Keyword Syllabus; Syllabus

Intended learning outcomes
View official learning outcomes and conditions
Course Intended Learning Outcomes (CILOs)
               CILOs                                               Weighting (if DEC-A1         DEC-A2          DEC-A3
                                                                   app.)
1              Design a database schema database schema                                         x
               using the entity-relationship and relational data
               models.
2              Improve an existing database schema through                          x
               the normalization process.
3              Apply SQL as a Data Definition Language (DDL)                         x
               and a Data Manipulation Language (DML)
               effectively.
4              Demonstrate good understanding of database                                       x
               management techniques and concepts.

A1: Attitude
Develop an attitude of discovery/innovation/creativity, as demonstrated by students possessing a strong sense of curiosity,
asking questions actively, challenging assumptions or engaging in inquiry together with teachers.

A2: Ability
Develop the ability/skill needed to discover/innovate/create, as demonstrated by students possessing critical thinking skills
to assess ideas, acquiring research skills, synthesizing knowledge across disciplines or applying academic knowledge to
real-life problems.

A3: Accomplishments
Demonstrate accomplishment of discovery/innovation/creativity through producing /constructing creative works/new
artefacts, effective solutions to real-life problems or new processes.

Official PDF, page 2 · Course Intended Learning Outcomes (CILOs)

Before you take this course

Check prerequisites, precursors and corequisites separately, together with equivalence and exclusion conditions. “and” means conditions must be met together; “or” marks alternatives. Read combined conditions in the groupings shown in the original text below.

Prerequisites
CS1315 Introduction to Computer Programming or CS2310 Computer Programming or CS2311 Computer Programming or CS2313 Computer Programming or CS2315 Computer Programming or CS2360 Java Programming or equivalent

Official PDF, page 1 · Prerequisites

Precursors
Nil

Official PDF, page 1 · Precursors

Corequisites
Complete official information for this field is not available.
Additional course requirements
Complete official information for this field is not available.
Equivalent courses and conditions
Nil

Official PDF, page 1 · Equivalent Courses

Exclusive courses and conditions
Nil

Official PDF, page 1 · Exclusive Courses

Assessment and passing the course

Assessment
Continuous assessment: 40%; Examination: 60%; Examination duration: 2 hours

Assessment breakdown

Assessment taskWeightGenerative AIRemarks and restrictions
3 Assignments (1 assignment every 4 weeks)CILO 1, 2, 3, 415%YesNeed to acknowledge
Midterm ExaminationCILO 1, 2, 325%NoNot stated in source row
View the original assessment table and instructions
Assessment Tasks / Activities (ATs)
                     ATs                  CILO No.             Weighting (%)        Remarks ("-" for    Allow Use of
                                                                                    nil entry)          GenAI?
1                    3 Assignments (1   1, 2, 3, 4             15                   Need to             Yes
                     assignment every 4                                             acknowledge
                     weeks)
2                    Midterm              1, 2, 3              25                   -                   No
                     Examination

Continuous Assessment (%)
40

Examination (%)
60

Examination Duration (Hours)
2

Minimum Examination Passing Requirement (%)
30

Additional Information for ATs
For a student to pass the course, at least 30% of the maximum mark for the examination must be obtained.
Passing requirements
At least 30% of the maximum examination mark is required to pass the course.

Official PDF, page 3 · Additional Information for ATs

Credits, duration and edition details
Title in this edition
Database Systems

Official PDF, page 1 · Course Code and Course Title

Credits in this edition
3

Official PDF, page 1 · Credit Units

Course duration
One Semester

Official PDF, page 1 · Course Duration

Syllabus effective term
Semester A 2025/26
Levels printed in the syllabus
B1, B2, B3, B4 - Bachelor's Degree

Check the official document

Read or download this edition through the university link below. CS3402 · Open the original university PDF ↗

Source · University course information ↗ · Checked

Study materials

139 readable items

Browse by the material’s own year and type. Historical materials are study references.

40 / 139 items

  • Lecture07_Disk_Storage__内容不同_4a307ca5b2

    Lecture slides · 2021 Semester B (year and term from the original folder) · Local review material · 1.3 MB

    Download original ↧

  • Tutorial02_Relational_Model

    Tutorials · 2021 Semester B (year and term from the original folder) · Local review material · 60 KB

    Download original ↧

  • CS3402-0203A

    Past papers · 2002-2003 Semester A · Local review material · 195 KB

    Download original ↧

  • CS3402-0102A

    Past papers · 2001-2002 Semester A · Local review material · 172 KB

    Download original ↧

  • Assignment 1_solutions

    Solutions · Year unknown Term unknown · Local review material · 151 KB

    Material type follows its original classification.

    Download original ↧

  • Assignment 2_solutions

    Assignments · Year unknown Term unknown · Local review material · 1008 KB

    Download original ↧

  • assignment_solutions

    Solutions · Year unknown Term unknown · Local review material · 38 KB

    Download original ↧

  • CS3402DatabaseSystem

    Past papers · Year unknown Term unknown · Local review material · 3 KB

    Material type follows its original classification.

    Download original ↧

  • CS3462 midterm_2

    Past papers · Year unknown Term unknown · Local review material · 6.0 MB

    原页共同标注 CS3462/CS3402 Midterm examination，含少量手写批注；姓名、学号栏为空。两个原样代码分别关联，不据此认定课程等同。

    Download original ↧

  • homework1_sol

    Assignments · Year unknown Term unknown · Local review material · 849 KB

    Download original ↧

  • homework2_sol (2)

    Assignments · Year unknown Term unknown · Local review material · 715 KB

    Download original ↧

  • homework3_sol (1)

    Assignments · Year unknown Term unknown · Local review material · 578 KB

    Download original ↧

  • lec02

    Lecture slides · Year unknown Term unknown · Local review material · 2.2 MB

    Material type follows its original classification.

    Download original ↧

  • lec03

    Lecture slides · Year unknown Term unknown · Local review material · 1.4 MB

    Material type follows its original classification.

    Download original ↧

  • lec04

    Lecture slides · Year unknown Term unknown · Local review material · 1.7 MB

    Material type follows its original classification.

    Download original ↧

  • lec05

    Lecture slides · Year unknown Term unknown · Local review material · 2.0 MB

    Material type follows its original classification.

    Download original ↧

  • lec06

    Lecture slides · Year unknown Term unknown · Local review material · 2.1 MB

    Material type follows its original classification.

    Download original ↧

  • lec07

    Lecture slides · Year unknown Term unknown · Local review material · 2.9 MB

    Material type follows its original classification.

    Download original ↧

  • lec08

    Lecture slides · Year unknown Term unknown · Local review material · 6.2 MB

    Material type follows its original classification.

    Download original ↧

  • lec09

    Lecture slides · Year unknown Term unknown · Local review material · 6.7 MB

    Material type follows its original classification.

    Download original ↧

  • lec10

    Lecture slides · Year unknown Term unknown · Local review material · 6.8 MB

    Material type follows its original classification.

    Download original ↧

  • lec11

    Lecture slides · Year unknown Term unknown · Local review material · 4.8 MB

    Material type follows its original classification.

    Download original ↧

  • Lecture01_ERModel

    Lecture slides · Year unknown Term unknown · Local review material · 846 KB

    Download original ↧

  • Lecture1_ERModel

    Lecture slides · Year unknown Term unknown · Local review material · 891 KB

    Download original ↧

  • Lecture1_ERModel

    Lecture slides · Year unknown Term unknown · Local review material · 696 KB

    Download original ↧

  • Lecture02_Relational_Model

    Lecture slides · Year unknown Term unknown · Local review material · 809 KB

    Download original ↧

  • Lecture2_Relational_Model

    Lecture slides · Year unknown Term unknown · Local review material · 842 KB

    Download original ↧

  • Lecture2_Relational_Model

    Lecture slides · Year unknown Term unknown · Local review material · 645 KB

    Download original ↧

  • Lecture03_Relational_Algebra

    Lecture slides · Year unknown Term unknown · Local review material · 1.7 MB

    Download original ↧

  • Lecture3_SQL

    Lecture slides · Year unknown Term unknown · Local review material · 2.5 MB

    Download original ↧

  • Lecture3_SQL

    Lecture slides · Year unknown Term unknown · Local review material · 3.9 MB

    Download original ↧

  • Lecture4_Relational_Algebra

    Lecture slides · Year unknown Term unknown · Local review material · 2.0 MB

    Download original ↧

  • Lecture4_Relational_Algebra

    Lecture slides · Year unknown Term unknown · Local review material · 2.5 MB

    Download original ↧

  • Lecture04_SQL_Basic

    Lecture slides · Year unknown Term unknown · Local review material · 1.6 MB

    Download original ↧

  • Lecture5_Integrity_Constraints

    Lecture slides · Year unknown Term unknown · Local review material · 603 KB

    Download original ↧

  • Lecture5_Integrity_Constraints

    Lecture slides · Year unknown Term unknown · Local review material · 2.1 MB

    Download original ↧

  • Lecture05_SQL_Complex

    Lecture slides · Year unknown Term unknown · Local review material · 498 KB

    Download original ↧

  • Lecture06_Normalization

    Lecture slides · Year unknown Term unknown · Local review material · 689 KB

    Download original ↧

  • Lecture6_Normalization

    Lecture slides · Year unknown Term unknown · Local review material · 1.2 MB

    Download original ↧

  • Lecture6_Normalization

    Lecture slides · Year unknown Term unknown · Local review material · 1.3 MB

    Download original ↧

Ready to register for this course?

  1. Check the year and entry requirements

    Use the relevant outline year and check the prerequisites, corequisites and exclusions. Verify missing conditions through the official source linked on this page.

  2. Check your programme curriculum

    Confirm which requirement the course fulfils and any alternatives or credit requirements within its course group.

  3. Choose sections in AIMS and confirm the result

    Check the available sections, places and times for the term. After submitting through the registration process, confirm that the course and its sections have been added successfully.

Registration steps, restrictions & confirmation →Open AIMS registration ↗Academic Regulations and Records Office ↗

Related course codes

Equivalences preserve original course codes and years; historical slides are not automatically current-course material.