Document Details

Title Entity-relationship diagram for the Research Projects tables in the GCE_Submissions database
Archive All Files / Documents / Informatics / Database Schemas
Abstract

This PDF file contains an annotated database schema image (entity-relationship diagram) for the research project management tables in the GCE Submissions Database (GCE_Submissions), as implemented using SQL Server 2000. The diagram lists all tables and attributes as well as attribute data types and foreign key relationships between tables. This database is used to manage research project information linked to personnel, publications, study sites, data sets and other resources managed in GCE databases. Registered research projects can be viewed at http://gce-lter.marsci.uga.edu/public/research/projects.asp, and also from links on GCE research question pages and data set summary pages.

This database was designed to comply with the LTER Projects Database schema (http://intranet.lternet.edu/im/project/LTERProjectDatabase), and project-eml XML documents are dynamically generated using database views and a web application.

Contributor Wade Sheldon
Citation

Wade Sheldon. 2009. Entity-relationship diagram for the Research Projects tables in the GCE_Submissions database. Georgia Coastal Ecosystems LTER File Archive, University of Georgia, Athens, Georgia. (http://gce-lter.marsci.uga.edu/public/app/resource_details.asp?id=376)

Key Words database, diagram, ERD, im, information management, research projects, schema
File Date Oct 09, 2009 (version 1)
Web Link PDF file
view/download PDF file
(89 kb)
LTER
NSF

This material is based upon work supported by the National Science Foundation under grants OCE-9982133, OCE-0620959 and OCE-1237140. Any opinions, findings, conclusions, or recommendations expressed in the material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.