Week 1Course Overview and Intro to DBMS Introduction to database management, including traditional file-based systems, the dat
### 📖 核心知识点：Course Overview and Intro to DBMS Introduction to database management, including traditional file-based systems, the database management system and fundamental database concepts. Readings/Ref: CB (Ch. 1, 2) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Course Overview and Intro to DBMS Introduction to database management, including traditional file-based systems, the database management system and fundamental database concepts. Readings/Ref: CB (Ch. 1, 2), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Course Overview and Intro to DBMS Introduction to database management, including traditional file-based systems, the database management system and fundamental database concepts. Readings/Ref: CB (Ch. 1, 2)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）
CourseOverviewandIntrotoDBMSIntroductiontodatabasemanagement
💡 学习提示
• 总结 Course Overview and Intro to DBMS Introduction to database management, including traditional file-based systems, the dat 的核心概念与适用场景
• 为第1周生成 5 道练习题并给出解题步骤
Week 2Entity Relationship Modelling Entity relationship modelling is explored in terms of a data driven approach using entity-
### 📖 核心知识点：Entity Relationship Modelling Entity relationship modelling is explored in terms of a data driven approach using entity-relationship diagrams including design elements such as entities, relationships, attributes, keys and multiplicity. Readings/Ref: CB (Ch. 12 and 13) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Entity Relationship Modelling Entity relationship modelling is explored in terms of a data driven approach using entity-relationship diagrams including design elements such as entities, relationships, attributes, keys and multiplicity. Readings/Ref: CB (Ch. 12 and 13), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Entity Relationship Modelling Entity relationship modelling is explored in terms of a data driven approach using entity-relationship diagrams including design elements such as entities, relationships, attributes, keys and multiplicity. Readings/Ref: CB (Ch. 12 and 13)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 复习时只看结论不做推导，导致考试应用题失分。 (BISM7206)）
EntityRelationshipModellingEntityrelationshipmodellingisexploredinterms
💡 学习提示
• 总结 Entity Relationship Modelling Entity relationship modelling is explored in terms of a data driven approach using entity- 的核心概念与适用场景
• 为第2周生成 5 道练习题并给出解题步骤
Week 3Relational Model Relational model concepts are discussed including specific terminology, keys, views and integrity const
### 📖 核心知识点：Relational Model Relational model concepts are discussed including specific terminology, keys, views and integrity constraints. Readings/Ref: CB (Ch. 4) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Relational Model Relational model concepts are discussed including specific terminology, keys, views and integrity constraints. Readings/Ref: CB (Ch. 4), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Relational Model Relational model concepts are discussed including specific terminology, keys, views and integrity constraints. Readings/Ref: CB (Ch. 4)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 复习时只看结论不做推导，导致考试应用题失分。 (BISM7206)）
RelationalModelRelationalmodelconceptsarediscussedincludingspecificterminology
💡 学习提示
• 总结 Relational Model Relational model concepts are discussed including specific terminology, keys, views and integrity const 的核心概念与适用场景
• 为第3周生成 5 道练习题并给出解题步骤
Week 4Structured Query Language (I) Introduction to basic SQL DDL and DML statements. Readings/Ref: CB (Ch. 6,7)
### 📖 核心知识点：Structured Query Language (I) Introduction to basic SQL DDL and DML statements. Readings/Ref: CB (Ch. 6,7) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Structured Query Language (I) Introduction to basic SQL DDL and DML statements. Readings/Ref: CB (Ch. 6,7), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Structured Query Language (I) Introduction to basic SQL DDL and DML statements. Readings/Ref: CB (Ch. 6,7)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）
StructuredQueryLanguageIIntroductiontobasicSQLDDLand
💡 学习提示
• 总结 Structured Query Language (I) Introduction to basic SQL DDL and DML statements. Readings/Ref: CB (Ch. 6,7) 的核心概念与适用场景
• 为第4周生成 5 道练习题并给出解题步骤
Week 5Structured Query Language (II) Exploring aggregation and grouping, and relational operations to enable search conditions
### 📖 核心知识点：Structured Query Language (II) Exploring aggregation and grouping, and relational operations to enable search conditions and order/grouping of results. Readings/Ref: CB (Ch. 6,7) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Structured Query Language (II) Exploring aggregation and grouping, and relational operations to enable search conditions and order/grouping of results. Readings/Ref: CB (Ch. 6,7), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Structured Query Language (II) Exploring aggregation and grouping, and relational operations to enable search conditions and order/grouping of results. Readings/Ref: CB (Ch. 6,7)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）
StructuredQueryLanguageIIExploringaggregationandgroupingandrelational
💡 学习提示
• 总结 Structured Query Language (II) Exploring aggregation and grouping, and relational operations to enable search conditions 的核心概念与适用场景
• 为第5周生成 5 道练习题并给出解题步骤
Week 6AI Debate Week – No Lecture
### 📖 核心知识点：AI Debate Week – No Lecture 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: AI Debate Week – No Lecture, analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“AI Debate Week – No Lecture”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 复习时只看结论不做推导，导致考试应用题失分。 (BISM7206)）
AIDebateWeek–NoLecture
💡 学习提示
• 总结 AI Debate Week – No Lecture 的核心概念与适用场景
• 为第6周生成 5 道练习题并给出解题步骤
Week 7Normalisation Explore how normalisation supports database design and how concepts such as partial, transitive, and funct
### 📖 核心知识点：Normalisation Explore how normalisation supports database design and how concepts such as partial, transitive, and functional dependencies enable the logical database design to transition and conform to particular normal forms. Readings/Ref: CB (Ch. 14,15) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Normalisation Explore how normalisation supports database design and how concepts such as partial, transitive, and functional dependencies enable the logical database design to transition and conform to particular normal forms. Readings/Ref: CB (Ch. 14,15), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Normalisation Explore how normalisation supports database design and how concepts such as partial, transitive, and functional dependencies enable the logical database design to transition and conform to particular normal forms. Readings/Ref: CB (Ch. 14,15)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）
NormalisationExplorehownormalisationsupportsdatabasedesignandhowconcepts
💡 学习提示
• 总结 Normalisation Explore how normalisation supports database design and how concepts such as partial, transitive, and funct 的核心概念与适用场景
• 为第7周生成 5 道练习题并给出解题步骤
Week 8Data Quality and Cleaning Data is a valuable resource and access to accurate, current and informative data is critical t
### 📖 核心知识点：Data Quality and Cleaning Data is a valuable resource and access to accurate, current and informative data is critical to business success. Therefore, data needs to be managed and organised like other business assets. 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Data Quality and Cleaning Data is a valuable resource and access to accurate, current and informative data is critical to business success. Therefore, data needs to be managed and organised like other business assets., analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Data Quality and Cleaning Data is a valuable resource and access to accurate, current and informative data is critical to business success. Therefore, data needs to be managed and organised like other business assets.”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 复习时只看结论不做推导，导致考试应用题失分。 (BISM7206)）
DataQualityandCleaningDataisavaluableresourceand
💡 学习提示
• 总结 Data Quality and Cleaning Data is a valuable resource and access to accurate, current and informative data is critical t 的核心概念与适用场景
• 为第8周生成 5 道练习题并给出解题步骤
Week 9Guest Lecture
### 📖 核心知识点：Guest Lecture 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Guest Lecture, analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Guest Lecture”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 复习时只看结论不做推导，导致考试应用题失分。 (BISM7206)）
GuestLecture
💡 学习提示
• 总结 Guest Lecture 的核心概念与适用场景
• 为第9周生成 5 道练习题并给出解题步骤
Week 10Transaction Management This lecture explores the critical role of transaction management in business systems, focusing o
### 📖 核心知识点：Transaction Management This lecture explores the critical role of transaction management in business systems, focusing on how organisations maintain data integrity and consistency in multi-user environments and recover from failures to ensure reliable operations. Readings/Ref: CB (Ch. 22) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Transaction Management This lecture explores the critical role of transaction management in business systems, focusing on how organisations maintain data integrity and consistency in multi-user environments and recover from failures to ensure reliable operations. Readings/Ref: CB (Ch. 22), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Transaction Management This lecture explores the critical role of transaction management in business systems, focusing on how organisations maintain data integrity and consistency in multi-user environments and recover from failures to ensure reliable operations. Readings/Ref: CB (Ch. 22)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 只写组件清单，不写故障场景与容量取舍。 (BISM7206)）
TransactionManagementThislectureexploresthecriticalroleoftransaction
💡 学习提示
• 总结 Transaction Management This lecture explores the critical role of transaction management in business systems, focusing o 的核心概念与适用场景
• 为第10周生成 5 道练习题并给出解题步骤
Week 11Database Security and Control We’ll look at why database security matters, the main threats to data security, and the co
### 📖 核心知识点：Database Security and Control We’ll look at why database security matters, the main threats to data security, and the core ideas of confidentiality, integrity, and availability (the CIA triad). We’ll also cover practical countermeasures and finish with an overview of Data Control Language (DCL). Readings/Ref: CB (Ch. 20) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Database Security and Control We’ll look at why database security matters, the main threats to data security, and the core ideas of confidentiality, integrity, and availability (the CIA triad). We’ll also cover practical countermeasures and finish with an overview of Data Control Language (DCL). Readings/Ref: CB (Ch. 20), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Database Security and Control We’ll look at why database security matters, the main threats to data security, and the core ideas of confidentiality, integrity, and availability (the CIA triad). We’ll also cover practical countermeasures and finish with an overview of Data Control Language (DCL). Readings/Ref: CB (Ch. 20)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）
DatabaseSecurityandControlWe’lllookatwhydatabasesecurity
💡 学习提示
• 总结 Database Security and Control We’ll look at why database security matters, the main threats to data security, and the co 的核心概念与适用场景
• 为第11周生成 5 道练习题并给出解题步骤
Week 12Distributed Database Management Systems We examine distributed DBMSs including concepts, problems, technologies and prot
### 📖 核心知识点：Distributed Database Management Systems We examine distributed DBMSs including concepts, problems, technologies and protocols. Readings/Ref: CB (Ch. 24, 25) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Distributed Database Management Systems We examine distributed DBMSs including concepts, problems, technologies and protocols. Readings/Ref: CB (Ch. 24, 25), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Distributed Database Management Systems We examine distributed DBMSs including concepts, problems, technologies and protocols. Readings/Ref: CB (Ch. 24, 25)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）
DistributedDatabaseManagementSystemsWeexaminedistributedDBMSsincludingconcepts
💡 学习提示
• 总结 Distributed Database Management Systems We examine distributed DBMSs including concepts, problems, technologies and prot 的核心概念与适用场景
• 为第12周生成 5 道练习题并给出解题步骤
Week 13Overview and Big Data & Technologies Exploring why data management technologies and approaches have expanded beyond rela
### 📖 核心知识点：Overview and Big Data & Technologies Exploring why data management technologies and approaches have expanded beyond relational databases and data warehousing. 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Overview and Big Data & Technologies Exploring why data management technologies and approaches have expanded beyond relational databases and data warehousing., analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Overview and Big Data & Technologies Exploring why data management technologies and approaches have expanded beyond relational databases and data warehousing.”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）
OverviewandBigData&TechnologiesExploringwhydatamanagement
💡 学习提示
• 总结 Overview and Big Data & Technologies Exploring why data management technologies and approaches have expanded beyond rela 的核心概念与适用场景
• 为第13周生成 5 道练习题并给出解题步骤
