Table of Contents
The Brewstats Database is a SQL Server 2005 Express Edition database that stores and processes all the supplied by Brewers and Liquor Boards.
A big challenge for Brewstats is that it must combine the different reports supplied by each provincial Liquor Boards into a single generalized format. Whereas some provinces provide product level volumes identified by UPC, another province may provide product level volumes by an internal identifier. As well, some provinces only provide volumes at an aggregate level (neither product nor brewer). Some provinces do not province any data. To deal with all these situations, each province will have its own Product Table.
Handling Data Changes
The following table describes each table in this database:
Table Name | Source Data | Description |
---|---|---|
master_brewer_list | Various | Row 1 Col 3 |
master_province_list | Static | A list of all the provinces in Canada |
master_country_list | Derived from Liquor Board data | Row 3 Col 3 |