Before resorting to the outline It are, must comprise the processes operated you of the MV
well.
In this way, every single operation, important to the ends of the operation of the MV and its operativity,
must be described from Entity or Relations.
Main the operating process, managed directly from the Virtual Warehouse,
is what it allows to even resupply the district warehouses that have finished the supply of a good for the maintenance
and have urgent need of a resupply, because an unexpected breakdown has been taken place or they are badly calculates the
times to you of normal supplying, and therefore are not possible to attend reintegro from ordinary supplying. In the case
in which the real warehouse it previewed not to make it until next ordinary supplying, it emits one demanded to the MV,
after to have of see the eventual situated availability on the operating one of the Virtual Warehouse.
As an example,
what the customer can visionare on situated the operating one of the MV is one table like that follows.
If the customer
send the code trades them of a product or its description, it will be able see the availability and to comprise if set
up table corresponds to the characteristics demanded through one therefore:
| Article |
Description |
Cost |
Amount
Available |
| 006012-8201 |
Discs pushers on spheres |
100 |
10 |
| 11Ü6ES981OJA11 |
Filter for PLC Siemens |
200 |
30 |
| 1234556-111 |
Stylus allocation gauge |
450 |
10 |
| 445ff6677-77 |
Autofrenante motor Siemens Nr.XXX 50Hz
380V 0,42° for commander 978 |
550 |
5 |
| 1234567-123 |
Regenerative TagliaFustiAAA lathe 50Hz, 380V |
350 |
5 |
Selecting "it captures" starts the demand process and from that moment in then it must only attend that the material comes
delivered to it.
An other typical action for the customer is that one to make available a member or of the material of
maintenance in kind.
All the material that it will want to make available to the rest of the district customers will come
send in one table similar to that previous one.
We see which are the fundamental passages and what comes generated to
level machine.
The customer will demand through one particular mask a specific type of material in one determined amount.
It, unconsciously has formulated one "query", that is one demanded of information, to the table of the "virtual lyings";
the obtained answer will generate one table like that previous one, with the eventual amount available.
The table on which
the demanded information are available several contains also gives you relati you to who possesses the good available and other
previous information on its company, reliabilities, orders; in other words its "history" in the relationships with the MV.
Important to put in evidence that all this give you "personal" is accessible only to the MV and not to the customers, for obvious
reasons trades them.
Once carried out the demand could turn out multiple availability, and then in the generated answer
they will come visualized the various availabilities and the various prices.
It will be to the customer to choose the more
adequate supply based on the price and to the offered amount.
The last step is that one of the emission of the bubble,
completes of all the identified ones to you necessary in order to identify the store clerk, its times and its quality.
The Virtual Warehouse carries out a linear role, but the information obtained with these simple information are incredible
and could be used in the Datawarehouse.
The passage to the outline Entity Relations is simple, and reflects in not sequenziale way in the time the logical process of
the MV.
In the following outline the Entities and the Relations are brought back.
Endured after, in reference to the
same ones, they come exposed the single attributes of the entities and the relations, that they will allow to characterize with
thoroughness the occurrences of the same ones.
The numbers between parenthesis, to flank of every relation, are not other that the "cardinalità", and describes the minimal and
maximum number of the entities that can participate to the relations.
They can be:
- Relations one by one, for which to the relation single occurrence of entity for time and both participates one.
- Relations one to many, for which to the relation for a single occurrence of entity of one of the two participants
varied occurrences of the other.
- Relations many to many, for which it is worth also the viceversa of the previous one.
As an example, in the case of the entity "warehouse that it demands", to the relation demanded emission "can also not participate
all the warehouses, and therefore the minimal presence is" 0", while every issued demand makes reference to and a single
warehouse, and therefore the maximum cardinalità is "1", for the entity "warehouse that it demands", in the aforesaid relation.
In the case instead of the demand, every single it has been emitted from a single warehouse, therefore the minimum is
"1", while more demanded they can be emitted from the same warehouse, from which cardinalità maximum "N".
Finally, it must
remember that an equal minimal cardinalità to "0" indicates that the participation to the relation is partial, that is the
occurrence can or it cannot participate to the relation.
Instead, greater a minimal cardinalità of "0" indicates a
participation total, that is there is existential dependency, and ciascuna entity participates to the relation.
In
the previous diagram, like saying, the attributes lack.
The attributes of the "demand" must contain:
- Identificator of the demand
- Identificator of the warehouse that it demands
- Identificator of the demanded product
- Description of the demanded product
- Quantitative demanded
In order to identify the single occurrence of the entity, enough to know the identificativo of the demand.
The attributes of the lying near the warehouses and the conveyors, for every type of product, will be identify give to you:
- Identificator warehouse
- Identificator produced (univoco for all the District)
- Produced description
that they are identificators exteriors because they come from the relation of the lying with the demand for supply.
The only attribute just of the entity is the amount available.
Same thing is said for the noticeable
lyings near the conveyors.
The occurrences will be identified only from the produced identify and of its description, with to
that one of the warehouse and form the primary key, that is are attributes that entirety identify the only availability;
to notice that the produced identify alone not enough, because it must maintain like key also the technical characteristics
of the product.
Once arrived the demand, after to have verified the lyings, the accessory characteristics of the
warehouse, which position are controlled, the nominal maximum lying, owner and they become part in the written documentation
of the bubble.
Same speech is feasible for the
characteristics of the conveyors.
Once the previous operations carried
out, and verified that all the actors of the process are available, the MV can emit the bubble.
To notice that the insertion
of the delivery date comes postponed to the effective delivery, and moreover bubble and demand for supply they have two different
values of identification because it is possible that the quantitative one of goods is different.
The Virtual Warehouse could have also
the task to choose the optimal distance for the conveyor, based on the characteristics of means, the practicability and the
degree of reliability of the conveyor, in connection with the importance and urgency of the delivery.