学位论文 > 优秀研究生学位论文题录展示

Development of Supermarket Management Information System

作　者: Elizabeth Sylvester Mkoba
导　师: Jiang Waiwen；Wang Jiayang
学　校: 中南大学
专　业: Computer Science and Technology
关键词: ActiveX Data Objects (ADO) Relational Database Management System (RDBMS) Client/Serve Real Application Cluster(RAC) SQL - Structured Query Language
分类号: TP311.52
类　型: 硕士论文
年　份: 2003年
下　载: 213次
引　用: 0次
阅　读: 论文下载

内容摘要

Supermarket is a Business organization that provides customers with all of the products and services they need on their shopping.’Customer Satisfaction without Compromise "has been the slogan right from the Supermarket ’s inception. Committed to Excellence in all spheres of activities is the primary goal of the Supermarket.The functionality of the Supermarket is, Supermarket purchase products from various Suppliers, products are displayed in the shelves categorized by the product category, and the customers buy goods from the Supermarket. When a customer purchases an items, transaction process is carried out such that the current inventory count is decreased. At the end of the business hours. Daily sale report is generated and submitted to the Management.Every business today faces two challenges: Increasing efficiencies and reducing costs. As industries continue to face tougher global competition, the demand for top quality products, superior customer services and guaranteed low prices grows more acute. Competing successfully in today’s market place access to a powerful software application that can support the enterprise is vital for managing these challenges successfully and keeping a competitive edge.The main objective of this project is to develop a Supermarket Management Information system which equips an enterprise with the necessary capabilities to integrate and synchronize the isolated functions into streamlined business process, in order to give a competitive edge to the firm in a turbulent business environment. The module identified are Purchasing, Sales, Accounts and Personnel module. Client /Server architecture is implemented for the daily business transactions and in Managerial level activities.The design makes use of Crystal Report Seagate Package 4.6 to integrate with Visual Basic 6.0 Enterprise Software and Microsoft SQL Server 7.0 for generating various reports and queries needed in the Supermarket for business analysis. Furthermore the Crystal reports technique has been implemented in printing a sales Receipt to customer after sale.Graphics User Interface (GUI) has been implemented as a user friendly for data capturing and manipulation. The GUI technique is designed by using Visual Basic 6.0 Enterprise Edition, which uses ActiveX Data Object (ADO) model to write and read the data in the Microsoft SQLServer 7.0.For Security purpose, the design has login restrictions , when the system operator has logged in the Login Status changed to "1" . Login using the same USERID and PASSWORD when the Login status is "I" is not accepted. The login status is changed to "0" when the system operator logs out from the system.

全文目录

Declaration  3-4
Abstract  4-7
List of Figures  7-8
Abbreviations and Terms  8-9
Chapter 1 Supermarier Organization Structure and Functions  9-15
  1.1 Introduction  9
  1.2 Objectives of the Supermarket  9
  1.3 Organization structure  9-15
Chapter 2 Information Technology and Business  15-19
  2.1 Evolution of lnformation Systems  15
  2.2 Information Technology and Business  15-16
  2.3 Survey of the Supermarket  16-17
  2.4 Problem Definition  17-19
Chapter 3 System Analysis  19-26
  3.1 Feasibility study  19-20
  3.2 System Requirements Specification (SRS)  20-26
    3.2.1 Functional Requirements  21-23
    3.2.2 Standard and Conventions  23-24
    3.2.3 Software Quality requirements  24-26
Chapter 4 System Design  26-47
  4.1 Objectives  26
  4.2 Logical Data Modeling (Conceptual Design)  26-36
    4.2.1 Entity Relationship Model  26-29
    4.2.2 Record Based Data Model  29-30
    4.2.3 Output Design  30-31
    4.2.4 Input Design and Data Manipulation Algorithms  31-36
  4.3 Physical Design  36-42
    4.3.1 File Design  36-37
    4.3.2 Database Design  37-40
    4.3.3 Software Design  40-41
    4.3.4 Program Coding  41-42
  4.4 System Concept  42-47
    4.4.1 Systern Structure  42
    4.4.2 System Architecture  42-47
Chapter 5 System Testing  47-49
  5.1 Testing Phase  47-49
Chapter 6 System Implementation and Testing  49-61
  6.1 Plan of Implementation  49-52
    6.1.1 Space Planning  50
    6.1.2 Preparation of Imple(?)ation Documents  50
    6.1.3 Hardware and Software Selection  50-51
    6.1.4 User Training  51-52
    6.1.5 Creation of Forms and Database  52
    6.1.6 Testing  52
  6.2 System Security  52-60
  6.3 Change over  60-61
  6.4 Post-Implementation Review  61
7 Suggestions and conclusion  61-66
  7.1 Goal Achieved   61
  7.2 Security Enhancement   61-63
  7.3 Systen Maintenance  63
  7.4 Performance Tuning Of the Database  63-64
  7.5 Real Application  64-66
Appendix 1. Entity Relationship Diagram  66-67
Appendix 2. Tables in 3NF  67-68
Appendix 3. Data Dictionary  68-72
Appendix 4. DFD of Supermarket information System  72-73
Appendix 5. LAN Layout  73-74
Appendix 6. Reports  74-76
Acknowledgements  76-77
References  77-80
Source Program codes#a  80-143

相似论文

Developing an E-Marketing Website for Yasekon Cotton Lint Company in Tanzania,TP399
基于WinCE平台的故障分析仪应用程序设计与开发,TP311.52
面向SMDA的服务建模方法及工具实现,TP311.52
异构环境下企业互操作技术及在物资供应链系统中的应用,TP311.52
基于特征的软构件建模方法及其在VMI管理系统中的应用,TP311.52
电力负荷管理终端测试装置软件系统研制,TP311.52
基于NS2的PeerCast模拟平台设计与实现,TP311.52
中小企业进销存管理系统的研究与设计,TP311.52
支持产品物料追踪溯源的物流管理系统,TP311.52
AUTOSAR系统建模方法的研究与实现,TP311.52
高端容错计算系统高可靠监控子系统的研究和设计,TP311.52
武器装备信息管理系统的设计与实现,TP311.52
医疗信息集成平台中HL7消息解析和存储的设计与实现,TP311.52
基于WADO的医学影像远程访问与共享系统的设计与实现,TP311.52
教学档案管理系统的设计与实现,TP311.52
部队在线考试系统设计与实现,TP311.52
基层部队人员日常管理信息系统设计实现,TP311.52
军队物资采购供应管理系统的设计与实现,TP311.52
部队人员网上训练与考核系统的开发,TP311.52
部队兵员管理系统的设计与实现,TP311.52
军队后勤物资管理系统设计与实现,TP311.52