How to Table Design for this Situation [Resolved]

Posted by Jayakumars under C# on 3/20/2017 | Points: 10 | Views : 141 | Status : [Member] [MVP] | Replies : 1
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


Responses

Posted by: Rajnilari2015 on: 3/20/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

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

Login to post response