Database Design on Experimental Equipment Accounting Treatment System based on Oracle

摘要

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.