音乐器材管理账务处理系统数据库设计

Database design on accounting treatment system for music equipment management

音乐教育是我国素质教育的重要组成部分,提高学生的音乐艺术素养,必须充分发挥音乐器材的重要作用。针对音乐器材账务难以管理的现状,本文进行数据库设计,为账务处理系统开发提供支持。以需求分析为基础,进行了概念结构设计和逻辑结构设计。需求分析采用UML进行用例建模,概念结构设计采用实体联系图表示。

Music education is an important part of quality education,which can improve their music art accomplishment,so the important role of music equipment must be fully play.This paper studies database design in the light of the present situation of music equipment accounting difficult to manage to provide support for the development of accounting treatment system.Conceptual structure design and logical structure design should be carried on based on requirement analysis.Requirement analysis conducted use case modeling used UML;conceptual structure design was showed by the diagram of entity-relationship;logical structure design designed three table structures by the table form based on transformation rule.