Supermarket application task notebook presentation

1
Supermarket application-task notebook
presentation-

• By
• Danila Alexandru
• Ciupagea Flavius
• Neag Ciprian
• Oltean Ionut
• Stoica-Pîrvanescu Cosmin
• Visovan Vasile

2
PROJECT PRESENTATION

• The purpose of our program is to implement a
  stock management system for a supermarket.
• The supermarket has a variety of products sitting
  on store shelves. These goods will all be
  contained in a database system (MySql). New
  shipments of goods should be entered into this
  system as they arrive. When a customer purchases
  an item, the current inventory count should be
  decreased by one. The system checks constantly
  the quantity of products in stock and
  automatically issues an order request to the
  manager when the quantity of a certain product is
  under a specified minimum quantity ( point of
  order)
• The order form will contain the default amount of
  stock to be ordered for each item, and should be
  able to be adjusted by the manager under special
  circumstances. When the manager gives his/her OK
  to the system, the system will send the order to
  the warehouse.
• The manager will also be able to add a new item
  to the database to delete an item from the
  database in the case that it may not be selling,
  or is discontinued by the manufacturer to change
  an items point of order, maximum order value.
• The cashier will automatically decrease the item
  count when a product is sold to a consumer.

3
What will be supplied to the client

• The .NET application (written in C)
• The associated libraries. (MySQL Connector/Net)
• Technical documentation.
• User manual

4
Project Organisation

• Process
• Study of the requirements and possible ways to
  implement them.
• Database design and implementation.
• User Interface design and implementation.
• Testing and debugging phase

5
Structural organisation
6
Project Management

• Objectives and priorities
• The objective is to create a working supermarket
  stock management application as simple and
  intuitive as possible for the end user.

7
Project Management

• Hypothesis, Dependencies, Constraints
• Hypothesis
• Implementing methods for an easy and secure
  management of a product stock database.
• Dependencies
• MySQL server is required for hosting the
  database.
• The MySQL Connector/Net library is required for
  connecting to MySQL from .NET. It implements the
  required ADO.NET interfaces and integrates into
  ADO.NET aware tools.
• Constraints
• MySql server must be running in order to handle
  access and queries to the database.

8
Project Management

• Risk Management
• In order to minimise the risk of problems in the
  development of the application a thorough study
  of the requirements, features implemented and
  comunication protocols used is required.
• Means of control
• There will be weekly meetings between the team
  members regarding design and implementation
  issues

9
Techniques

• Methods and tools employed
• The project will be realised on the .NET
  Framework and coded in C using Microsoft Visual
  Studio. We have chosen this because the .NET
  Framework is a key Microsoft offering, and is
  intended to be used by most new applications
  created for the Windows platform. For software
  developers, the .NET Framework is one of the most
  significant changes to the Windows platform since
  its introduction. It brings into the operating
  system features and responsibilities that
  previously had been provided individually by
  programming languages and tools from various
  sources.
• The UML design will be realized in a
  specialized software (Visual Paradigm , Rational
  Rose etc.)
• Documentation
• The tehnical documentation will be generated
  automatically in XML format from the source
  files.
• The user manual will be available in windows
  help file (.chm) format.

10
Calendar

• 14 nov task notebook presentation
• 15 nov-6 dec design and implementation
• 8 dec presentation of UML-OCL documentation
• 9 dec 22 jan testing and making final
  adjustments
• 25-26 jan project presentation
• Weekly updates on projects wiki page at
  http//web.info.uvt.ro/wiki/moin.cgi/SupermarketAp
  pProject

11
Functionalities

• The application will be divided in two, a Server
  and Client.
• The Server program will connect directly to the
  MySQL database server and pass to it queries
  based on requests from the clients and send back
  to the clients the results returned by the
  database server.
• The Client program connects to server client and
  allow users to operate on the stock database
  according to their privileges (manage, cashier)
• Non functional Constraints
• The machine running the program needs to have
  installed
• .NET 2.0 Framework (Windows 2000 SP3 or later
  required for full functionality of framework)
• MySQL Server 5.0