databasedesigndocumentation（d a tabasedesigndocumentation）.doc

Database design documentation Data System Overview: This overview section contains a list of each table and their relationships with each other – brief and general. I would like to have a graphic showing the links, similar to what Dave did in the PowerPoint slides. The STEWARDS data management system contains three components. They are the CEAP watershed measurement data, the ARS Methods Catalog, and the STEWARDS System Support data files. The CEAP watershed measurement data are located in a suite of data table pairs (Data table and Data Definition table). The tables are assembled and populated by watershed personnel. Watershed data will be managed as a collection sites with a common theme as derived from individual measurement devices, i.e., South Fork Meteorology - Temperature, rainfall, atmospheric pressure, wind. Site measurement data will be managed by unique SiteID/DateTime pairs, with measurements as additional column headings using generic column names mapped to detailed information in the Definition table. The tables include: Data Tables – These tables contain the watershed’s measurement data and are described by the Data Table Definition. Data Table Definition Table – This table describes all the measurement data tables provided by the watersheds. The Definition table will maintain the relationship between the data producer’s data-table specific column names and the ARS Methods Catalog. The ARS Methods Catalog contains essential information to explain the characteristics of the measurement data. The tables provide users information to accurately understand the measurements. The table values are populated by watershed data producers assisted by a science review committee. The Methods Catalog is currently housed as a MS Access database and is accompanied by a suite of tools that may be used to populate the Methods table, Analyte table, and the Parameter table. These tables include: Parameter Table – This is the key table for user queryin