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

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

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


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


@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)

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 ( )

Hope that helps

Thanks & Regards,
RNA Team

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

Login to post response