about analysis of my project.

Question

hello sir my self ashish narola from ahmd...kindly help me for my new project on Sales and inventory management system for departmental store.. but i am confuse about how can i decide the tablesflows etc.. i am confusing about which field can i take for product_master tablesales and purchase account etc i am not getting idea about it.. so. plz help thanks you can take example of departmental store as Bigbazaar..or d-mart

Suthish Nair · Answer

If the query got resolved then mark the post that helped you as Answer so will be helpful for others. Otherwise if you got the solution please share with us.

Suthish Nair · Answer

Best example to refer is Northwind Database. Download it and check how the normalization had done with tables.

Krishna Garad · Answer

Before starting your work you must need to study of various aspect for Departmental store. As per your query some general field we can explain for Product_master table but it might be different in your case. Ex Product_master 1. Product_Id 2 Product_name 3 Prod_Desc 4 Prod_Price ..... ..... ..... etc... As per your requirment you can create your tables structures.