Business Database
本课程教授关系型数据库的设计与应用，重点关注商务场景下的数据管理与查询。内容涵盖关系模型、SQL语言（DDL、DML、DQL）、数据库设计范式、ER图建模、索引与性能优化、事务与并发控制、数据仓库基础等。课程以MySQL为主要实践平台，结合电商订单系统、CRM系统、ERP系统等商业案例，培养学生设计合理数据库结构、编写高效SQL查询、从数据库中提取分析数据的能力。
This course teaches relational database design and application with a focus on data management and querying in business contexts. Topics include relational models, SQL (DDL, DML, DQL), database normalization, ER diagram modeling, indexing and performance optimization, transactions and concurrency control, and data warehousing fundamentals. Using MySQL as the primary platform with business cases like e-commerce order systems, CRM, and ERP systems, students develop skills in designing proper database structures, writing efficient SQL queries, and extracting data for analysis.
设计并实现一个电商订单管理系统的关系型数据库。完成需求分析，绘制ER图，设计符合第三范式的数据库表结构（包含用户表、商品表、订单表、支付表、物流表等），使用MySQL创建数据库并导入模拟数据。编写复杂SQL查询实现销售统计、用户消费分析、商品热销排行、订单状态追踪等业务分析功能，优化关键查询的执行性能。提交数据库设计文档和SQL脚本。
Design and implement a relational database for an e-commerce order management system. Complete requirements analysis, draw ER diagrams, and design table structures in third normal form including users, products, orders, payments, and logistics tables. Create the database in MySQL and import sample data. Write complex SQL queries for sales statistics, customer spending analysis, product rankings, and order status tracking. Optimize key query performance. Submit database design documentation and SQL scripts.