[餐饮服务系统数据库的实现.docVIP

餐饮服务系统 ----数据库的实现 【摘要】在餐饮服务系统开发过程中，开发过程主要包括系统设计、前端应用程序的开发、后台的数据库设计。其中后台数据库设计中的关系数据库是相当重要的一块，它决定了我们整个系统的开发成败。从平台方面来说，我们采用了Microsoft公司的visual basic.net作为开发工具，而数据库则是采用Microsoft SQL Server 2000作为开发环境。数据库的实现是系统设计时的重中之重，如果一个好的系统没有一个好的数据库就形同虚设，系统中采用了最新的数据访问技术ADO.net来实现对数据库的访问和实现系统的所有功能,虽然有效的解决了实际问题,简化了用户的操作，基本上满足了用户的需求，且具有良好的可扩充性。但由于该系统的出发点局限于单机版，而且没有提供相应的Wed支持，所以给整个系统带来了一定的限制。　　　　　　　　　 关键词：数据库的实现；E—R图；关系图；数据表；需求分析 Abstract：In the dining service system, its main development process includes the database design of the development, backstage that the system design, head applies the procedure.Because the datas all keep in the database of, and the access that it passes to limit to authorize not, forbid the illegal interview and modify etc. operation with the accuracy and safeties of the assurance system, so say that the backstage database design is the whole system development process in very important one wreath, it comes to a decision the development success or failure of our whole system.This text mainly carries on something to elaborate from some basic designs of the database.For example database in stipulation of integrity of design, E- R diagram, the relation diagram, the data form of the data form etc. a few aspect, these are all the foundation knowledge that the database carries out the mile.In view of the terrace aspect, the system is the visual basic.net conduct and actions development tool that adopted the company of Microsoft, but the database then adopts 2000 conduct and actions development environments of the Microsoft SQL Server.This system uses the latest data interview technique ADO.net to carry out the interview to the database and carry out all functions of the system, although resolved the actual problem effectively, simplifying the operation of the customer, satisfying the need of the customer basically, have good can enlarge sex.But limit at the single machine version because of the point of departure of that system, and did not provi