项目库存管理系统 inventrymanagementprject.doc

Skills Required: Any Front End Tool and SQL Server Project Case Title: Inventory Management System for Drug Store 技能需求：任何前端工具与SQL Server 项目案例标题：药店库存管理系统 Learning Objective: Database Modeling Relational Mapping for Database Design User Interface designing Modular approach Separation of Data Logic and the Presentation Logic Implementation of the Business process and the Logic Development of problem solving approach, problem analysis and using programming logic to build up solutions Inter linkage of application modules Report Generation Project Designing, Development, Testing, Deployment, Demonstration Project Documentation and Project Development approach 学习目标： 数据库建模 数据库设计的关系映射 用户界面设计 模块方法 数据逻辑和显示逻辑的分离 业务流程和逻辑的执行 开发问题解决方法，问题分析，使用编程逻辑建立解决方案 应用模块之间的关联 生成报告 项目设计，开发，测试，部署，演示 项目文档和项目开发方式 Synopsis: Global Drug, a global chain of drug store needs to manage inventory system for their store selling different type of medicines such as Western Medicines, Traditional Medicines, and Medical accessories. The store operates on a larger scale and work in two shift that is day shift and the night shift. Each shift has a team of 5 salesperson, 1 counter cashier and a shift store manager and a team of 5 Delivery boys. Also, the store supports different range of customers for providing special discount schemes such as VIP customer and Regular customer. The store also launches discount scheme for their customers based on their daily, weekly, monthly sales. But, the schemes are only available to registered customers. 大纲： Global Drug 是一家全球药店连锁，现在针对销售不同类型药品(如西药，中药，医保材料)的店面进行库存管理，该店的运行规模很大，员工也分为早班和晚班。每班都由包括5个销售人员，1个收银员，一个值班经理，以及一个5人的送货团队组成。此外，该店将客户分为不同级别，如VIP客户和普通客户，实行不同的折扣计划。折扣计划只面向注册了的客户。 Customer Management: 客户管理 Customers can register to avail discount scheme and be given unique customer ID Customer can visit store and report any Updates in their profile such as personal details, address, contact details Registered customers can also place order on phone and avail facility of