Business Intelligence Network Inventory Management Computer Science Essay

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.

Get quality help now
Writer Lyla
Writer Lyla
checked Verified writer
star star star star 5 (876)

“ Have been using her for a while and please believe when I tell you, she never fail. Thanks Writer Lyla you are indeed awesome ”

avatar avatar avatar
+84 relevant experts are online
Hire writer

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.

Get to Know The Price Estimate For Your Paper
Topic
Number of pages
Email Invalid email

By clicking “Check Writers’ Offers”, you agree to our terms of service and privacy policy. We’ll occasionally send you promo and account related email

"You must agree to out terms of services and privacy policy"
Write my paper

You won’t be charged yet!

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.

Updated: Jun 05, 2020
Cite this page

Business Intelligence Network Inventory Management Computer Science Essay. (2020, Jun 01). Retrieved from https://studymoose.com/business-intelligence-network-inventory-management-computer-science-new-essay

Business Intelligence Network Inventory Management Computer Science Essay essay
Live chat  with support 24/7

👋 Hi! I’m your smart assistant Amy!

Don’t know where to start? Type your requirements and I’ll connect you to an academic expert within 3 minutes.

get help with your assignment