Entity – Relationship Model for Biodiversity Database
Lecture 3 in Big Data Analytics reviewed some of the fundamental database concepts.
One aspect of INSC 584 (Database Management Systems) that I did not like was that the course textbook provided examples from “Pine Valley Furniture Company.” However, for Big Data Analytics, I’m taking the opportunity to explore a database that I find more interesting: the All Taxa Biodiversity Inventory Database for Great Smoky Mountains National Park.
This database has 52 tables. It’s online as a cold fusion site (which is in the process of being replaced with Microsoft SQL Server). It was formerly downloadable online as an Access database; however, the downloadable file appears not to be available as of January 2014.
Also online is an entity-relationship diagram: <http://dlia.org/sites/default/files/access_relationships.pdf>.
The 52 tables are drawn up into broad categories:
- Collection Details
- Scope Dependent
This is a useful database for me to study because I find it interesting. So, I’m grateful that the ER diagram is online.