Back to the Data Model.
The Area being Modelled is :-
A Data Model for Wine Lists
The Requirements have been defined by a review of the Waitrose Wine and Spirits List.
Barry has defined the 'Things of Interest' as follows :-
A.5 Others to be determined
The Business Rules are as follows :-
B.1 A Region is always in a Country
B.2 A Wine is always associated with a Country
B.3 A Wine is sometimes associated with a Region
B.4 Every Wine has a Colour, including Champagne
B.5 Every Wine has a Year
B.6 Non-Vintage Champagnes do not have a Year.
Therefore the Relationship between Years and
Wine is optional at the Years end.
© DataBase Answers Ltd. 2011