Click here to Skip to main content
15,881,172 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am new designing databases i don't know how to design database for inventory domain please help me how to do this and also give some references to improve my knowledge on how to design databases.Present i am maintaining data in excel now i want to move from excel to sqlserver.
my excel sheet contains the following columns:

Dept : some departments
Product: some products within this different products.
Size : sizes if products
Item # : Items
Vendor : venders
Starting Qty:
New Shipments:
Quanity used:
Ending Qty:

The above fields are contains in excel sheet for month i.e we have maintain data for every month.

Thanks in advance.

1 solution

You might find this link[^] helpful.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900