Software Engineering

Internet Sales Management System

Objective

• The objective of this project is an application of software engineering principles and techniques to the development of a software system. It covers various aspects of object-oriented analysis, design and programming. It also provides an opportunity for a hands-on experience with client-server Internet programming using Java, JavaScript, CGI programming and HTML .

Skills Required

• 1. Knowledge of Object-Oriented analysis and design.
  2. Web-based application design and development.
  3. Programming skills in Java, JavaScript, CGI programming (JDBC) and database management.

Problem Statement

• 
  1. Union Mart Inc. is a national chain store like like Wal-Mart and Target. Every store should have a database maintaining the goods in stock, sales information and return information. The headquarters at San Jose also maintains a database of all chain stores information. The database of the headquarters should be updated periodically based on the feedback from each retail-store. Based on the sales information of each store, the headquarters can decide what should be purchased more and what should be put on sale. The manager at the headquarters can also check the sales information of each retail store using a web browser.

Implementation Requirement

• The system should address the following requirements:
  1. Every sales site maintains its own sales information.
  2. Every sales site updates its database periodically which includes item name, item ID, income and return.
  3. The headquarters can get information of each sales site via internet. This is similar to visiting a personal homepage.
  4. Security issues should be adequately addressed; password protection must be provided as necessary
  5. The headquarters conveys its decisions and orders to the sales sites through email, fax or other communication media
  6. Each sales site must have its own web server

  ---

  Each sales site implementation should satisfy the following:

  1. 
  2. The on-site subsystem should be implemented using Java, HTML or JavaScript.
  3. If there is any submited transaction in database, the corrsponding area in web browser should be updated.
  4. Interface to database should be implemented using Java/JDBC or C or C++.
  5. Server program should be a multi-threaded application. Create a thread for each connection with the server.
  6. Interface to the Cashier should be implemented using Java or C or C++.
  7. Interface to customer serices must be able to handle returns.
  8. Please check Wal-Mart online to get some ideas on how to design sale sites interface. In this project, real time sale's information and goods in stock information should be included.
  9. Please check Gamelan Programming in Java & Database to learn how to design interface for DBA.
  10. Please check here to know how to design multi-thread socket programming.
  11. Generally, please check Gamelan's Programming in Java to get some sample codes.

  ---

  Each headquarter side should include:

  1. 
  2. The requirement is very similar to sales site.
  3. Decision making module is used to make decision on what kind of items and how many items should be ordered and what kind of items should be put on sale.
  4. Sale's information report.
  5. Real-time goods in stock display.

  ---

  In this system, at least two sales sites and one headquarters should be implemented.

Schedule

• This system is supposed to be developed according to the software lifecycle taught in class. Good software engineering principles must be followed. In particular documentation must be good.
  1. Requirement and specification including Object Model, ....
  2. High-level design
  3. Low-level design
  4. Coding
  5. Test Plan
  6. Testing including bug list report
  7. Maintenace report