DateStorage - contains information about when a Letter has arrived to certain Warehouse.A Letter can be stored in few different Warehouses on different Dates (on ‘01.11’ it is in ‘Warehouse A’, and on ‘02.11’ in ‘Warehouse B’).Transports are made between different Warehouses and must consist of many Letters, Letters can be a part of multiple Transports (on different Dates).There can be many People in database, if a Person is stored in the database it must be Sender or Receiver of some Letter.Letters are sent and received by People, one letter can be sent by one particular Person, and also received by a specific Person.at last, letter is delivered to recipient.then it could be transferred between warehouses,.letter is collected from sender and it goes to warehouse,.The process I want to model looks like this: It should allow tracking letters, e.g., checking what letters were on certain date in a specific warehouse. This database should store information about letters, deliveries, moving letters from one warehouse to another, and historical information. I am trying to crate entity-relationship diagram for a transport company database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |