Table 2.  Sediment chemistry table from the U.S. Environmental Protection Agency (EPA) 

[A sample of data from EPA's Environmental Monitoring and Assessment Program (EMAP) sediment chemistry table is shown here (Macauley and Summers, 1998; and EMAP).  It is one of several tables in a relational database as shown in figure 2.  Note that the parameters (chemical measurements) under ANAL continue "vertically" through the full list before the sequence is repeated for the next station. The use of the DATE field here departs from the "normalized" relational model because it is dependent on STA_NAME, and also it is duplicated in the station data table.]

Back to Relational Databases

USGS Privacy Statement and Disclaimer