The Digital Energy Atlas and Library (DEAL) database

This is a technical report describing the relational database designed and implemented for phases 1 and 2 of the DEAL project (Digital Energy Atlas and Library). The first part of the report gives a brief description of the DEAL project. This is followed by the project scope and business rules that governed the database design: the data types to be stored, and how the entities should be related and attributes should be constrained. Several entity relationship diagrams of the logical model are included. The resulting Oracle implementation is described by a full table and column listing; database constraints and other database objects are listed in an appendix.