SkillsRequired:AnyFrontEndToolandSQLServerProjectCaseTitle:InventoryManagementSystemforDrugStore技能需求：任何前端工具与SQLServer项目案例标题：药店库存管理系统LearningObjective:1.DatabaseModeling2.RelationalMappingforDatabaseDesign3.UserInterfacedesigning4.Modularapproach5.SeparationofDataLogicandthePresentationLogic矚慫润厲钐瘗睞枥庑赖。6.ImplementationoftheBusinessprocessandtheLogic聞創沟燴鐺險爱氇谴净。7.Developmentofproblemsolvingapproach,problemanalysisandusingprogramminglogictobuildupsolutions残骛楼諍锩瀨濟溆塹籟。8.Interlinkageofapplicationmodules9.ReportGeneration10.ProjectDesigning,Development,Testing,Deployment,Demonstration酽锕极額閉镇桧猪訣锥。11.ProjectDocumentationandProjectDevelopmentapproach彈贸摄尔霁毙攬砖卤庑。学习目标：1.数据库建模2.数据库设计的关系映射3.用户界面设计4.模块方法5.数据逻辑和显示逻辑的分离6.业务流程和逻辑的执行7.开发问题解决方法，问题分析，使用编程逻辑建立解决方案8.应用模块之间的关联9.生成报告10.项目设计，开发，测试，部署，演示11.项目文档和项目开发方式Synopsis:GlobalDrug,aglobalchainofdrugstoreneedstomanageinventorysystemfortheirstoresellingdifferenttypeofmedicinessuchasWesternMedicines,TraditionalMedicines,andMedicalaccessories.Thestoreoperatesonalargerscaleandworkintwoshiftthatisdayshiftandthenightshift.Eachshifthasateamof5salesperson,1countercashierandashiftstoremanagerandateamof5Deliveryboys.Also,thestoresupportsdifferentrangeofcustomersforprovidingspecialdiscountschemessuchasVIPcustomerandRegularcustomer.Thestorealsolaunchesdiscountschemefortheircustomersbasedontheirdaily,weekly,monthlysales.But,theschemesareonlyavailabletoregisteredcustomers.謀荞抟箧飆鐸怼类蒋薔。大纲：GlobalDrug是一家全球药店连锁，现在针对销售不同类型药品(如西药，中药，医保材料)的店面进行库存管理，该店的运行规模很大，员工也分为早班和晚班。每班都由包括5个销售人员，1个收银员，一个值班经理，以及一个5人的送货团队组成。此外，该店将客户分为不同级别，如VIP客户和普通客户，实行不同的折扣计划。折扣计划只面向注册了的客户。厦礴恳蹒骈時盡继價骚。1.CustomerManagement:客户管理CustomerscanregistertoavaildiscountschemeandbegivenuniquecustomerID茕桢广鳓鯡选块网羈泪。CustomercanvisitstoreandreportanyUpdatesintheirprofilesuchaspersonaldetails,address,contactdetails鹅娅尽損鹌惨歷茏鴛賴。RegisteredcustomerscanalsoplaceorderonphoneandavailfacilityofCashonDeliverypayment籟丛妈羥为贍偾蛏练淨。客户可以注册，然后使用自己的折扣计划，每个客户会分配一个唯一的客户ID客户可以参观店面，可以更新自己的个人信息，包括地址，联系方式等注册的客户还可以通过电话下订单，并且可以使用到货付款2.StoreManager店长Createuseridforthecashiercounterfortheirrespectiveshift預頌圣鉉儐歲龈讶骅籴。CreateandstoreSalespersondatainthedatabasesuchasSalespersonIDandtherelevantdetailssuchasID,Name,DateofJoining,dateofbirthetc.Amanagercannothavemorethan5salespersonintheteamatatime,1countercashier渗釤呛俨匀谔鱉调硯錦。UpdateprofilesuchaspersonaldetailsUpdatepasswordChecktotalinventoryGeneratereportssuchas:Salesreportpersalespersonwise,totaldailysales,salesperweek,Itemwisedailysales,Salespersonwithmaximumsalesrecordondailybasis,weeklyandmonthlybasis,DailyAveragesales铙誅卧泻噦圣骋贶頂廡。CheckInventorybasedoneachitemBeabletosendSalerequisitiontotheprocurementdepartmentforitemsthatreachestheirReorderlevel擁締凤袜备訊顎轮烂蔷。CheckthestatusoftheirrequisitionstatusUpdatethepriceofitems,discounttobeofferedonthetotalsalesetc贓熱俣阃歲...
VIP
