SQL-game_store_database:这个项目说明了我如何使用SQL进行数据库设计

  • r3_534228
    了解作者
  • 2.5MB
    文件大小
  • zip
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-04-09 09:38
    上传日期
数据库_项目 这个项目说明了我如何使用SQL进行数据库设计。 背景 自成立以来,主机游戏零售商ABC Game Store展现了快速的增长。 随着业务的增长,商店面临着与客户满意度低下有关的许多挑战。 客户抱怨店内客户服务,但是,该业务所拥有的当前数据无法生成任何有意义的见解,也无法加载任何与解决问题相关的数据。 为了解决该问题,业务需要由客户,交易,产品,产品显示,员工,员工计划和员工评级数据生成的信息。 借助新的数据库系统,ABC游戏商店能够产生有意义的报告。 通过提议的数据库,企业可以基于客户信息生成月度销售报告,有关员工的客户服务评估的月度报告以及高峰时段和当前状况的报告。 这些报告可以帮助建立积极的客户店内体验。 据DBLC称,业务数据库处于第四阶段,即测试和评估。 该项目已完成初步研究,设计,实施和加载阶段,并且需要在测试和评估,操作以及维护和演进阶段采取进一步的措施。 数据
SQL-game_store_database-main.zip
  • SQL-game_store_database-main
  • BA 574-400 Group 2.accdb
    1.1MB
  • README.md
    1.8KB
  • ABC game store database project.pdf
    850.5KB
  • BA 574-400 Final Report Group 2_Final.docx
    1.7MB
内容介绍
![Capture](https://user-images.githubusercontent.com/79428102/115105831-360f4780-9f16-11eb-8673-f0d6ecaae4d5.JPG) # Database_Project This a project that explains how I used SQL for a database design. ## Background ABC Game Store, a console games retailer, has shown a rapid growth since its start of business. As it grew, the store faced a number of challenges related to low customer satisfaction. Customers were complaining about in-store customer service, however, the current data held by the business could not generate any meaningful insights and also could not load any data related to solve the problem. To solve the problem, the business needed information generated by customers, transactions, products, product display, employee, employee schedule and employee rating data. With the new database system, the ABC game store was able to yield meaningful reports. Through the proposed database, the business can generate monthly sales reports based on customer information, monthly reports on employees’ customer service assessment, and report on peak hours and the current situation. These reports can facilitate the building of a positive customer in-store experience. According to DBLC, the database for the business is in the fourth phase, testing and evaluation. The project has finished initial study, design, and implementation and loading phase and needs to take further actions in testing and evaluation, operation, and maintenance and evolution phase. The database needs to iteratively make improvements to address problems occurring. Iteration of the updating the database will eliminate the bottlenecks of ABC game store business and potentially impact on creating additional economic values and securing customer loyalty. ## Build with - MS Access SQL ## License © hej6853
评论
    相关推荐