商业数据管理

默认只展示每周独有的知识重点；节奏、考核、Tutorial 和避坑信息按需展开。

1. 1

   Course 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 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) 的核心概念与应用场景展开，建议先把 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), data modelling, SQL/Python, system design ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 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)”完成课堂练习，并整理 1 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只关注语法对错，不验证查询是否准确回答业务问题。

   CourseOverviewandIntrotoDBMSIntroductiondatabasemanagement
2. 2

   Entity-Relationship Model Entity relationship modelling is explored in terms of a data-driven approach using entity-rela

   ### 📖 核心知识点：Entity-Relationship Model 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) 本周围绕 Entity-Relationship Model 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) 的核心概念与应用场景展开，建议先把 lecture 中给出的定义、边界和示例理解透，再通过 tutorial/workshop 把知识点转化成可执行步骤。学习重点不是记住术语，而是能在案例里解释为什么使用这个方法、何时不该使用，以及与前后主题的连接关系。 - **核心概念/公式**: Entity-Relationship Model 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), data modelling, SQL/Python, system design ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见题型是概念辨析 + 场景应用，建议用“定义-步骤-取舍”结构答题。 🧪 **Tutorial/Lab**: 围绕“Entity-Relationship Model 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)”完成课堂练习，并整理 1 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只报告结果，不解释特征选择、评估指标和误差来源。

   Entity-RelationshipModelEntityrelationshipmodellingisexploredintermsof
3. 3

   Relational 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) 本周围绕 Relational Model Relational model concepts are discussed including specific terminology, keys, views and integrity constraints. Readings/Ref: CB (Ch. 4) 的核心概念与应用场景展开，建议先把 lecture 中给出的定义、边界和示例理解透，再通过 tutorial/workshop 把知识点转化成可执行步骤。学习重点不是记住术语，而是能在案例里解释为什么使用这个方法、何时不该使用，以及与前后主题的连接关系。 - **核心概念/公式**: Relational Model Relational model concepts are discussed including specific terminology, keys, views and integrity constraints. Readings/Ref: CB (Ch. 4), data modelling, SQL/Python, system design ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 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)”完成课堂练习，并整理 1 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只报告结果，不解释特征选择、评估指标和误差来源。

   RelationalModelmodelconceptsarediscussedincludingspecificterminology
4. 4

   Database Design and Structured Query Language (I) Introduction to fundamental SQL Data Definition Language (DDL) and Dat

   ### 📖 核心知识点：Database Design and Structured Query Language (I) Introduction to fundamental SQL Data Definition Language (DDL) and Data Manipulation Language (DML) statements. Readings/References: CB, Chapters 6 and 7 本周围绕 Database Design and Structured Query Language (I) Introduction to fundamental SQL Data Definition Language (DDL) and Data Manipulation Language (DML) statements. Readings/References: CB, Chapters 6 and 7 的核心概念与应用场景展开，建议先把 lecture 中给出的定义、边界和示例理解透，再通过 tutorial/workshop 把知识点转化成可执行步骤。学习重点不是记住术语，而是能在案例里解释为什么使用这个方法、何时不该使用，以及与前后主题的连接关系。 - **核心概念/公式**: Database Design and Structured Query Language (I) Introduction to fundamental SQL Data Definition Language (DDL) and Data Manipulation Language (DML) statements. Readings/References: CB, Chapters 6 and 7, data modelling, SQL/Python, system design ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见题型是概念辨析 + 场景应用，建议用“定义-步骤-取舍”结构答题。 🧪 **Tutorial/Lab**: 围绕“Database Design and Structured Query Language (I) Introduction to fundamental SQL Data Definition Language (DDL) and Data Manipulation Language (DML) statements. Readings/References: CB, Chapters 6 and 7”完成课堂练习，并整理 1 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只关注语法对错，不验证查询是否准确回答业务问题。

   DatabaseDesignandStructuredQueryLanguageIIntroductiontofundamental
5. 5

   Structured 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) 本周围绕 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) 的核心概念与应用场景展开，建议先把 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), data modelling, SQL/Python, system design ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 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)”完成课堂练习，并整理 1 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只关注语法对错，不验证查询是否准确回答业务问题。

   StructuredQueryLanguageIIExploringaggregationandgroupingrelational
6. 6

   In-Semester Quiz In Semester exam during Lecture Time.

   ### 📖 核心知识点：In-Semester Quiz In Semester exam during Lecture Time. 本周围绕 In-Semester Quiz In Semester exam during Lecture Time. 的核心概念与应用场景展开，建议先把 lecture 中给出的定义、边界和示例理解透，再通过 tutorial/workshop 把知识点转化成可执行步骤。学习重点不是记住术语，而是能在案例里解释为什么使用这个方法、何时不该使用，以及与前后主题的连接关系。 - **核心概念/公式**: In-Semester Quiz In Semester exam during Lecture Time., data modelling, SQL/Python, system design ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见题型是概念辨析 + 场景应用，建议用“定义-步骤-取舍”结构答题。 🧪 **Tutorial/Lab**: 围绕“In-Semester Quiz In Semester exam during Lecture Time.”完成课堂练习，并整理 1 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只记知识点标题，忽略前后周之间的方法衔接和应用边界。

   In-SemesterQuizInSemesterexamduringLectureTime.
7. 7

   Normalisation 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) 本周围绕 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) 的核心概念与应用场景展开，建议先把 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), data modelling, SQL/Python, system design ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 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)”完成课堂练习，并整理 1 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只关注语法对错，不验证查询是否准确回答业务问题。

   NormalisationExplorehownormalisationsupportsdatabasedesignandconcepts
8. 8

   Data Quality and Cleaning, and Presentation Skills Data is a valuable resource and access to accurate, current and infor

   ### 📖 核心知识点：Data Quality and Cleaning, and Presentation Skills 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. 本周围绕 Data Quality and Cleaning, and Presentation Skills 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. 的核心概念与应用场景展开，建议先把 lecture 中给出的定义、边界和示例理解透，再通过 tutorial/workshop 把知识点转化成可执行步骤。学习重点不是记住术语，而是能在案例里解释为什么使用这个方法、何时不该使用，以及与前后主题的连接关系。 - **核心概念/公式**: Data Quality and Cleaning, and Presentation Skills 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., data modelling, SQL/Python, system design ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见题型是概念辨析 + 场景应用，建议用“定义-步骤-取舍”结构答题。 🧪 **Tutorial/Lab**: 围绕“Data Quality and Cleaning, and Presentation Skills 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.”完成课堂练习，并整理 1 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只记知识点标题，忽略前后周之间的方法衔接和应用边界。

   DataQualityandCleaningPresentationSkillsisa
9. 9

   Guest Lecture TBA

   ### 📖 核心知识点：Guest Lecture TBA 本周围绕 Guest Lecture TBA 的核心概念与应用场景展开，建议先把 lecture 中给出的定义、边界和示例理解透，再通过 tutorial/workshop 把知识点转化成可执行步骤。学习重点不是记住术语，而是能在案例里解释为什么使用这个方法、何时不该使用，以及与前后主题的连接关系。 - **核心概念/公式**: Guest Lecture TBA, data modelling, SQL/Python, system design ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见题型是概念辨析 + 场景应用，建议用“定义-步骤-取舍”结构答题。 🧪 **Tutorial/Lab**: 围绕“Guest Lecture TBA”完成课堂练习，并整理 1 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只记知识点标题，忽略前后周之间的方法衔接和应用边界。

   GuestLectureTBA
10. 10

    Transaction 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) 本周围绕 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) 的核心概念与应用场景展开，建议先把 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), data modelling, SQL/Python, system design ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 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)”完成课堂练习，并整理 1 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只画高层架构，不说明组件职责、故障路径与取舍依据。

    TransactionManagementThislectureexploresthecriticalroleoftransaction
11. 11

    Database 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) 本周围绕 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) 的核心概念与应用场景展开，建议先把 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), data modelling, SQL/Python, system design ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 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)”完成课堂练习，并整理 1 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只关注语法对错，不验证查询是否准确回答业务问题。

    DatabaseSecurityandControlWe’lllookatwhydatabasesecurity
12. 12

    Distributed 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) 本周围绕 Distributed Database Management Systems We examine distributed DBMSs including concepts, problems, technologies and protocols. Readings/Ref: CB (Ch. 24, 25) 的核心概念与应用场景展开，建议先把 lecture 中给出的定义、边界和示例理解透，再通过 tutorial/workshop 把知识点转化成可执行步骤。学习重点不是记住术语，而是能在案例里解释为什么使用这个方法、何时不该使用，以及与前后主题的连接关系。 - **核心概念/公式**: Distributed Database Management Systems We examine distributed DBMSs including concepts, problems, technologies and protocols. Readings/Ref: CB (Ch. 24, 25), data modelling, SQL/Python, system design ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 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)”完成课堂练习，并整理 1 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只关注语法对错，不验证查询是否准确回答业务问题。

    DistributedDatabaseManagementSystemsWeexaminedistributedDBMSsincludingconcepts