How to Table Design for this Situation [Resolved]

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi

How to Design Following Concept Tables for a Inventory Concept
any one share with me

1.Purchase,
2.sales,
3.Stock,
4. SupplyMaster,
5.ItemMaster

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Rajnilari2015 on: 3/20/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 Equally please go through the SQL Server How to tutorials ( http://techfunda.com/howto/sql-server ) at Techfunda 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

Equally please go through the SQL Server How to tutorials ( http://techfunda.com/howto/sql-server ) at Techfunda

Hope that helps

--
Thanks & Regards,
RNA Team

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

Latest Posts