How to Implemented for this Concept in C# [Resolved]

Posted by Jayakumars under C# on 3/22/2017 | Points: 10 | Views : 224 | Status : [Member] [MVP] | Replies : 1
Hi

How to start Inventory Concept any one guide me.

What are the Database design need for this and also process explain

any one guide me.

Mark as Answer if its helpful to you


Responses

Posted by: Rajnilari2015 on: 3/22/2017 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
@Jayakumars Sir,
Here is a quick start for your problem

Table: ItemMaster
-------------------
Item ID (PK)
Item name
Item price

Table: SupplyMaster
-------------------------
Supply ID(PK)
Supply name

Table: Stock
---------------
Item ID (FK to Items)
Supply ID (FK to SupplyMaster)
Stock ID(PK)
Quantity

Table: Sales
---------------
Sales Id (PK)
Sales Date
Stock ID(FK to Stock)
Sales Amount

Table: Purchase
---------------
Purchase Id (PK)
Purchase Date
Purchase Amount
Stock ID(FK to Stock)


For more detail, please refer

a) Proposed Design of an Inventory Database System at Process Research ORTECH (http://www.cs.toronto.edu/~sme/CSC340F/2002/samples/Asst3-5.pdf )
b) https://www.slideshare.net/copo7475/inventory-management-system-16598132

Hope that helps

--
Thanks & Regards,
RNA Team

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response