Thread: Erd problem
View Single Post
Join Date: Jun 2005
Posts: 60
Reputation: pclfw is an unknown quantity at this point 
Solved Threads: 5
pclfw pclfw is offline Offline
Junior Poster in Training

Re: Erd problem

 
0
  #3
Jan 9th, 2009
Now that is quite a good question.

Does the data about the stock belong (totally) to the book itself? Or is the concept of STOCK a seperate item?

The data could go in a number of places, but how and when is it going to be used. The NUMBER_IN_STOCK is going to be reduced whenever a sale of that item is made, so does it belong in the SALES system? The NUMBER_IN_STOCK is going to be increased whenever a delivery of that item is received, so does it belong in the PURCHASING system?

Is stock control a seperate process / procedure, such that it needs its own processes?

You're the designer, these are design decisions. Make them.
Reply With Quote