[Go to site: main page, start]
Scribd
Upload
186 views7 pages

Inventory Management ER Diagram

1) The entity-relationship diagram shows the relationships between various entities like Shop, Purchase Order, Bill, Item, Customer etc. 2) The context level data flow diagram shows the flow of item, distributor and shop details between the distributor, inventory management and shop. 3) The logical and physical data flow diagrams show the level 1 and level 2 flows of item, purchase order, bill details between the various entities like distributor, inventory management and shop.

Uploaded by

Pratik Kakani
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
186 views7 pages

Inventory Management ER Diagram

1) The entity-relationship diagram shows the relationships between various entities like Shop, Purchase Order, Bill, Item, Customer etc. 2) The context level data flow diagram shows the flow of item, distributor and shop details between the distributor, inventory management and shop. 3) The logical and physical data flow diagrams show the level 1 and level 2 flows of item, purchase order, bill details between the various entities like distributor, inventory management and shop.

Uploaded by

Pratik Kakani
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
  • Entity-Relationship Diagram
  • Context Level Data Flow Diagram
  • Second Level DFD for Master File
  • Second Level DFD for Transaction Process
  • Second Level DFD for Bill Generation
  • Second Level DFD for Report Generation
  • Distributor List

Entity-Relationship Diagram :

To

1
1 M Purchase
Shop Gives
Order M

PBill

Have To

Sends

M
M M Distributor1 1
Item Purcha
mmmm
se

From

IS A

m
Indoor Outdoor Accessories

M 1 Pay M SBill
Sales Customer
To
Context Level DATA FLOW Diagram :

Admin authorities
Item
Item item Item

0.0
Inventory P.O.
Distributor Management
Distributor Distributor
details For Sports Bill
Shoppe

Shop Shop
Reports
Queries

Physical Data Flow Diagram

Admin authorities
Item details
Item item details Item
Stock detail
0.0
Inventory P.O. detail
Distributor Management
Distributor Distributor
details
details For Sports Bill details
Shoppe

Shop Shop
Queries Reports

Logical
First LevelData
DataFlow
FlowDiagram
Diagram

Item Distributor

2.0
13.0
4.0
.0

Transaction
Bill
Master
Report
Process
Generation
File
Pbill Sbill

Distributor Item

Transaction

P.O.

Sale Bill
Customer

Purchase Bill

Second Level DFD For Master File


Item P.O

1.1
Item details
[Link]
Item
Entry

Distributor

1.2
Distributor details

Distributor
Entry

Second Level DFD For Transaction Process

Item
22.3
2.1.2

Costomer
Get
Get & and
Purchase
Validate Item
Validate
Number
Distributor
Nimber
Item details

Distributor P.O

Distributor details P.O. details

PBill
Sale Bill

Sale Bill details Purchase Details

Sale Bill PBill


2.4

Sale Bill details Purchase Details


Check For
Pending
Bills

Second Level DFD For Bill Generation

Item
33.3
3.1.2

Get Purchase
Get
Get Item
Sale
Details
Details
Item details

Sale Bill

Sale details

PBill

Purchase Details

PBill
Sale Bill
3.4
Purchase Details
Sale Bill details
Update Item
Table Item details

Item
Second Level DFD For Report Generation

Item Distributor
44.3
4.1.2

Available
Purchase
Bill
Stock
Order
Generation
Item details distributor details

P.O details

P.O.

Sale Bill
Item

Sale details
Item details

Customer details

Customer

Sale Bill

Item

Sale Details
Item details

Distributor
4.4

Distributor details Distributor


List

Entity-Relationship Diagram : 1 1 M
Context Level DATA FLOW Diagram : First Level Data Flow Diagram Item
Pbill Sbill Distributor Item Transaction
Item details Distributor
Item details Sale Bill
Item details

You might also like