| # Relazioni tra tipi di entità (tgerm1140s000) Utilizzare questa sessione per maintain the entity-type relationship details. Argomenti correlati Entity Relationship Modeling Diagramma entità-relazioni (ERD) A graphic design of the relational data model structure. The diagram shows a (multilevel) structure that consists of entity types and entity type relationships. Entity Rel. Diagram The description or name of the entity-relationship diagram. Nota The maximum length of the description is 60 characters. Versione A group of model items that share some characteristics, such as the customer, owner, and effective date. Version The description or name of the version. Relazione tra entità A reason of relevance for associating entities of one or two entity types. Da tipo di entità The first entity type in the entity-type relationship. Esempio The entity relationship between an order and an order line is a 1:N relationship. An order is related to one or more order lines. Vice versa, an order line is related to only one order. In this entity relationship the order is the first entity type. From Entity Type The description or name of the entity type. A tipo di entità The second entity type in the entity-type relationship. Esempio The entity-type relationship between an order and an order line is a 1:N relationship. An order has one or more order lines. Vice versa, an order line is related to only one order. In this entity-type relationship the order line is the second entity type. To Entity Type The description or name of the entity type. Descrizione Da-A The description that identifies the from-to relationship. The description must be a verb in the third person singular. Esempio An order is detailed by one or more order lines. For this relationship the From-To description is: is detailed by. if the relationship is a horizontal line with the name located above, then the diagram should be read from left to right. If the name is located underneath, then the diagram should be read from right to left. if the relationship is a vertical line with the name located on the left, then the diagram should be read from top to bottom. If the name is on the right, then the diagram is read from the bottom up. Descrizione A-Da The description that identifies the to-from relationship. The description must be a verb in the third person singular. Esempio An order line details an order. For this relationship, the To-From description is: details. if the relationship is a horizontal line with the name located above, then the diagram should be read from left to right. If the name is located underneath, the diagram should be read from right to left. if the relationship is a vertical line with the name located on the left, then the diagram should be read from top to bottom. If the name is on the right, then the diagram is read from the bottom up. Relazione tra tipi e sottotipi di entità Se la casella di controllo è selezionata, the entity-type relationship is a subtype relationship. Relazione con database fisico esistente Se la casella di controllo è selezionata, the entity relationship is equal to an ERP data dictionary relationship. Tabella associativa An entity type that is used to link two other entity types that have a many-to-many relationship between them. Associative Table The description or name of the associative entity type. Categoria relazione A division within a system of classification. Most model items can be categorized. Relationship Category The description or name of the category. Cardinalità minima Da-A Infinito Se la casella di controllo è selezionata, the maximum from-to relationship is infinite. Cardinalità massima Da-A Cardinalità minima A-Da Infinito Se la casella di controllo è selezionata, the maximum to-from relationship is infinite. Cardinalità massima A-Da Proprietario The login of the owner. Owner The name of the owner. Data di generazione BY default, the date when the entity relationship was generated. However, any authorized user can change the date into another date. Scaduto Se la casella di controllo è selezionata, the entity relationship has expired because the version it is in is no longer valid. Utente ultima modifica The login of the user who made the latest change to the entity-type relationship. User Last Change The name of the user who made the latest change to the entity-type relationship. Ultima modifica The date when the latest change was made to the entity-type relationship. Testo Se la casella di controllo è selezionata, text is available that provides you with more information about the entity-type relationship. |