网上手机销售系统的数据库设计与实现
时间:2019-03-31 21:01 来源:毕业论文 作者:毕业论文 点击:次
| 摘要：本次课题的主要目的是设计更理想的数据库，以此来提高前台的设计效率和网站的运行效率，使网站更安全、更快捷，并激起用户强烈的购买欲望，满足人们的购买需求，方便客户的购物，同时为商家创造利润。34158 在这个数据库的设计过程中，由于之前我已经做过了需求分析，在考虑了一些实际情况和需求之后，我建立了一些基本表，主要包括客户表、员工表、商品表、订单表、订单明细表、快递公司表等，并且按照需求设计了它们的表结构，然后分别为它们设置了主键关系，同时在表与表之间做了外键约束，目的就是为了减少表之间数据的冗余度，实现表与表之间进行数据共享，从而保持数据的独立性，能够更好地实现数据的集中控制。在做完这些之后，最基础的查询、删除、增加、修改、更新等数据库的基本功能都已经实现，但是为了更快捷地实现这些功能，我又设计了一些最基本但是必要的存储过程等。 综上所述，本次设计实现了数据库最基本的查、删、增、改功能，主要解决了存储过程这个大难题。 毕业论文关键词： 数据库设计；手机销售；网站；SQL Server；表结构 Database design and implementation of online mobile phone sales system Abstract: The main purpose of this topic is design a more ideal database, in order to improve operation efficiency of front end design efficiency and site, make the site a safer, more efficient, and arouse the user strong desire to buy, satisfy people's demand for the purchase of convenience of customers shopping, also for businesses to create profits. In the database design process, because before I have done after needs analysis, after considering some realistic situation and needs, I set up the basic table, including customer, employee table, commodity table, table of orders, order list, courier companies table, and according to the demand of design and their surface structure, then they set the primary key, and in between tables do the foreign key constraint, the purpose is to in order to reduce the table between the data redundancy, between the table with the table to achieve data sharing, so as to keep the data independence, to better achieve the data centralized control. After this is done, the most basic query, delete, add, modify, update database basic functions have been achieved, but in order to achieve these functions more quickly, I have designed the some of the most basic but necessary to stored procedures. In summary, the design and implementation of the database the most basic search, delete, add, change, the main solution to the storage process of this big problem. Keywords: Database design; Mobile phone sales; Web site; SQL Server; Table structure 目录 摘要 i Abstract i 目录 6 1 绪论 1 1.1 课题的研究背景 1 1.2 国内外研究现状与存在的问题 2 1.3 论文结构 4 1.4 技术简介 4 1.5 设计和实现上的限制 5 2 数据库需求 6 2.1 需求分析 6 2.1.1 功能需求 6 2.1.2 非功能需求 8 2.2 可行性分析 9 2.3 数据库结构化分析 10 2.4 目标系统要求 13 2.5 假设和约束 13 3 详细设计 14 3.1 数据库设计思想 14 3.2 数据库详细设计 14 3.2.1 数据库概念模型设计 14 (责任编辑：qin) |