Based on the research of former database design,this paper gives an integrity and optimized design:combining and optimizing the database and tables,improving the design solution of field,offering the process method of the paper.Proved by practice,the optimized design,not only optimized the data storage structure,but also increased the speed of database access.To a certain extent,the method is easy to program,thus greatly improving the efficiency and performance of the whole system.