Please take a the main blog content on relational databases
Then you will be required to create a small relational database for invasive species. You will work in groups of three.
Please take a look at the invasive species database task - note this year this is not one of your course assignments so you will not be required to include all the details we will set up the tables for the database as an
Paul J. Morris (2005) Relational Database Design and Implementation for Biodiversity Informatics. You will find all the concepts in the introductory section of the paper. It then goes on to discuss the specialized taxonomic database concepts.
Bruce Maxim SQL Design and Implementation (ppt) this power point discusses SQL which we will take a look at in class and use in the exercise below.
There are also additional readings on the main blog page