Appendix A. Wine Club Temporal Classifications

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