Database Design on Experimental Equipment Accounting Treatment System based on Oracle

DOI

10.2991/msmee-17.2017.292How to use a DOI?

Keywords

experimental equipment; accounting treatment; database design; Oracle; conceptual structure; logical structure; integrity

Abstract

In order to test equipment purchase, use and inventory management in an all-round way, this paper based on needs analysis, in accordance with the standard design process research, provide technical support for system development. First of all, the conceptual structure design, using entity relationship diagram constructs the conceptual model; then, the logical structure design, with class diagram to express the logical structure based on Oracle; Finally, the design of integrity, includes entity integrity and referential integrity. In this paper, the design results are reasonable storage structure and access efficiency, according to the specific circumstances of the appropriate extension of the logical structure for the actual development, in order to adapt to the actual needs of system development.

Copyright

© 2017, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Yanmei Wang
AU  - Linchuang Zhang
PY  - 2017/05
DA  - 2017/05
TI  - Database Design on Experimental Equipment Accounting Treatment System based on Oracle
BT  - Proceedings of the 2017 2nd International Conference on Materials Science, Machinery and Energy Engineering (MSMEE 2017)
PB  - Atlantis Press
SP  - 1618
EP  - 1622
SN  - 2352-5401
UR  - https://doi.org/10.2991/msmee-17.2017.292
DO  - 10.2991/msmee-17.2017.292
ID  - Wang2017/05
ER  -