@Igor If you write my username preceded by the "@" sign e.g. @MDCCL I receive a chat message notification.
@Igor So, my question (6) is answered with your response to question (3), right?
Well, then (7) What are the attributes that you want to keep track of at the exact point in time when a letter is being sent, perhaps, letter number, date of departure, warehouse of departure, warehouse of destination, sender and courier?
(8) Do you know beforehand (e.g., at the point in time when a letter is being sent) who is going to be the receiver of a letter at the destination warehouse?
(9) What are the attributes that you want to keep track of when a letter is being transported, maybe, courier, point of location, vehicule number?
(10) Can a letter have different couriers along the course of a given transportation?
(11) Which attributes do you want to keep track of when a certain letter is accepted at the warehouse of destination, perhaps date and time of reception, courier and receiver?
@Igor (12) Can a letter return to, let's say, the warehouse of origin before it reaches the warehouse of destination?
@MDCCL 6. Yes. 7. Yes, maybe except sender - see (8) 8. In my design sender is only the original sender of a letter (client of the company) and receiver (recipient) is a person to which letters is addressed - there is always one sender and one recipient for a letter. Who receives letter at a warehouse is not really my concern - I only care about which warehouse it is. 9. Yes, courier, vehicle and location.
10. No, for one transport there can only be one courier. 11. Only time and date of receptions and courier. 12. Letter cannot be transported back to the same warehouse after being put to the destination warehouse, however, if transport haven't reached destination warehouse (there was accident and transport must go back), then letter can return.
I also added Deliveries attempts, which I have removed earlier, as they are quite important.
Discussion on question by Igor: How t…
Discussion on question by Igor: How t…