only for RuBoard - do not distribute or recompile |
This appendix contains a more complete list of the all the components of the Wine Club and the values for retrospection that have been assigned. Each component is classified by its type, which will be one of the following:
Behavior
Circumstances
Dimension
Relationship
The reason contains the business rationale for the choice as to whether the component has been assigned true, false or permanent retrospection.
Component Name | Type | Retrospection | Reason |
---|---|---|---|
Color | Dim | Permanent | The colors are assumed to exist forever. |
Time | Dim | Permanent | The days, once entered, will exist forever. Each year, a new years -worth of dates will be added but their existence, thereafter, is permanent. |
Hobby | Circ | Permanent | The hobby details, once entered, will exist forever. |
Manager | Dim | True | The Wine Club wishes to monitor the performance of managers over time. So the history of a manager's existence is needed. |
Customer | Circ | True | Customers may have more than one interval of activity. It is important to the Wine Club that it monitors the behavior of customers over time. There is a requirement, therefore, to record the full details of the existence of customers. |
Region | Dim | Permanent | Wine-growing regions are not expected to cease to exist. |
Sales | Beh | Permanent | Fact table entries exist permanently. |
Sales_Area | Dim | False | Latest existence only is required. Sales areas may be combined, or split. Only the latest structure is of interest. |
Supplier | Dim | False | Latest existence only is required. The supplier details are required, but no history. |
Wine | Dim | True | Wines may have a discontinuous existence as far as the Wine Club is concerned . It is important to track the history of the existence of wine. Questions such as How many wines do we sell today, compared to a year ago ? can be answered accurately only if we keep track of each wine's existence. |
Color?Wine | Rel | Permanent | The color of a wine will not change over time. This is a permanent property of the wine. |
Region?Wine | Rel | Permanent | The growing region of a wine will not change over time. This is another permanent property of the wine. |
Supplier?Wine | Rel | True | The suppliers of wines will vary over time. One of the objectives of the Wine Club is to monitor the performance of suppliers with respect to the popularity and quality of the wines they supply. Where necessary, the club will switch suppliers for wines. So there is a need to monitor this relationship over time. |
Wine?Sales | Rel | Permanent | The relationship of a particular sale to the wine involved in the sale will never change. |
Manager?Sales Area | Circ | True | Managers do move from sales area to sales area. There is a requirement to monitor the performance of managers. Therefore, it is important to keep track of history of their involvement with sales areas. |
Sales Area?Customer | Circ | True | There is a requirement to monitor the performance of sales areas. As customers move from one area to another, therefore, we need to retain the historical record of where they lived previously, so that sales made to those customers can be attributed to the area in which they lived at the time. |
Hobby?Customer | Circ | False | A customer's hobby is of interest to the Wine Club. Only the current hobby is required to be kept. |
Customer?Sales | Beh | Permanent | The relationship of a particular sale to the customer involved in the sale will never change. |
Time?Sales | Rel | Permanent | The relationship of a particular sale to the date involved in the sale will never change. |
Color.Color_Code | Att | Permanent | Identifying attribute rule. |
Color.Color | Att | Permanent | The color never changes. |
Time.Time_Code | Att | Permanent | Identifying attribute rule. |
Time.Day_Name | Att | Permanent | The value will never change. |
Time.Week_End | Att | Permanent | The value will never change. |
Time.Week | Att | Permanent | The value will never change. |
Time.Month | Att | Permanent | The value will never change. |
Time.Month_Name | Att | Permanent | The value will never change. |
Time.Season` | Att | Permanent | The value will never change. |
Time.Year | Att | Permanent | The value will never change. |
Sales_Area.Sales_Area_Code | Att | Permanent | Identifying attribute rule. |
Sales_Area.Sales_Area_Name | Att | False | The latest value only is sufficient. |
Manager.Manager_Code | Att | Permanent | Identifying attribute rule. |
Manager.Manager_Name | Att | False | The latest value only is sufficient. |
Hobby.Hobby_Code | Att | Permanent | Identifying attribute rule |
Hobby.Hobby_Name | Att | Permanent | The value will never change. |
Customer.Customer_Code | Att | Permanent | Identifying attribute rule. |
Customer.Customer_Name | Att | False | The latest value only is sufficient. |
Customer.Customer_Address | Att | True | Requirement to analyze by detailed area down to town/city level. |
Customer.Date_Joined | Att | False | The latest value only is sufficient. |
Region.Region_Code | Att | Permanent | Identifying attribute rule. |
Region.Region_Name | Att | Permanent | The value will never change. |
Region.Country | Att | Permanent | The value will never change. |
Supplier.Supplier_Code | Att | Permanent | Identifying attribute rule. |
Supplier.Supplier_Name | Att | False | The latest value only is sufficient. |
Supplier.Supplier_Address | Att | False | The latest value only is sufficient. |
Supplier.Supplier_Phone | Att | False | The latest value only is sufficient. |
Wine.Wine_Code | Att | Permanent | Identifying attribute rule. |
Wine.Wine_Name | Att | False | The latest value only is sufficient. |
Wine. Vintage | Att | True | There is a requirement to analyze popularity of wine by vintage. The vintage of a wine changes from time to time, approximately yearly. |
Wine.ABV | Att | False | The latest value only is sufficient. |
Wine.Bottle_Price | Att | True | There is a requirement to analyze popularity by price ranges and to determine how changes in price affect popularity. |
Wine.Case_Price | Att | True | There is a requirement to analyze popularity by price ranges and to determine how changes in price affect popularity. |
Wine.Bottle_Cost | Att | True | Requirement to analyze changes in cost versus revenue. |
only for RuBoard - do not distribute or recompile |