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.

• Periodical: Applied Mechanics and Materials (Volumes 543-547)
• Pages: 4593-4596
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.543-547.4593
• Online since: March 2014
• Authors: Xin Xin Lv*
• Keywords: Database Design, Music Equipment, Requirement Analysis, Warehouse Management System

References

[1] X. H. Yi, Design and implementation of music equipment management system, " Doctor, s degree of Shandong University, (2011).

[2] K. X. Zhang, Research local colleges and universities of applied music professional training model, Journal of Foshan University(Social Science Edition), vol. 30, no. 7, pp.20-24, (2012).

[3] Baidu Encyclopedia, Conceptual structure design, http: /baike. baidu. com/view/1638403. htm, 2013-11-25.

[4] H. M. Chen, Logical structure design of the database, " Fujian computer, vol. 28, no. 10, pp.214-215, (2012).

[5] Ken England, Gavin Powell, Logical Database Design for Performance, Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook, (2007).

DOI: 10.1016/b978-155558319-4/50003-5

[6] General Office of the CPC Central Committee, The CPC Central Committee and the State Council on deepening education reform and promoting quality education decision, 1999-6-13.

[7] Ministry of Education of the People's Republic of China (MOE), The National School Art Education Development Planning(2001-2010), 2002-5-13.

[8] Ministry of Education of the People's Republic of China (MOE), National College of Public Art courses mentoring program, 2006-3-8.