Database Design on Warehouse Information System of College Music Equipment

Abstract

With the national efforts to increase investment for quality education and an increase in the number of college enrollment music class students, so the college needs more music equipments. The college always faces challenge of the comprehensive information management for music equipments. This paper bases on requirement analysis for warehouse management of music equipment to conduct database design. Requirement analysis uses UML to conduct use case modeling and describes management process; database design conducted conceptual design and logical design; conceptual design represents by E-R; logic design bases on convert rule to design and represents by ten table structure. Content of this paper is the basic work of software development and provides support for the development of warehouse management system of music equipment, will play an active role in promoting the construction of college music equipment management information.