Hi,
In a warehouse OLTP application I need to define entities for warehouses, locations and storage bins. I see designers look at it as different entities when I see them all as one thing(storage locations) therefore I can assume they should be handled as one entity not 2 or 3. Am I right?
2- There are some attributes that only describe i.e storage bins i.e (X,Y and Z) which are corridor, shelves and height. Will that be ok to design it this way,
| Storage Places |
| ID |
| NAME |
| TYPE(WareHouse, Locations, Storage Bins) |
| Parent_Storage_place |
| X |
| Y |
| Z |