This undertaking chiefly deals with automatizing the undertakings of keeping and transacting the goods.In the Business Intelligence Network, stock list direction is the cardinal procedure. This procedure includes the activities such as care of stock inside informations, care of grosss and points etc. It is a boring occupation to keep all these inside informations manually. Hence we opted to automatize the Business Intelligence Network.
Business Intelligence Network automates the boring occupation of system. It chiefly includes five members.
1. Administrator
2. Sub-Location In-charge
3. Retailer
4. Supplier
5. Customer
Business Intelligence Network System chiefly deals with the undermentioned procedures.
1. Registration of members
2. Ordering points
3. Geting points, Grosss
4. Transfering points
5. Selling points and bring forthing measures
6. Generating studies
The Administrator has the privilege to keep different types of points in the system.He is concerned with enrollment of Suppliers, Sub-Location In-charges. He maintains the studies of providers who are eligible to provide the points. He can direct the purchase order to above providers when points are required.
He is responsible to add grosss when points delivered to the direction system. He is besides responsible to direct the points to sub-location in-charges on demand. He deals with adding of new points and bring forthing studies on points, orders, grosss and stock Counterterrorist Center.
Sub-location In-charge is registered and verified by the decision maker. He is responsible to keep the points for reassigning them to Retailers on demand. He can direct purchase order to Administrator for acquiring points that are required for retail merchants. He can transport the points to retailer when he got the purchase order from retail merchant.
He deals with bring forthing studies on points, orders and stock etc.
Retailer is registered and verified by sub-location in-charge. He is responsible to keep the points for selling to clients. He can direct purchase order to Sub-location In-charge for acquiring points that are required for clients. He deals with bring forthing studies on points, orders, measures and stock etc.
The provider supplies the points based on the order provided by the decision maker.
The client receives the measures from the retail merchant based on his purchases.
This undertaking fulfills the desires of users to heighten the communicating among different type of people such as decision maker, Sublocation Incharge and Retailer. And the decision maker ‘s occupation is simplified to the maximal extent.
This system chiefly consists of five faculties…
1. Master care
2. Receiving
3. Cargo
4. Charge
5. Reports
Maestro Care:
Business Intelligence Network system maintains the undermentioned maestro inside informations for assorted intents.
I ) Suppliers Details
two ) Sublocation Incharges Detailss
three ) Retailers Detailss
four ) Items Detailss
Receiving:
Business Intelligence Network System receives the stock in a validated mode against Purchase Order & A ; Receipt No. Acknowledge can be tracked down to the palette id degree. Business Intelligence Network having procedure includes all the points necessary to have, from droping the trucks to entering the history. This system can execute the following receiving undertakings…
I ) Purchase order entry
two ) Receipt entry of goods
Cargo:
Supply Chain Management System provides you a figure of maps to keep the flow of goods.
The undermentioned undertakings are caused under this faculty…
I ) Transfer stock list
two ) Put stock list on clasp
three ) View stock list balances
four ) View stock list minutess
Charge:
Supply Chain Management charge procedure allows the retail merchant to bring forth new measures and besides allows screening of bing measures.
Reports:
The studies procedure allows the user to bring forth the studies necessary for twenty-four hours to twenty-four hours concatenation direction operations. The standard studies are…
I ) Inventory Reports
two ) Purchase Order Reports
three ) Administrative Reports
1.2.GOALS AND OBJECTIVES
Goals:
To automatize the Business Intelligence Network in an easy and efficient mode.
To do the occupations of admin, sub-location, retail merchant easy and problem free.
To do the application user friendly.
Aims:
To get up to day of the month inside informations about stock list.
To cognize the position of the Supply Chain Management System.
To cut down the mistakes those are occurred in the manual system.
To bring forth the studies as per the direction demands.
To assist in telling of required points.
To supply maximal services to the users.
1.3.SOFTWARE AND HARDwARE REQUIREMENTS
Hardware Requirements:
Processor Pentium III
Speed 800 MHz
Monitor EGI/VGA
Hard Disk 20 GB
RAM 128 M B
Mouse Logitech
Key board TVS
Software Requirements:
Operating System Windows NT
Languages Java 2.0, Jsp, Jdbc.
Web Technologies HTML, JavaScript.
Back End Oracle 8.0
Documentation Tool Microsoft word 2000
Analysis
2.1.USECASES
Business Intelligence Network System Use A?aA?e:
Figure: Business Intelligence Network Use instance Diagram.
Administration Use A?aA?e:
Figure: Adminstrator Use instance Diagram.
login
Brief Description:
This usage A?aA?e describes how the user logs on to Business Intelligence Network System.
Flow Of Events:
Basic Flow:
This usage A?aA?e starts when the histrion wishes to log into Business Intelligence Network System.
The system requests the histrion to come in his/her name and watchword.
The histrion enters his/her name and watchword.
The system validates the entered name and watchword and logs the histrion into system.
Alternate Flow:
Invalid Name / Password:
If in the basic flow the histrion enters an invalid name and password the system displays an mistake message. The histrion can take to either return to beginning of basic flow or call off the login, at which the usage A?aA?e terminals.
Particular Requirements:
None.
Pre Conditionss:
None.
Post Conditionss:
If the usage A?aA?e was successful the histrion is now logged into the system. If non the system province is unchanged.
Extension Points:
None.
alteration watchword
Brief Description:
This usage A?aA?e is used to alter the watchword of the Administrator, Sub-Location In-charge and Retailer in the Business Intelligence Network System.
Flow Of Events:
Basic Flow:
This usage A?aA?e is initiated when the histrion wants to alter the watchword.
System requests the histrion to come in his/her inside informations.
The histrion enters the inside informations.
The system validates the entered inside informations and allows the histrion to alter the watchword.
The new watchword of the histrion is stored in the several database.
Alternate Flow:
Invalid Name / Password:
If the histrion enters the invalid name and/or watchword, the system displays an mistake message. The histrion can take either return to the beginning of the basic flow or call off the alteration watchword, at which point the usage A?aA?e terminals.
Particular Requirements:
None.
Pre Conditionss:
The histrion should already be an bing Retailer / Sub-Location Incharge / Administrator.
Post Conditionss:
The new watchword becomes valid.
Extension Points:
None.
Item enrollment
Brief Description:
This usage A?aA?e is used to add a new point, cancel any fresh point information.
Flow Of Events:
Basic Flow:
This usage A?aA?e starts when the Administrator wants to register new Item.
System asks the Item information from the Administrator i.e. Item name, per-unit cost.
Administrator enters the inside informations.
Now a new case of Item will be created in the Database.
Alternate Flow:
Invalid Detailss:
If Administrator enters invalid information that will take to error.
Particular Requirements:
None.
Pre Conditionss:
Administrator should logon to the system. Post Conditionss:
If flow is successfully completed, new Item information will be generated in database.
Extension Points:
None.
studies
Brief Description:
This usage A?aA?e is used to supply appropriate Reports to Administrator.
Flow Of Events:
Basic Flow:
This usage A?aA?e starts when the Administrator wants to see Reports such as entire providers information, entire stock help etc.
System asks the restraints of Administrator.
Administrator specifies his restraints.
Required studies will look before the Administrator.
Alternate Flow:
Invalid Detailss:
If Administrator specifies invalid restraints that will take to empty study.
Particular Requirements:
None.
Pre Conditionss:
Administrator should logon to the system.
Post Conditionss:
If flow is successfulh/ completed, needed study for Administrator will generale.
Extension Points:
None.
stock
Brief Description:
This usage A?aA?e is used to supply appropriate information about the stock in the supply concatenation direction to Administrator.
Flow Of Events:
Basic Flow:
This usage A?aA?e starts when the Administrator wants to see Stock Information.
Administrator specifies his petition.
System verifies the petition of Administrator.
Stock information will appears before the Administrator.
Alternate Flow:
None.
Particular Requirements:
None.
Pre Conditionss:
Administrator should logon to the svstem.
Post Conditionss:
If flow is successfullv completed, stock information will be displaved.
Extension Points:
None.
Admin-Subincharge Transaction Use Gase:
Figures: Adminstrator- Sub Location In-charge Transaction Usecase
SUBLOCATION INCHARGE REGISTRATION
Brief Description:
This usage A?aA?e is used to add a new Sub-Location In-charge, cancel any fresh Sub-Location In-charge information.
Flow Of Events:
Basic Flow:
This usage A?aA?e starts when the Administrator wants to register new Sub-Location In-charge.
System asks the Sub-Location In-charge information from the Administrator i.e. Name of Person, reference, phone figure etc.
Administrator enters the Person inside informations.
Now a new case of Sub-Location In-charge will be created in the Database.
Alternate Flow:
Invalid Detailss:
If Administrator enters invalid information that will take to error.
Particular Requirements:
None.
Pre Conditionss:
Administrator should logon to the svstem. Post Conditions:
If flow is successfullv completed, new Sub-Location In-charge information will be generated in database.
Extension Points:
None.
decision maker gross revenues order
Brief Description:
This usage A?aA?e is used to add new gross revenues order information.
Flow Of Events:
Basic Flow:
This usage A?aA?e starts when the Administrator wishes to let go of goods to a Sub-Location Incharge.
System asks the Sub-location In-charge Purchase Order information from the Administrator i.e. Order figure etc.
Administrator enters the Purchase Order inside informations. aˆ? & A ; Use A?aA?e will take the information from Purchase Order Details and updates the stock in Administrator stock and Sub-location In-charge Stock.
Alternate Flow:
Invalid Detailss:
If Administrator enters invalid purchase information that will take to error.
Particular Requirements:
None.
Pre Conditionss:
Administrator should logon to the system and Sub-location In-charge should direct purchase order.
Post Conditionss:
If flow is successfully completed, new Gross saless Order information will be generated iri database.
Extension Points:
None.
sublocation incharge purchase order
Brief Description:
This usage A?aA?e is used to add new purchase order information. Flow Of Events:
Basic Flow:
This usage A?aA?e starts when the Sub-location In-charge wants to order the Items to Administrator.
System asks the Purchase Order information from the
Sub-location In-charge i.e. Cheque figure, Item-id, Quantity etc.
Sub-location In-charge enters the Purchase Order inside informations.
Now a new case of Purchase Order will be created in the Database.
Alternate Flow:
Invalid Detailss:
If Sub-location In-charge enters invalid information that will take to error.
Particular Requirements:
None.
Pre Conditionss:
Sub-location In-charge should logon to the system.
Post Conditionss:
If flow is successfully completed, new Purchase Order information will be generated in database.
Extension Points:
None.
Admin-Supplier Transaction Use A?aA?e
grosss
Brief Description:
This usage A?aA?e is used to add receipt information. This reception will be collected from provider to Administrator,
Flow Of Events:
Basic Flow:
This usage A?aA?e starts when the Administrator wants to add new Receipt information.
Svstem asks the Receipt information from the Administrator.
Administrator enters the Receipt inside informations.
Now a new case of Receipt will be created in the Database.
Alternate Flow:
Invalid Detailss:
If Administrator enters invalid information that will take to error.
Particular Requirements:
None. Pre Conditionss:
Administrator should logon to the svstem. Post Conditions:
If flow is successfullv completed, new Receipt information will be generated in database.
Extension Points:
None.
decision maker purchase order
Brief A?escription:
This usage A?aA?e is used to add new purchase order Information.
Flow Of Events:
Basic Flow:
This usage A?aA?e starts when the Administrator wants to order the Items to particular provider.
System asks the Purchase Order information from the Administrator i.e. Cheque figure, Item-id, Quantity etc.
Administrator enters the Purchase Order inside informations.
Now a new case of Purchase Order will be created in the Database.
Alternate Flow:
Invalid Detailss:
If Administrator enters invalid information that will take to error.
Particular Requirements:
None.
Pre Conditionss:
Administrator should logon to the svstem.
Post Conditionss:
If flow is successfully completed, new Purchase Order information will be generated in database.
Extension Points:
None.
provider enrollment
Brief Description:
This usage A?aA?e is used to add a new Supplier, delete any fresh Supplier information.
Flow Of Events:
Basic Flow:
This usage A?aA?e starts where the Administrator wants to register new Supplier.
System asks the Supplier information from the Administrator i.e. Name of Person, reference, phone figure etc.
Administrator enters the Person inside informations.
Now a new case of Supplier will be created in the Database.
Alternate Flow:
Invalid Detailss:
If Administrator enters invalid information that will take to error.
Particular Requirements:
None.
Pre Conditionss:
Administrator should logon to the system.
Post Conditionss:
If flow is successfulh/ completed, new Supplier information will be generated in database.
Extension Points:
None.
Sub-Ret Transaction Use A?aA?e
retail merchant enrollment
Brief Description:
This usage A?aA?e is used to add a new Retailer, delete any fresh Retailer information.
Flow Of Events:
Basic Flow:
This usage A?aA?e starts when the Sub-Location In-charge wants to register new Retailer.
System asks the Retailer information from the Sub-Location In-Charge i.e. Name of Person, reference, phone figure etc.
Sub-Location In-Charge enters the Person inside informations.
Now a new case of Retailer will be created in the Database.
Alternate Flow:
Invalid Detailss:
If Sub-Location In-Charge enters invalid information that will take to error.
Particular Requirements:
None.
Pre Conditionss:
Sub-Location In-Charge should logon to the system. Post Conditionss:
If flow is successfulh/ completed, new Retailer information will be generated in database.
Extension Points:
None.
SUBLOCATION INCHARGE SALES ORDER
Brief Description:
This usage A?aA?e is used to add new gross revenues order information.
Flow of events:
Basic Flow:
This usage A?aA?e starts when the Sub-location In-charge wishes to let go of goods to a Retailer.
System asks the Retailer In-charge Purchase Order information from the Sub-location In-charge i.e. Order figure etc.
Sub-location In-charge enters the Purchase Order inside informations.
Use A?aA?e will takes the information from Purchase Order Details and updates the stock in Sub-location In-charge stock and Retailer Stock.
Alternate Flow:
Invalid Detailss:
If Sub-location In-charge enters invalid purchase information that will take to error.
Particular Requirements:
None.
Pre Conditionss:
Sub-location In-charge should logon to the system and Retailer should direct purchase order.
Post Conditionss:
If flow is successfulh/ completed, new Gross saless Order information will be generated in database.
Extension Points:
None.
retail merchant purchase order
Brief Description:
This usage A?aA?e is used to add new purchase order information.
Flow Of Events:
Basic Flow:
This usage A?aA?e starts when the Retailer wants to order the Items to particular Sub-Location Incharge.
System asks the Purchase Order information from the Retailer i.e. Cheque figure, Item-id, Quantity etc.
Retailer enters the Purchase Order inside informations.
Now a new case of Purchase Order will be created m the Database.
Alternate Flow:
Invalid Detailss:
If Retailer enters invalid information that will take to error.
Particular Requirements:
None.
Pre Conditionss:
Retailer should logon to the system.
Post Conditionss:
If flow is successfulh/ completed, new Purchase Order information will be generated in database.
Extension Points:
None.
Administration Report Use A?aA?e
decision maker studies
Brief Description:
This usage A?aA?e generates the study based on the standards mentioned by the Administrator.
Flow Of Events:
Basic Flow:
System allows the Administrator to choose any one of the followers options
I ) Retailer Report
two ) Supplier Report
three ) Item Report
four ) Sublocation Incharge Report
V ) Stock Report
a ) Admin Stock
B ) Sub-location In-charge Stock
degree Celsius ) Retailer Stock six ) Gross saless Order Report seven ) Purchase Order Report eight )
The Administrator selects option
System performs the hunt based on the option selected by the Administrator and gives the hunt consequences in a forrnatted manner as a study.
Alternate Flow:
Invalid Detailss:
If Administrator enters invalid option that will take to error.
Particular Requirements:
None.
Pre Conditionss:
Administrator should logon to the system.
Post Conditionss:
If flow is successful, the hunt consequences are given to the Administrator in a forrnatted manner as a study. Otherwise, the usage A?aA?e terminates.
Extension Points:
None.
Sublocationincharge Report Use Gase
SUBLOCATION INCHARGE REPORTS
Brief Description:
This usage A?aA?e generates the study based on the standards mentioned by he Sub-location In-charge.
Flow Of Events:
Basic Flow:
System allows the Sub-Location Incharge to choose any one of the followers options
I ) Retailer Report
two ) Item Report
three ) Stock Report
a ) Sub-location In-charge Stock
B ) Retailer Stock
four ) Gross saless order Report
V ) Purchase order Report
The Sub-Location Incharge selects option
System performs the hunt based on the option selected by the Sub-Location Incharge and gives the hunt consequences in a formatted manner as a study.
Alternate Flow:
Invalid Detailss:
If Sub-Location Incharge enters invalid option that will take to error.
Particular Requirements:
None.
Pre Conditionss:
Retailer should logon to the system.
Post Conditionss:
If flow is successful, the hunt consequences are given to the Sub-location In-charge in a formatted manner as a study. Otherewise, tetrahydrocannabinol usage A?aA?e terminates.
Extension Points:
None.
Retailer Report U se A?a Se
retail merchant studies
Brief Description:
This usage A?aA?e generates the study based on the standards mentioned by the Retailer.
Flow Of Events:
Basic Flow:
System allows the Retailer to choose any one of the followers options
I ) Item Report
two ) Retailer Stock Report
three ) Bills Report
four ) Purchase Order Report
The Retailer selects option
System performs the hunt based on the option selected by the Retailer and gives the hunt consequences in a formatted manner as a study.
Alternate Flow:
Invalid Detailss:
If Retailer enters invalid option that will take to error.
Particular Requircments:
None.
Pre Conditionss:
Retailer should logon to the system.
Post Conditionss:
If flow is successful, the hunt consequences are given to the Retailer in a formatted manner as a study. Otherwise, the usage A?aA?e terminates.
Extension Points:
None.
BlLLS
Brief Description:
This usage A?aA?e is used to add measure information. This measure will be given to client while he is buying from a retail merchant.
Flow Of Events:
Basic Flow:
This usage A?aA?e starts when the Retailer wants to add new Bill information.
System asks the Bili information from the Retailer.
Retailer enters the Bili inside informations.
Now a new case of Bill will be created in the
Database that will updates the Retailer Stock
Information.
Alternate Flow:
Invalid Detailss:
If Administrator enters invalid information that will take to error.
Particular Requirements:
None.
Pre Conditionss:
Retailer should logon to the svstem.
Post Conditionss:
If flow is successfullv completed, new Bill information will be generated in database.
Extension Points:
None.
Design
SEQUENCE DIAGRAMS
Login Sequence:
Change Password Sequence:
Figure: Change watchword Sequence Diagram.
Supplier Registration Seguence:
Subincharge Registration Sequence:
Item Registration Sequence:
Retailer Registration Sequence:
Admin Purchase Order Sequence:
Admin Gross saless Order Sequence:
Sub Location In-charge Purchase Order:
Sublncharge Gross saless Order Sequence:
Retailer Purchase Order Sequence:
Receipt Sequence:
Bill Sequence:
Admin Stock Seguence:
Subincharge Stock Seguence:
Retailer Stock Sequence:
Admin Report Sequence:
Figures: Administrator Report Sequence Diagram.
Subincharge Report Sequence:
Figure: Sub Incharge Report Sequence Diagram.
Retailer Report Seguence:
COLLABORATION DIAGRAMS
Login Collaboration:
Change Password Collaboration:
Supplier Registration Collaboration:
Item Registration Collaboration:
Subincharge Registration Collaboration:
Retailer Registration Collaboration:
Admin Purchase Order Collaboration:
Admin Gross saless Order Collaboration:
Subincharge Purchase Order Collaboration:
Subincharge Gross saless Order Collaboration:
Retailer Purchase Order Collaboration:
Receipt Collaboration:
Bill Collaboration:
Admin Stock Collaboration:
Subincharge Stock Collaboration:
Retailer Stock Collaboration:
Admin Report Collaboration:
Subincharge Report Collaboration:
Retailer Report Collabaration:
Class Diagram
Class Diagram
Class Diagram
Tables
Table Name: ADMINLOGIN
Name
Type
USERNAME
VARCHAR2
Password
VARCHAR2
Table Name: Bills
Name
Type
BILLNO
Number
RETAILERID
VARCHAR2
ITEMID
Number
QTY
Number
Table Name: Item
Name
Type
ITEMID
Number
ITEMNAME
VARCHAR2
UNITCOST
VARCHAR2
Table Name: Gross
Name
Type
REPNO
Number
WPOID
Number
Table Name: Retailer
Name
Type
RETAILERID
Number
Password
VARCHAR2
Name
VARCHAR2
HOUSENO
VARCHAR2
Street
VARCHAR2
City
VARCHAR2
State
VARCHAR2
State
VARCHAR2
Telephone
VARCHAR2
Electronic mail
VARCHAR2
Table Name: RETAILERPAYMENT
Name
Type
RPOID
Number
RETAILERID
Number
PODATE
VARCHAR2
CHENO
VARCHAR2
Table Name: RETAILERPURCHASEORDER
Name
Type
RETAILERID
Number
RPOID
Number
ITEMNO
Number
QTY
Number
Table Name: SLPAYMENT
Name
Type
SUBPOID
Number
PODATE
VARCHAR2
CHENO
VARCHAR2
Table Name: DESC SLPURCHASEORDER
Name
Type
SUBPOID
Number
ITEMID
Number
QTY
Number
Table Name: DESC SLSALESORDER
Name
Type
RPOID
Number
SLIID
Number
SLPAYDATE
VARCHAR2
CHENO
Number
ITEMNO
Number
QTY
Number
Table Name: SUBLOCATIONINCHARGE
Name
Type
SUBINCHARGEID
Number
Password
VARCHAR2
Name
VARCHAR2
HOUSENO
VARCHAR2
Street
VARCHAR2
City
VARCHAR2
Telephone
Number
Electronic mail
VARCHAR2
State
VARCHAR2
LOCATIONNAME
VARCHAR2
MAXNOOFRETAILERS
VARCHAR2
State
VARCHAR2
Table Name: DESC SUBLOCATIONSTOCK
Name
Type
ITEMID
Number
QTY
Number
Table Name: DESC SUPPLIER
Name
Type
SUPPLIERID
Number
Name
VARCHAR2
Telephone
Number
Electronic mail
VARCHAR2
House
VARCHAR2
Street
VARCHAR2
City
VARCHAR2
State
VARCHAR2
Table Name: WAREHOUSEPAYMENT
Name
Type
WPOID
Number
PAYDATE
VARCHAR2
SUPPLIERID
Number
CHEQUENO
VARCHAR2
Table Name: WAREHOUSEPURCHASEORDER
Name
Type
WPOID
Number
ITEMID
Number
QTY
Number
Table Name: WAREHOUSESALESORDER
Name
Type
SLPOID
Number
WAREHOUSESALEDATE
VARCHAR2
SHIPMENTDES
VARCHAR2
ITEMID
Number
QTY
Number
Table Name: WAREHOUSESTOCK
Name
Type
ITEMID
Number
QTY
Number
// Paste u R screens
Decision
The chief aim of the undertaking is to automatize the “ Business Intelligence Network ” . By utilizing ORACLE as back-end and J2EE as front-end under WINDOW NT environment.
This system is used for efficient operation of the direction system works. It deals with keeping Administrator, Sub-Location In-charge and Retailer.
This undertaking “ BUSINESS INTELLIGENCE NETWORK SYSTEM ” is really utile and helpful because the effiency will better with better manner of communicating among Administrator – Sublocation Incharge, Sublocation Incharge – Retailer.
Reliable and accurate studies could be available with in a really short clip, which is non possible if done manually.
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
