2026/27 · 官方课程目录版本
该 PDF 文件注明的生效学期为 Semester A 2025/26。
2026/27 开课标注：Semester A 2026/27 / Semester B 2026/27 · 校方目录标注 ↗
这门课学什么
港真课程概览
由关系资料模型与数据库设计入门，涵盖 SQL 查询、规范化、完整性和安全，再讨论交易与并行控制。
- 课程简介
- 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.
校方 PDF 第 2 页 · Abstract
- 课程内容
- 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.
校方 PDF 第 6 页 · Keyword Syllabus; Syllabus
- 预期学习成果
查看校方学习成果与对应条件
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.校方 PDF 第 2 页 · Course Intended Learning Outcomes (CILOs)
我能不能修这门课
先修、建议先备和并修要求分别查看；等同及互斥条件也会影响选课。and 表示同时满足，or 表示备选；组合条件按下方原文分组阅读。
- 先修条件
- 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
校方 PDF 第 1 页 · Prerequisites
- 建议先备知识
- 无（校方注明 Nil）
校方 PDF 第 1 页 · Precursors
- 并修要求
- 本页尚无已核实的这一项信息。
- 其他修读要求
- 本页尚无已核实的这一项信息。
- 等同课程及条件
- 无（校方注明 Nil）
校方 PDF 第 1 页 · Equivalent Courses
- 互斥课程及条件
- 无（校方注明 Nil）
校方 PDF 第 1 页 · Exclusive Courses
怎么考，怎样才算通过
- 考核方式
- Continuous assessment: 40%; Examination: 60%; Examination duration: 2 hours
各项考核占多少分
考核项目 比重 生成式 AI 使用 备注与限制 3 Assignments (1 assignment every 4 weeks)CILO 1, 2, 3, 4 15% 是（Yes） Need to acknowledge Midterm ExaminationCILO 1, 2, 3 25% 否（No） 原表未列明 查看校方原始考核表与使用要求
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. - 通过条件
- At least 30% of the maximum examination mark is required to pass the course.
校方 PDF 第 3 页 · Additional Information for ATs
学分、时长与版本信息
- 本版本课程名称
- Database Systems
校方 PDF 第 1 页 · Course Code and Course Title
- 本版本学分
- 3
校方 PDF 第 1 页 · Credit Units
- 修读时长
- One Semester
校方 PDF 第 1 页 · Course Duration
- 课纲生效学期
- Semester A 2025/26
- 课纲列明的级别
- B1, B2, B3, B4 - Bachelor's Degree
核对官方原文件
可通过下方校方链接阅读或下载该版原始 PDF。 CS3402 · 打开校方原始 PDF ↗
来源 · 校方课程介绍 ↗ · 查阅