|Watson, C, Baker, G, and Nayembil M. 2014. Open geoscience data models: end of project report. British Geological Survey Internal Report, OR/14/061.
This appendix contains a series of screenshots and diagrams that relate to the work carried out and outputs generated throughout the project.
Selected data model diagrams
High level entity relationship diagram for the borehole data model.
Full entity relationship model diagram for the Borehole data model.
High level entity relationship model diagram for the Geochemistry data model.
High level entity relationship model diagram for the Lexicon of Named Rocks data model.
High level diagram for the spatial metadata data model.
Each of the child tables (light green) in the high level diagram were further explained by additional figures showing the logical structure of the data model, as shown over the next two pages.
Example of scripts
Sample of the SQL scripts for the creation of Borehole data model in an Oracle implementation.
Sample of the SQL scripts for the population of an Oracle implementation of the borehole data model, the data includes example dummy values as well as content for the dictionaries of controlled terms used in the design.
Example of the results from the questionnaire handed out at the 24th meeting of the Colloquium of African Geology (CAG24).
Diagram to show the components which make up a downloadable database design package.