SUBMITTED BY :BISWA NARESH SUBUDHIREG NO:-0605205036DEPT: MASTER IN COMPUTER APPLICATION (MCA)Batch – 2006-09

What is supply chain management System!!!

SUPPLY CHAIN MANAGEMENT SYSTEM (SCM) is the oversight of materials, information, and finances as

they move in a process from supplier to manufacturer to wholesaler to retailer to consumer.

SUPPLY CHAIN MANAGEMENT SYSTEM involves coordinating and integrating these flows both within

and among companies.

Ultimate goal of supply chain management system is to reduce Inventory (with the assumption that products are available when needed). As a solution for successful SUPPLY CHAIN MANAGEMENT SYSTEM, sophisticated software systems with Web interfaces are competing with Web-based application service providers (ASP) who promise to provide part or all of the SCM service for companies who rent their service.

Supply chain management system flows

Product flowInformation flow

Finances flow

Includes movement of goods from a supplier to a customer, as well as any customer returns or service needs

Includes transmitting orders and updating the status of delivery

Includes credit terms, payment schedules

SCM Software

Planning Applications

Execution Applications

Use advanced algorithms to determine the best way to fill an order

Track the physical status of goods, the management of materials, and financial information involving all parties

MVC Architecture

MVC FRAMEWORK

The key motivation behind the MVC approach is the desire to separate the code that creates and manipulates the data from the code that presents data. MVC- Model View Controller architecture is all about dividing application components into three different categories Model, View, Controller. Components of the MVC architecture have unique responsibility and each component is independent of the other component. Changes in one component will have no or less impact on other component.

BROWSERRequest Processing

Data ValidationBusiness Logic

Data ManipulationResponse Generation

ARCHITECTURES:Model – 1 Architecture: In Model- 1 architecture a request is made to a JSP or servlet and then that JSP or servlet handles all the responsibilities for request, including processing the request, validating data, handling the business logic, and generating a response.

Database services

Request

Response

BROWSER

Controller (Servlet)

Request ProcessingData Validation

Model

Business LogicData Manipulation

View (JSP)

Report Generation

Model – 2 Architecture:

In the MVC architecture, a central servlet, known as the Controller, receives all requests for the application. The Controller then processes the request and works with the Model to prepare any data needed by the view and forwards the response to the browser.

Database services

System Specification

Hardware specification Software specification

Client machine

Servermachines

Operating System:- Windows2000ProfessionalLanguage:- JAVA, SQLTools:- JSP, HTML, XML,STRUTSDatabase:- ORACLE 10GIDE-: My Eclipse 5.5

System

Existing system Proposed system

It is The manual system . Main tasks of the existing system is to accept requirements from different areas, verify them & process. The need for computerization of the existing system arose because of inaccuracy & irregularities.

It is completely web based system. It is an internet and intranet based application. client has to only fill in appropriate option mention on the site for a particular information. The system should be user friendly.

System study

Definition of System Needs of System

A system is an orderly grouping of independent components linked together according to a plan to achieve a specific objective. Its main characteristics are organization, interaction, independent, integration. Central objective a system does not necessarily mean to a computer system. It may be a manual system or any other names.

Social and economic factor Technological factor High level decisions and operating processes.

System Analysis

System Planning Preliminary Investigation

Information gathering

System Analysis is a process by which we attribute process or goals to a human activity, determine how well those purpose are being achieved and specify the requirements of the various tools and techniques that are to be used within the system if the system performances are to be achieved.

Structured Analysis

Structured analysis is a set of techniques and graphical tools (DFD) that allow the analyst to develop a new kind of system specifications that are easily understandable to the user.

Dataflow Diagram

Data Flow Diagram is a diagrammatic representation of data movement through a system –manual or automated - from inputs to outputs through processing

Logical Physical

Represent the transformation of the data from input to output through processing logically and independently of the physical components.

Show the actual implementation and movement of data between people, departments, and workstations.

Below is the top level DFD showing how the User’s request processed by the server with database interaction and sends the response back to the user.

Data Flow Diagrams for “SUPPLY CHAIN MANAGEMENT SYSTEM” CONTEXT LEVEL DFD

Distributor Manufacturer

Supply ChainManagement

System

Supplier

Result Supplier Query

Result

Distributor Query

Manufacturer query

Result

Supplier

Distributor

Product

Login

Order placing

Order processing

Send notice

View Notice

Feedback

Feedback Reply

Change password

Distributor

User

Supplier

Manufacturer

View View

SUPPLY CHAIN MANAGEMENT SYSTEM

DATA DICTIONARY

Decision Table

Decision Tree & Structured English

It is a structured repository of data about data. offers documentation & improving communication by establishing consistent definitions of various elements, terms, & procedures.

A Decision Tree sketches the logical structure based on some criteria & easy to construct, read, and update. Structured English uses logical constructs and imperative sentences designed to carry out instruction for action.

It is a table of contingencies for defining a problem and the actions to be taken .It is a single representation of the relationships between conditions and actions .

TABLE 1:Name : DISTRIBUTOR_INFO

Description: This table keeps the record of the distributors who holds transactions with the manufacturer.Primary Key: Distributor id.

Column Name Data Type Primary KeyDescription

ID VARCHAR2(40) 1Primary key. A unique number that is assigned to all the distributors.

NAME VARCHAR2(400) -

ADDRESS VARCHAR2(4000) -

PIN NUMBER(10,0) -

CITY VARCHAR2(400) -

STATE VARCHAR2(400) -

COUNTRY VARCHAR2(400) -

PHONENO VARCHAR2(20) -

VARCHAR2(20) -

FAX VARCHAR2(20) -

CONTACT_PERSON VARCHAR2(400) -

REGNO VARCHAR2(40) -

CREDIT_BAL NUMBER(10,2) -

DEBIT_BAL NUMBER(10,2) -

credit_limit NUMBER(10,2) -

Locked VARCHAR2(10) -

LOGINID VARCHAR2(400) -

PASSWORD VARCHAR2(400) -

EMAIL VARCHAR2(400) -

HOME: View page for general user who can view the product, supplier & distributors. For suppliers , distributors & manufacturer can login by clicking the login hyperlink.

LOGIN:This is the login page for supplier, distributor & manufacturer.Each can login by giving their valid user id & password & clicking on the login button.

MANUFATURER”S HOMEPAGE: This is the home page for the manufacturer which appears after he logs in by giving valid userid & password.

ADDMATERIAL: Byclicking the add material link in the manufacturer home page we can view the material list and in that page by clicking on Add New Material link we can move to the next page where we can add materials.

ADDMATERIAL IN DETAIL: By filling up this form manufacturer can add new materials.

POSTORDER MATERIAL: By clicking the post Material Order link in the manufacturer page we can view this form, filling which the manufacturer can post the order.

SUPPLIER’ HOME: This is the Supplier home page that appears after the supplier logs in using valid user id & password.

VIEWMATERIAL ORDER: By clicking on view order link in the supplier home page, the supplier can view the status of the order received.

CHANGEPASSWORD: By clicking the change password link the supplier, manufacturer & distributor can change their old password.

DISTRIBUTOR: This is the Distributor home page that appears after the distributor logs in using valid user id & password.

System Implementation

Implementation is the stage of the project when the theoretical design turned into a working system.

Implementation

Installing client

machine

Installing software on server

Training staff

In operation

Example of SUPPLY CHAIN MANAGEMENT SYSTEM