Database Management
数据库管理课程系统讲授关系数据库的原理、设计与运维技术。主要内容包括关系模型与范式理论、ER建模、SQL查询语言(DDL/DML/DCL)、存储过程与触发器、索引与查询优化、事务管理与并发控制、数据库安全与备份恢复。课程结合MySQL、SQL Server等主流平台进行实战训练,培养学生独立设计、实施和管理企业级数据库系统的能力。
Database Management covers the principles, design, and administration of relational databases. Topics include the relational model and normalization, ER modeling, SQL (DDL/DML/DCL), stored procedures and triggers, indexing and query optimization, transaction management and concurrency control, and database security and backup recovery. Hands-on practice uses MySQL and SQL Server, building skills to design and manage enterprise databases.
学生小组选定一个业务场景(如图书馆、医院、电商),完成需求分析、ER图设计、关系模式转换与规范化,并在MySQL上实现数据库,编写存储过程、视图与触发器。需插入测试数据并演示典型业务查询,最终提交设计文档、SQL脚本与演示报告,并进行答辩。
Teams choose a business scenario (such as a library, hospital, or e-commerce site) and complete requirements analysis, ER diagram design, schema conversion and normalization, then implement the database in MySQL with stored procedures, views, and triggers. Deliverables include design documents, SQL scripts, and a demo report with test data, followed by a defense.