Database Design of Merchandise Management System Based on SQL Server

Abstract:

Merchandise management is an important part of enterprise management, information management system is an important means to achieve the modernization of management of goods. View of the current the existing in the construction which the merchandise management information system of problem, the database design, in this paper research SQL Server database management system under the support of in accordance with the database design flow carried out conceptual structure design, logical structure design and physical structure design. Conceptual structure design in part through the E-R model performance; Logical structure design part of the structural design of the choice of data types and relationships; Physical structure of the design portion of the disk hardware selection and index design. The content of this study, for the development merchandise management system to provide practical solutions for enterprises to strengthen merchandise management, improve the level of information is of great significance.

• Periodical: Applied Mechanics and Materials (Volumes 380-384)
• Pages: 4728-4731
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.380-384.4728
• Online since: August 2013
• Authors: Fan Jin Zeng, Hui Li, Li Ding
• Keywords: Conceptual Structure Design, Database Design, Logical Structure Design, Merchandise Management System, Physical Structure Design, SQL Server

References

[1] Y. L. Yu, CS-based Merchandise Management Systems Architecture and Implementation of Research, " Master, s degree of Ocean University of China, (2011).

[2] Baidu Encyclopedia, E-R Diagram, http: /baike. baidu. com/view/15236. htm, 2013-4-9.

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

[4] Robin Dewson, Beginning SQL Server 2005 for Developers, Apress, (2006).

[5] S. Wang, S. X. Sa, Introduction to database system (Fourth Edition), Higher Education Press, (2006).

[6] L. J. Zheng, K. Li Database Design of Materials Classification Detailed Account, Lecture Notes in Information Technology, vol. 1, pp.104-108, (2012).

[7] J. S. Yang, C. Zhang, Impact of index on the SQL execution costs, Information & Communications, vol. 27, no. 1, pp.136-137, (2013).

[8] C. Chen Establishment and analysis on index of SQL Server, Science & Technology Information, vol. 29, no. 36, pp.288-289, (2012).

[9] K. Li, Column stores the index technology of SQL Server 2012, Computer CD Software and Applications, vol. 15, no. 19, pp.121-123, (2012).

[10] Baidu know, What are the advantages of SQL Server, http: /zhidao. baidu. com/question/251450094. html , 2013-4-9.