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 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 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只关注语法对错，不验证查询是否准确回答业务问题。 （数据来源：2000 UQ Course Profile (BISM2207)）
CourseOverviewandIntrotoDBMSIntroductiontodatabasemanagement
💡 学习提示
• 总结 Course Overview and Intro to DBMS Introduction to database management, including traditional file-based systems, the dat 的核心概念与适用场景
• 为第1周生成 5 道练习题并给出解题步骤
Week 2Entity-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 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只报告结果，不解释特征选择、评估指标和误差来源。 （数据来源：2000 UQ Course Profile (BISM2207)）
Entity-RelationshipModelEntityrelationshipmodellingisexploredintermsof
💡 学习提示
• 总结 Entity-Relationship Model Entity relationship modelling is explored in terms of a data-driven approach using entity-rela 的核心概念与适用场景
• 为第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) 本周围绕 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 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只报告结果，不解释特征选择、评估指标和误差来源。 （数据来源：2000 UQ Course Profile (BISM2207)）
RelationalModelRelationalmodelconceptsarediscussedincludingspecificterminology
💡 学习提示
• 总结 Relational Model Relational model concepts are discussed including specific terminology, keys, views and integrity const 的核心概念与适用场景
• 为第3周生成 5 道练习题并给出解题步骤
Week 4Database 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 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只关注语法对错，不验证查询是否准确回答业务问题。 （数据来源：2000 UQ Course Profile (BISM2207)）
DatabaseDesignandStructuredQueryLanguageIIntroductiontofundamental
💡 学习提示
• 总结 Database Design and Structured Query Language (I) Introduction to fundamental SQL Data Definition Language (DDL) and Dat 的核心概念与适用场景
• 为第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) 本周围绕 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 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只关注语法对错，不验证查询是否准确回答业务问题。 （数据来源：2000 UQ Course Profile (BISM2207)）
StructuredQueryLanguageIIExploringaggregationandgroupingandrelational
💡 学习提示
• 总结 Structured Query Language (II) Exploring aggregation and grouping, and relational operations to enable search conditions 的核心概念与适用场景
• 为第5周生成 5 道练习题并给出解题步骤
Week 6In-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 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只记知识点标题，忽略前后周之间的方法衔接和应用边界。 （数据来源：2000 UQ Course Profile (BISM2207)）
In-SemesterQuizInSemesterexamduringLectureTime.
💡 学习提示
• 总结 In-Semester Quiz In Semester exam during Lecture Time. 的核心概念与适用场景
• 为第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) 本周围绕 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 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只关注语法对错，不验证查询是否准确回答业务问题。 （数据来源：2000 UQ Course Profile (BISM2207)）
NormalisationExplorehownormalisationsupportsdatabasedesignandhowconcepts
💡 学习提示
• 总结 Normalisation Explore how normalisation supports database design and how concepts such as partial, transitive, and funct 的核心概念与适用场景
• 为第7周生成 5 道练习题并给出解题步骤
Week 8Data 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 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只记知识点标题，忽略前后周之间的方法衔接和应用边界。 （数据来源：2000 UQ Course Profile (BISM2207)）
DataQualityandCleaningandPresentationSkillsDataisa
💡 学习提示
• 总结 Data Quality and Cleaning, and Presentation Skills Data is a valuable resource and access to accurate, current and infor 的核心概念与适用场景
• 为第8周生成 5 道练习题并给出解题步骤
Week 9Guest 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 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只记知识点标题，忽略前后周之间的方法衔接和应用边界。 （数据来源：2000 UQ Course Profile (BISM2207)）
GuestLectureTBA
💡 学习提示
• 总结 Guest Lecture TBA 的核心概念与适用场景
• 为第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) 本周围绕 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 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只画高层架构，不说明组件职责、故障路径与取舍依据。 （数据来源：2000 UQ Course Profile (BISM2207)）
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) 本周围绕 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 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只关注语法对错，不验证查询是否准确回答业务问题。 （数据来源：2000 UQ Course Profile (BISM2207)）
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) 本周围绕 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 页方法清单。 📌 **作业关联**: 与当周作业/项目里对应模块直接相关，建议本周完成第一版并留出测试时间。 ⚠️ **易错点**: 只关注语法对错，不验证查询是否准确回答业务问题。 （数据来源：2000 UQ Course Profile (BISM2207)）
DistributedDatabaseManagementSystemsWeexaminedistributedDBMSsincludingconcepts
💡 学习提示
• 总结 Distributed Database Management Systems We examine distributed DBMSs including concepts, problems, technologies and prot 的核心概念与适用场景
• 为第12周生成 5 道练习题并给出解题步骤
