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

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Kumaraspcode2009@gmail.com

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

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

@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

Latest Posts