User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 456,485 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,791 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums
Views: 2067 | Replies: 2
Reply
Join Date: Sep 2007
Posts: 1
Reputation: adeel.alvi is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
adeel.alvi adeel.alvi is offline Offline
Newbie Poster

Question Inventory Management DAtabse

  #1  
Sep 14th, 2007
Iam working on a purchase managment system that manages the puchases and inventory of the company that sells pcs. i want to manage employees (pemant,consultants) , customers , supliers , business partners all will be the users in the application . what would be the right design of the database should i create all of them in saparate entity or what would be right design .???


Regards

Adeel
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,444
Reputation: debasisdas is on a distinguished road 
Rep Power: 4
Solved Threads: 87
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Nearly a Posting Virtuoso

Re: Inventory Management DAtabse

  #2  
Sep 14th, 2007
Its really very difficult to suggest from here without having the knowlwdge of actual requirment at your side.
I would suggest you instead of storing them separately ,store with some flag setting as a single entity.
Share your Knowledge.
Reply With Quote  
Join Date: Sep 2007
Location: Far reaches of known space
Posts: 58
Reputation: Temmu is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 4
Temmu's Avatar
Temmu Temmu is offline Offline
Junior Poster in Training

Re: Inventory Management DAtabse

  #3  
Sep 18th, 2007
agreed.

the idea of a relational database is to vastly reduce the amount of stored data by keeping it separate and unique.

get a copy of microsoft access (even a very old copy) and look at the north wind traders database. it is what you describe.
(o) Yes, I'd like to reboot my computer now.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Database Design Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the Database Design Forum

All times are GMT -4. The time now is 3:04 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC