Table 12.12 Data items
Domain | Description | |
Color Code | Color Code | The short name of one of the standard ice cream colors. |
Color Name | Short Name | The full name of one of the standard ice cream colors. |
Ice Cream Cone Sugar or Wafer Indicator | Sugar or Wafer Indicator | Determines whether the ice cream cone is made of a sugar-based or wafer-based material. |
Ice Cream Container Height | Height | The height, in millimeters, of the container. Used by inventory to determine how many containers can fit on a storage shelf. |
Ice Cream Container Name | Short Name | The name our store employees use for communicating with consumers on what they would like to order. |
Ice Cream Container UPC | Ice Cream Container UPC | A numeric code used to identify a specific product across the ice cream industry. |
Reuse all the data items you’ve just created to create the attributes shown in Table 12.13.
Table 12.13 Attributes for Color, Ice Cream Cone, and Ice Cream Container
Entity | Data Item |
Color | Color Code |
Color | Color Name |
Ice Cream Cone | Ice Cream Cone Sugar or Wafer Indicator |
Ice Cream Container | Ice Cream Container Height |
Ice Cream Container | Ice Cream Container Name |
Ice Cream Container | Ice Cream Container UPC |
Create the attributes on the Order entity as shown in Table 12.14 – the data items do not exist yet.
Table 12.14 Attributes for Order
Attribute | Domain | Description |
Order Number | Standard Identifier | The unique number assigned to each order placed by a consumer. It is a numeric sequence number that never repeats. |
Order Placed Date | Standard Date | The date the order was placed. |
Order Total Value | Standard Large Value | The total value of the order in the default national currency, including any applicable sales tax. |
Key Points · For every Conceptual attribute, there is always a data item. · Use domains to manage the characteristics of your data elements. · Combine data items and the Glossary for data governance. · Data element properties are transferred between objects and between models. · A replica is a synchronized copy of the original object; you control the synchronization. · The generation links viewer eases visualizing the impact of change at the model level. · Impact and lineage analysis visualizes the impact of change at the object level. · 'Drag and drop' saves time - remember to drag with the right mouse button. · Use dependency matrices to review and create links between any two types of object. |