Context Diagram of Inventory Management System

Context Diagram of Inventory Management System

0 LEVEL DFD

Query for report Query for bill details Sales details item details Category details

login id & password

Inventory Management System 0

ADMIN Response to login

Response to category details Response to item details Response to sales details Response to bill details Response to report

Output

1ST LEVEL DFD

Username/password Login info

1 Admin

admin_login

Log in process

acknowledgement

item info item info

item

category info

category info

2

Admin

category

Data entry vendor info vendor info

vendor_details

customer info Response

cus info cust_details

Item name Category id Admin

Vendor name

item info 3 item

Search response category info

category

category type vendor info Small And Medium Enterprise(SME)

item name/price

vendor_details

response

Item id/name Category id Admin

category info 4 category

Sell process response item info

item

sales info temp

bill

Item id/name Category id Admin Vendor-details vendor_details

retrieve 5

vendor name

item updated item info

Edit process

response

retrieve updated category info

category

retrieve updated vendor info vendor_details sell info/price Item id/name Category id

Admin Vendor-details vendor_details

sales info

6 vendor name

Report generate

temp

Report

ER diagram

Select_ca i_nam ee

i_pric e

cdesc i_qua

i_id

cstatu

cid

item

under

M

category

1

M M

suppl y

delivery totalamount

buy 1

1 orderid

vendor_details

Customer_detail s

emailid

name pin

vendornma e

addres state

address distric

contac itempurchase

Data Dictionary of “Inventory MANAGEMENT SYSTEM” is given below:

Sl.No 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20.

Field Name

Description

Data Type

Width

username password vendorname

address district state pin emailid

User identification name Password vendor name Address of the vendor Name of district Name of state Postal Identification Code E mail address of vendor

Varchar Varchar Varchar Varchar Varchar Varchar Varchar Varchar

200 200 100 1000 100 100 100 100

itempurchase orderid delivery total_amount cid select_category cdese cstatus i_id i_name i_price i_qua

Type of item purchase Identification number of an order Delivery status of an ordered item Total amount of an item Identification number of a category Select category of an item Desription of a category Status of a category Identification number of an item Name of an item Price of an item Quantity of an item

Varchar Varchar Varchar Float Integer Varchar Varchar Varchar Integer Varchar Varchar Integer

1000 10 100 10,2 11 20 100 20 11 30 30 200

4Table Structure:

Tables for “Inventory Management System” are given below:

TABLE NAME: admin_login Description: Contains information about admin login that will be used in the system. Field Name Username Password

Data Types Varchar Varchar

Size 200 200

TABLE NAME: vendor_details Description: Contains information about vendor, which vendor supply the required item. Field Name Vendorname Address District State Pin Emailed

Data Types Varchar Varchar Varchar Varchar Varchar Varchar

Size 100 1000 100 100 100 100

Keys -------

TABLE NAME: category Description: Contains information about item category that will be send by of the proposed system. Field Name cid select_category vendor_name Cdese Cstatus

Data Types Integer Varchar Varchar Varchar Varchar

Size 11 20 100 100 20

Keys -PK ----

TABLE NAME: item Description: Contains information about Items that will be send by of the proposed system.

Field Name select_cat i_id i_name i_price i_qua

Data Types Varchar Integer Varchar Varchar Integer

Size 100 11 30 30 200

Keys Foreign key -----

TABLE NAME: temp Description: Contains information about Sales that will be send by of the proposed system. Field Name Iname Iquantity Iprice

Data Types Varchar Varchar Varchar

Size 400 100 200

Keys ----